Forum Discussion
Need help referencing duplicated values and matching for 4000+ cells
replace all the "NO GEO LOC FOUND" values that are fill colored white with their assigned "GEOLOC - Filter"
Can you show your expected result according to the raw data?
Additionlly,there are many sheets in the workbook.
Are these worksheets all relative to your question?
I guess more guys may understand what you need to accomplish if you delete some unrelative sheets and upload mini sample workbook.
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