Avatar of surah79

asked on 

Compare Adjacent Cell In Excel excluding if the cell is blank

Hi Guys

I am trying to compare the adjacent cells , if the cells are blank skip the cells go to another one.
if all the cells have the same value then it should type as "N", if any of the cells has different value then it should be Y.
Cell1=Empty, Cell2 = Empty, Cell3 = 4:00:00, Cell4=4:00:00  then it should be "N"
Cell1=1:00:00, Cell2 = Empty, Cell3 = 5:00:00, Cell4=3:00:00  then it should be "Y"
Microsoft ExcelSpreadsheetsMicrosoft Office

Avatar of undefined
Last Comment
Excel amusant

8/22/2022 - Mon