Hi,
I am looking for some help with the index match with alphabetical order formula, I have in col c and I in the attached spreadsheet.
Hi,
I am looking for some help with the index match with alphabetical order formula, I have in col c and I in the attached spreadsheet.
Last edited by btparkhe1920; 01-18-2021 at 05:37 AM.
Try this:
=IFERROR(INDEX($B$3:$B$8,MATCH(0,COUNTIF($B$3:$B$8,"<"&$B$3:$B$8)-SUM(COUNTIF($B$3:$B$8,$C$1:C1)),0)),"")
**Array formulas are not entered in the same way as 'standard' formulas. Instead of pressing just ENTER, you first hold down CTRL and SHIFT, and only then press ENTER. If you've done it correctly, you'll notice Excel puts curly brackets {} around the formula (though do not attempt to manually insert these yourself).
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
thank you so much, This has made my work so easier
C3 cell , array formula , drag down
HTML Code:
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Also, you may not be aware that you can 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.
thank you so much
Did you understand the instructions about marking the thread as solved?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks