S
Scottmk
Sure:
=IF(Data!C4="-","-",PERCENTRANK(Data!C$4:C$47,Data!C4,1)*10+(Data!C4<>MAX(Data!C$4:C$47)))
What happens is data can extend well beyond C47 or well under. I alsl
have many categories, so it would be a pain to have to change thos
numbers in each formula. Thanks Fran
=IF(Data!C4="-","-",PERCENTRANK(Data!C$4:C$47,Data!C4,1)*10+(Data!C4<>MAX(Data!C$4:C$47)))
What happens is data can extend well beyond C47 or well under. I alsl
have many categories, so it would be a pain to have to change thos
numbers in each formula. Thanks Fran