Mike thanks for another great video. I am still learning how the RANK function works. In the meantime, I have come up with the following formula. It works perfectly, but please give your comments. You normally come up with very robust ideas and formulas:=INDEX($C$12:$G$12,,MATCH(LARGE($C13:$G13,COLUMNS($C$18:C18)),$C13:$G13,0))
ExcelsFun, Thank you for the work. I have a question...how could I use an index match after the one you provide in your video to link back the numbers from Row 13 for example to the states that we would get on Row 18? We would then end up with something like "US - 15", "IL - 13" in Row 18. Thank you.
Dear birdyflu ,
Did you download the workbooks I have available? They have the actual formulas finished for you to look at.
--excelisfun
Mike thanks for another great video. I am still learning how the RANK function works. In the meantime, I have come up with the following formula. It works perfectly, but please give your comments. You normally come up with very robust ideas and formulas:=INDEX($C$12:$G$12,,MATCH(LARGE($C13:$G13,COLUMNS($C$18:C18)),$C13:$G13,0))
ExcelsFun, Thank you for the work. I have a question...how could I use an index match after the one you provide in your video to link back the numbers from Row 13 for example to the states that we would get on Row 18? We would then end up with something like "US - 15", "IL - 13" in Row 18. Thank you.
Amazing Mr.Girvin
: )
I copied out the same formula with same coordinates its giving #n/a Error