I am working with a large worksheet consisting of more than 30,000 rows. I have a need to populate "column A" of each row based on the value of six non-contiguous columns.
If all six columns ( Columns Q, T, W, Z, AC, AND AF) are valued with N/A or are Blank, then
"column A" for the row should have the word ORPHAN.
I know how to value base on one column << =IF(OR(Q415="N/A",Q415=""),"ORPHAN","") >>, but not multiples.
Thanks for the look!
If all six columns ( Columns Q, T, W, Z, AC, AND AF) are valued with N/A or are Blank, then
"column A" for the row should have the word ORPHAN.
I know how to value base on one column << =IF(OR(Q415="N/A",Q415=""),"ORPHAN","") >>, but not multiples.
Thanks for the look!