what is the formula?

i have a table with 4 columns. 3 of the 4 cells per line are the same ("No"). The 4th is different. I have about 100,000 lines.... If I want to display the one which is not "no) in the 5th column, w...