Find a cell in a range and return the value of the cell that is unique from the others

[bluefish44]

I have 6 columns of data. Each column will have N as its value except for 1 of them (it could be in a different spot every time). I want to return the value of the one cell that doesn't have the N in it in the 7th column with a formula. So for example:

ABCDEF
NNNZNN

so in this case, in column H I would want the value returned by the formula to be Z

Thanks in advance for your help!

 

[MrKowz]

Try:

Excel 2013/2016
	A	B	C	D	E	F	G	H
1	N	N	N	N	Z	N	N	Z
Sheet2

Cell Formulas
Range	Formula
H1	{=INDEX(A1:G1,,MATCH(1,IF(A1:G1<>"n",1,""),0))}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[bluefish44]

Works great - thanks. Curious though, can this be done without an array formula?