#### BenRichards

##### New Member

- Joined
- Apr 7, 2014

- Messages
- 41

=IF(COUNT.IF($GR$3:$GR$18;"<="&GR3)=0;" ";(COUNT.IF($GR$3:$GR$18;"<="&GR3)))

Hi everybody. I'm having trouble understanding the above formula. If there are different letters in the range $GR$3:$GR$18, this formula will give a number of how the letter in question (in cell GR3) relates to the others, what the letter's number would be if we were to sort the letters from smallest to largest.

However, if I enter numbers in that range, the formula returns nothing. I'd like for it to work with both letters and numbers. Any ideas?

Hi everybody. I'm having trouble understanding the above formula. If there are different letters in the range $GR$3:$GR$18, this formula will give a number of how the letter in question (in cell GR3) relates to the others, what the letter's number would be if we were to sort the letters from smallest to largest.

However, if I enter numbers in that range, the formula returns nothing. I'd like for it to work with both letters and numbers. Any ideas?

Last edited: