RANK using an approximate value match.

[Mike Slattery]

I am using RANK but because the values in the Range are calculated the number that I am trying to determine the rank of does not match.

Is there a way of doing an approximate match using the rank function.

I tried FLOOR but that did not eliminate my problem.

Thanks, Michael

 

[mikerickson]

=FREQUENCY(A1:A10, 43.5) will give the count of numbers in A1:A10 that are less than or equal to 43.5

If there are no duplicates in A1:A10, this is similar to RANK.

 

[Mike Slattery]

That's perfect, thanks,

Michael