What function or layered functions am I looking for here? I'm needing cell DQ2 to populate either A, AB, ABC, ABCD, or ABCDE based on whether there is text in cells BM2-BQ2 respectively. Examples:
If BM2 is the only cell in BM2-BQ2 with text, then DQ2 populates "A".
If BM2 and BN2 have text, then DQ2 populates "AB".
If BM2-BQ2 all have text, then DQ2 populates "ABCDE".
Of note, BN2 will never have text if BM2 doesn't and so on. So you'll never have "ACE" or anything skipping letters.
I was able to make DQ2 look at just BM2, but am not sure how to expand that to look at the rest of the cells as well.
Thanks in advance!
Bookmarks