Forum Discussion
Need help referencing duplicated values and matching for 4000+ cells
Please see the attached the mini sample workbook - my apologies for not doing this firsthand!
All the white filled "NO GEO LOC FOUND" cells have an assigned value that is linked to a cell with a matching "ICAO - Filter" value which is highlighted red as it is a duplicated value. I need a formula that assigns the GEOLOC value to that matched value which will get rid of all the white filled "NO GEO LOC FOUND" values.
Thanks!
Marshall
Thanks for your response.
I am still some unclear.
All the white filled "NO GEO LOC FOUND"
Do you want to identify the by the background color even they have same value?
Range("B3") background color is white.
Range("B43") background color is like orange.
both ranges have same value NO GEO LOC FOUND.
Why only need replace Range("B3") rather than both ranges?
an assigned value that is linked to a cell with a matching "ICAO - Filter" value which is highlighted red as it is a duplicated value.
I do not understand above words you mentioned "value which is highlighted red as it is a duplicated value. ".
Do these relative to the question?
I only found only Sheet1 as raw datas.
Can you provide your expected result according to the raw datas?
So that I can understand what you really mean.
Please see the attached updated workbook that shows the expected result of the formula.
Thanks!
Marshall
- Thank you!
Unfortunately, I do not have access to the FILTER and XLOOPUP functions as I am using older version of excel and have restricted access for updating it.
Is there anyway I can accomplish the filter with VLOOKUP?
Marshall