Go Premium for a chance to win a PS4. Enter to Win

x

Microsoft Excel

132K

Solutions

37K

Contributors

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Share tech news, updates, or what's on your mind.

Sign up to Post

Once upon a time at a core conference this happened. It is one of those amazing moments when Experts get intrigued by a fun puzzle to solve.

Do you have a favorite question or other piece of content like this?  Would you like to see us facilitate more items like this or have an idea that would make your time here more enjoyable? Let me know by commenting on this post or messaging me.
4
 
LVL 17

Expert Comment

by:Kyle Santos
TIL: AngelIII is not 'Angel 3' but Angel Eyes.
0
Hire Technology Freelancers with Gigs
LVL 11
Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

I am using Excel 2016
I am making a material inventory list which will also include the amounts required to produce each of our model types.
.
Column "F" is the current "quantity in stock" of every part in my inventory
Columns H, J, L and N are the amount of that material required to produce each unit type.
On my "asset list" tab I have a completed unit stock list. As each unit is serial numbered I am entering each unit on a separate line. There are columns for each unit type.
I am trying to make so when I enter the number 1 in any of those 4 columns on the "Asset list" that the amount of material required to produce (columns H, J, L and N) will be subtracted from column F (quantity in stock)

EXSPREADSHEET.png
0
 
LVL 24

Expert Comment

by:Tom Cieslik
Please ask question (not post)  if you need help from our community
0
1
Hello!

Here's the issue: I've got three columns of data: Individual, Amount Sold, Date Sold.

People have multiple sales for each given date.

I want to find each person's best night, i.e. all the sales for each given date combined for that date, and then I'd like to see the max for each individual, so I can show them their best night.

I can do this by creating a new sheet with three columns, one containing every date from 1/1/17 to 12/31/17, the next containing the name of a single person, and the third containing a SUMIF formula, so that I have the sum of each person's sales for each day, and then take the MAX from that column. I am sure, however, that there is a better way. A PivotTable seems to only give me the largest single sale from each individual, instead of the night with the largest sale.

What's the simpler solution here?
0
 
LVL 12

Expert Comment

by:Andrew Leniart
Hi Cory, welcome to Experts Exchange.

What you have done is made a post here. To get expert help, you need to "Ask a Question" so that more experts are able to see you need help. Click the Big blue button near the top of your screen.

Ask-a-Question.png

The following link explains more about asking for help at Experts Exchange..
http://support.experts-exchange.com/customer/portal/articles/336330
1
 
LVL 22

Expert Comment

by:Roy Cox
Hi Cory, you need to look at a PivotTable with dates grouped by day
0
what is the maximum number of cells microsoft office 2013 excel application supports
0
 
LVL 9

Expert Comment

by:James Bilous
1,048,576 rows by 16,384 columns = 17,179,869,184 cells
2
 
LVL 66

Expert Comment

by:Jim Horn
Microsoft publishes pages on Excel Specifications and Limitations for every new version that answers tons of questions like this.
1
10
Helen Feddema is one of our resident Microsoft Access experts.  She just published two new articles today.  If Access is something you're interested in knowing more about, then follow Helen!
https://www.experts-exchange.com/members/Helen_Feddema.html
2
New member today got a solution today.

After searching the net for help it became apparent that there were professional contributors on your site willing to provide expert advice. The advice given was very fast and first class.

Fred
This was their question that was answered.
https://www.experts-exchange.com/questions/29012797/Create-Dynamic-Range-Via-VBA.html
3

Microsoft Excel

132K

Solutions

37K

Contributors

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.