Combing Max and IF functions
I have a list of names in say column A and adjacent to the names in column B are numerical values associated with the names. What function could I use to place the name with the max value in another cell and the name with the second highest value in another cell. Any insight would be appreciated.
- Joe
See if the attached sheet helps.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Perfect! Thanks sktneer
Glad it helped. Thanks for the feedback.
If that takes care of your question, please mark your thread as solved by selecting Thread Tools --> Mark thread as solved.
Moreover you may also click on * (star) to Add Reputation to those who have put their time and efforts to help you in this forum. This is another way to say thanks to them.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks