Hi All,

I want a formula in my attached sheet of Data column which can retrieve value from each row except text value "No". In each row there are 3 cells which has "No", and in one either 'a','b','c','d'. I want formula to retrieve that a,b,c in data column.

Thanks in advance.

Nilankar

Data a b c d
No No a No
c No No No
No b No No
No No No d
a No No No