I want to use Excel to extract the distinct value from my range. Between the columns in this range, this value will fluctuate.![enter image description here](https://i.stack.imgur.com/3Eo34.png)
Between the N/A values, I have got the proper address, which I would like to have populated in the cell pointed below.
For this purpose I tried a UNIQUE function: https://exceljet.net/excel-functions/excel-unique-function
=unique(U3:U6)
Which gave me the #NAME value. I also tried the other code from here:
https://www.listendata.com/2013/05/excel-3-ways-to-extract-unique-values.html
exceljet.net/formula/extract-unique-items-from-a-list
trumpexcel.com/unique-items-from-a-list-in-excel/
with INDEX: MATCH function
=IFERROR(INDEX($U$3:$U$6,MATCH(0,COUNTIF($U$3:UE,$U$3:$U$6),0)),"")
I also got nothing.
I also tried with IF statement also:
=IF(U3:U6,"N/A+N/A+N/A","")
But I don't know how to extract the cell with other values than stated in the formula.
The combination of function INDEX:MATCH with COUNTIF also doesn't work
=INDEX(List,MATCH(0,COUNTIF(U3:$U$6,List)+(COUNTIF(List,List)<>1),0))
How can I make my unique value visible in the cell below? How can I exclude all not valid records in this range?