Rank sequential numbering and skipping certain criteria
I am looking to create sequential numbering on employee numbered list within their respective cost centers but also looking to skip certain criteria such as TBHs. I am currently using RANK(1, ASCENDING, SEQUENTIAL, TRUE, LIST) which works well for numbering within the cost center but includes all members of the Employee (#) list. I would like to skip or ignore TBHs that are in the list. Below is an example of what I would like to see.
List - Employees (#)
Adam Smith 1
Jane Doe 2
Tom Miller 3
Any thoughts on how to get the sequential numbering to skip members of the list based on any number of attributes?
Thanks in advance!