I am trying to match a winner of a contest which would be ranked number 1. The ranks can change by changing some of the data so I want the name of the number one ranked person would change as well.
Data Rank
Don $435 2
Mike $400 3
rich $300 4
bill $500 1
So I want the name Bill to populate in a cell. But if the dollar amount changes and his rank changes then I need the name of that number 1 rank
There are about 6 columns in between the name and the end rank
Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
See if the formulas in col c and also cell F1 are helpful...
That worked! Thanks. I was trying to figure this out for days. took half an hour after I asked the question on here. Thanks alot
Welcome to the forum.
Some tips.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Note:
You can also thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given.
By doing so you can add to the reputation(s) of those who helped and shared their time in helping you.
Thanks.
Nice to have you with us.
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks