I have a formula that makes a list of unique employee names that I am trying to alphabetize. The problem is there can be 2-50 (range A1:A50) employees within the list causing the alphabetize rank formula to count blank or 0 cells due to having a formula in that cell. Is there a way to use a dynamic range formula to not include the cells that contain 0 or blanks? So would it be possible to have the COUNTIF dynamically rank A1:A10 since A11:A50 are blank?
Current formula in B1:
Desired Result:
<tbody>
</tbody>
Current formula in B1:
Code:
=COUNTIF($A$1:$A$50,"<="&A1)
Desired Result:
Employee name | Alphabetize rank |
GRAY,BOBBY F | 3 |
PARK,AMY G | 7 |
JOHNSON,BONNIE | 5 |
HARTFORD,ERIN Q | 4 |
STEEL,ASHLEY | 8 |
DOWEL,LOUIS | 1 |
WORD,LARRY F | 9 |
DUNCAN,HARRY W | 2 |
YOUNG,RICK R | 10 |
KNIGHT,MELISSA R | 6 |
<tbody>
</tbody>