Numbering a unique sort

[NWE]

Hey,

I am wondering how to number a unique sort. For example I have attached an image of a data set. There are 505 unique records in column Q, and I would like to number them in column R in numerical order, ignoring the gaps on the lines. Any advice?
24143

[Bob Phillips]

Use a simple formula. In R2 enter


=IF(Q2<>"",MAX($R$1:$R1)+1,"")

and copy down

[NWE]

Thank you for that, that got it perfectly!