Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Table Help
I have created a table that displays the weekdays of the month, who has the
highest commission and how much they earnt in the form: Date | Seller| Commission | Day of the Week 01/06/09 | XX | £YY | Monday 02/06/09 | ZZ | etc.... There is also a box on the sheet near the top where you select todays date (which is used for an entirely different function.) The table is used for management purposes only, but a shorter version will be made public to the sales team. This needs to display the last 5 week - ie, working - days and the top seller and commission for that day. This will take a similar form: Day | Seller | Commission Monday | X | £ Tuesday | X | £ Wednesday | X | £ Thursday | X | £ Friday | X | £ Although it wont necessarily be in that order. as it is the last 5 working days it may be: thurs, fri, mon, tues, weds; or whatever the case may be. I am not entirely sure about the best foruma to use to create this table. My thought is to use a VLOOKUP on the "todays date" box (mentioned earlier) to look for the preceding weekdays date, 2 precedinging weekdays and so forth, on the initial table and displaye the corresponding day, seller and commission data. My main problem is working it so it only uses weekdays. Any suggestions? Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Table Help
Excel 2007 PivotTable
Show last 5 working days. User friendly formula. http://www.mediafire.com/file/dywb0tgzdjk/06_08_09.xlsx |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Macro specific table to generic table? | Excel Discussion (Misc queries) | |||
Pivot Table in Excel 2007 : Problem with % in Table | Excel Discussion (Misc queries) | |||
Excel Food Price Table, Programming, Is This Table All Right? | Excel Discussion (Misc queries) | |||
Create new excel table with filtered records from another table | Excel Worksheet Functions | |||
Excel Pivot Table Plugin? (crosstab to data table) | Excel Discussion (Misc queries) |