Hello, Excel Gurus:
Please help on this one!!
I have five columns of data. Some columns have data, some are empty.
Goal:
1. Create a new Column, with value "Yes" or Blank. And do checking.
2. For each row, check the five cells in those five columns, if any of the cells have value, then return "Yes", Else return Blank.
For Example,
"Mary", Blank, Blank, "Tom", Blank Result: "Yes"
Blank, Blank, Blank, Blank, Blank Result: Blank
My function:
IF(ISBLANK(F3:J3), ";", "Yes") "Yes" checking return correctly, However, if all cells are blank, it still return "Yes"
Please Help!!
Bookmarks