I have a row with names and then total for each name and I would like to identify which name had a total of 10000 and enter that in a cell at the end of the row. I've attached a sample sheet and in the row I would like the name 'Norman' to be in K1 as he had 10000 total but I am having problems figuring out a formula for this to happen. Any help is greatly appreciated.
MaybeFormula:
Please Login or Register to view this content.
Last edited by TMS; 11-24-2018 at 07:44 PM.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
That idea worked great and thanks for your response. You did have an extra bracket at the end of your formula and I needed to add an extra 0 but it doesn't bother me. Thanks again and thanks for the chuckle about the chickens in your signature.
You're welcome. Thanks for the rep.
Oops, so:Formula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks