I get a file with a list of rooms. Some of the rooms repeat and others do not. It varies every time the file is generated. It looks similar to below:
RM 1
RM 1
RM 1
RM 2
RM 3
RM 3
RM 4
RM 5
RM 6
RM 6
RM 7
My goal is to put an "A" next to the first room and then a "B" next to the subsequent room and then back to an "A" alternating between the two letters. I want it to look like this:
RM 1 | A
RM 1 | A
RM 1 | A
RM 2 | B
RM 3 | A
RM 3 | A
RM 4 | B
RM 5 | A
RM 6 | B
RM 6 | B
RM 7 | A
What's the best way to do this in a singular formula?
Bookmarks