I’ve got a table (example s/s attached), with:
Date in column A (table won’t necessarily be sorted by date, but could be if needed)
Person Name in column B
Sales in column C
I want to identify the largest Sales for each date (column D), so I can calculate each person's daily % of the largest daily sales (column E).
I’ve searched the web, and tried a wide range of functions, including array functions, but can’t find something that seems to work for my situation. It seems this has to be something others have encountered and solved - it’s not that unique.
Any suggestions would be greatly appreciated.
- Frank
Bookmarks