Hi all,
I’m trying to rank a column, Advisor Name, by YTD Production. However, there are null and 0 values in the YTD Production column. When I do a rank, it ranks the advisor names with null values first and then ranks the rest of the names. So then I tried this formula :
=If (Not(IsNull()) Then Rank(,) —> But this does not start with ranking number 1. So then I tried this formula :
=If (IsNull()) Then 0 Else Rank(,) —> But this gives error message “Incorrect Data Type”.
Can any one suggest alternatives?
Thanks in advance.
Cindy.
NOTICE
If you are not an authorised recipient of this e-mail, please contact Mercantile Mutual immediately by return e-mail or by telephone on +61-2-9234 8111. In this case, you should not read, print, re-transmit, store or act on this e-mail or any attachments. Please destroy the message and attachments. This e-mail and any attachments are confidential and may contain legally privileged information and/or copyright material of Mercantile Mutual or third parties. You should only re-transmit, distribute or commercialise the material if you are authorised to do so.
This notice should not be removed.
Listserv Archives (BOB member since 2002-06-25)