I have a list of names. For each name in the list, the cell to the left of the name will either be blank, or marked with an "X". In the column to the right of the list, I need a formula that will number the names in order starting with "1" at the top, but will EXCLUDE all of the names with "X" in the cell to the left. The result is that when I "choose" a name from the list by marking it with an "X", the name will be removed from the rankings.
For example, my top 5 names in the list will have numbers 1-5 marked in the column to the right, but when I put an "X" beside the 3rd name in the list, the cell to the right of the 3rd name will become blank, and the 4th name will then take the number 3, and all names below that will have their numbers change in order from 4 to the end of the list.
I'm attaching a file that shows what I want the result to look like, but I need a formula to make it work.
Thanks.
Bookmarks