philosopher76
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.
There are a number of different ways to achieve this, but it would definitely help if you could post your workbook.
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
Again thanks for your help.
RVC-JUNE-2015.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You may also consider Condition Formatting or using RANK function to put a sequential number for your values.
please find attached template
tm.xlsx
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.
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
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
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
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