Forum Discussion
Need help referencing duplicated values and matching for 4000+ cells
Good Afternoon All, I am trying to reference a column and match data that is found within that same column to a different column. Please see the attached workbook and I am working in sheet "SMS ...
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?
MarshallSorry I am not familiar with Excel formula.
if with sql,may like below:
//select * from Sheet1 limit 20; cli_no_header; select iif(f02 like 'NO GEO LOC FOUND',(select group_concat(distinct(f02)) from Sheet1 b where b.f02 not like 'NO GEO LOC FOUND' and b.f01 like a.f01 ),f02) f02 from Sheet1 a;