Microsoft Excel

131K

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

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 21

Expert Comment

by:Roy Cox
Hi Cory, you need to look at a PivotTable with dates grouped by day
0
Free Tool: Path Explorer
LVL 9
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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

131K

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.