Hello all, I am setting up a very simple (i thought) spreadsheet where we list cashiers names and how much in tours they sold for each day of the month, i have managed to work out the MAX formula and this returns the correct record but what i need is to return the users name who matches that record into a seperate cell, i have tried using the MATCH and INDEX formulas but alas i don't seem to be getting very far, any advice greatfully accepted.
Last edited by ausjarker; 12-29-2009 at 08:15 AM. Reason: SOLVED
Welcome to the Board.
Please Login or Register to view this content.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Wow, thanks so much for that DonkeyOte, works perfectly. Will now spend some time trying to nut out how it all works ....
Cheers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks