I want to automatically number cells IF the cell next to it contains text.
If you look at the image, column V contains some blank cells, some with text. Column U numbers those cells with text sequentially. However, I did this manually and I want it to be automatic.
What formula (or, more likely, combination of formulas) would I use to return the number?
If needed, I can enter information into the blank cells, e.g. "FALSE" or "0".
Thanks so much!
Capture.JPG
Bookmarks