I want to use Excel to extract the distinct value from my range. Between the columns in this range, this value will fluctuate.
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
Which gave me the #NAME value. I also tried the other code from here:
with INDEX: MATCH function
I also got nothing.
I also tried with IF statement also:
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
How can I make my unique value visible in the cell below? How can I exclude all not valid records in this range?