Link to home
Start Free TrialLog in
Avatar of philosopher76
philosopher76Flag for Mexico

asked on

How to show in excel the days with higher sales within a month?

I have a small food business. I made a worksheet to manage and control sales each day. Thanks for your help.
Avatar of Wayne Taylor (webtubbs)
Wayne Taylor (webtubbs)
Flag of Australia image

There are a number of different ways to achieve this, but it would definitely help if you could post your workbook.
Avatar of philosopher76

ASKER

Thanks. Here is the file. Would it be possible to get the three days with higher sales, or all in a decreasing order? I mean if Excel can show something like this: In average Mondays are the days with higher income, after Fridays and finally Sundays. The information is in columns A and D.

Again thanks for your help.
RVC-JUNE-2015.xlsx
ASKER CERTIFIED SOLUTION
Avatar of Ryan Chong
Ryan Chong
Flag of Singapore image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
You may also consider Condition Formatting or using RANK function to put a sequential number for your values.
Avatar of Professor J
Professor J

please find attached template
tm.xlsx
You've already been provided with data
A bit off topic, but I suggest you might want to consider using an excel as the data entry into a Database (Access, or MS sql (express))

This way you can have on going and much more versatile report.
weekly, monthly, yearly, etc...... comparison to seasonal/etc.
Here is a (non affiliated link to a tutorial) that might be helpful.
http://www.datawright.com.au/excel_resources/excel_access_and_ado.htm
Hi

If you looking for the highest sale within a month then try   =MAX(D3:D32)

if you are looking for the order from max to min the in your excel delete the row 2 so that there are not empty lines then highlight the entire excel sheet clicking at the top above row 1 and beside column A then
go to Data tab and select Sort and then
select my data has header and then
select the column you want it to sort say Sales
select highest to lowest values option and then
sort
you will then have values from the highest to the lowest sales
For something like this, I'd normally go to Conditional Formatting and the heat maps - see attached example.  
This is done by selecting the column of data you want to compare - Conditional Formatting.. Colour Scales.. and then choose the colours you want.  The only problem with heat maps is that one freak result can result in all other results getting "washed out" by comparison.  See for example the high Expenses value on Tues 9th.

I had to take some guesses as to which columns had  high=good, and also where high=bad, but think it's OK?

I also tidied some other areas - the percentages, and also if you now enter the 1st day of the month in cell B3, the rest of the cells nearby will update automatically.
M--Personal-ee---RVC-JUNE-2015---conditi