Hi Biff,

Thank you for your input and assistance.

T. Valko wrote:
Do we need to deal with possibly empty cells in columns B and E:I?

No

Also, based on your sample data, the first two ranks are 18. Will
there/might there be other ranks of 18 in column B?

Yes. Will I need a different Formula to Max's to take care of situations
where there will be other Numeric Labels with the same Rank value?

Please advise

Cheers,
Sam

--
Message posted via http://www.officekb.com