need help excel.PNG
I need some magic scientist excel help with this one. I *think* than logic (if then) would work with this, but I am not smart enough to figure it out.
I am also working with 180K rows of data. (By the way, if I am working with this large of a file, should I back it up with SQL?)
The riddle is: If cells from B2 to P2 (and all the 180K rows beneath those) are empty, but cell Q2 is not....then...(I would like a quick way to identify this. For me, the best way is to fill the cell in A with red & make the font white.
I've attached a screenshot for clarity.
THANK YOU excel family!!!
Bookmarks