If any row in column B = 100%, then pick the relevant Quartile number (i.e, Q1/Q2/Q3/Q4), else leave it blank.
I am attaching the sheet for reference.
I want to populate all the colored space with the relevant Quartile number.
Please help me out.
Thanks
Last edited by Shreyaanand; 09-30-2015 at 01:45 AM.
Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)
Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?
To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
(note: this change is not optional)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I have changed the title. Sorry! I could not think of a relevant title so posted like that.
http://www.excelforum.com/excel-gene...ml#post4203552
Hi,
Try the following formula in B7:
=IFERROR(INDEX($A$2:$A$5,MATCH(1,B$2:B$5,0)),"")
drag this to the right, see the attached file.
or
=IFERROR(LOOKUP(2,1/(B$2:B$5=1),$A$2:$A$5),"")
Please Login or Register to view this content.
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Thank You so much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks