Hello all,
I am trying to rank people based on hire dates, including prior service folks. How do I use the RANK statement for multiple columns? If a person was hired the same day as another, I would want the prior service column to be the tie-breaker. I will also add an additional column to include another tie-breaker.
Please find attached the sheet.
Thank you for your help.
I am trying to rank people based on hire dates, including prior service folks. How do I use the RANK statement for multiple columns? If a person was hired the same day as another, I would want the prior service column to be the tie-breaker. I will also add an additional column to include another tie-breaker.
Please find attached the sheet.
Thank you for your help.