Rank Function Help

[ashwin28]

Hi,

I have a Salesperson worksheet having the following structure:
Column A Column B
Person1 Sales
Person2 Sales
Person3 Sales
Sub Total
Person 4 Sales
Person 5 Sales
Person 6 Sales
Sub Total

and so forth. When using the RANK Function, I want to exclude the subtotal column in the range field else RANK Function will rank that also. How do I go about excluding the subtotal column in RANK functions range field ?

Thanks for replying

ash

 

[ashwin28]

Thank you Aladin, Joel & Barry for helping me out.

Have a nice day,

ashwin