I have 1,2,3,4,5 for cells A2,B2,C2,D2, and E2. I'm trying to figure a function wherein the first cell on row 2 that contains a number will result in ABC for A1 and the rest (i.e. B1,C2,D2,and E2) will result in ZZZ.
See image for clearer explanation.
Thanks guys.
Bookmarks