Hello!
I'm have a series of 4 cells, 3 of which read "---". The other cell reads a value that I want reported in my 5th cell. In other words, I want to display the value that <>"---". However, there will be multiple rows that require this logic and output, and the non-"---" value will not be in the same column every time. Any ideas how I can do that?
Cells.jpg
Thanks in advance!
Adam
Bookmarks