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
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