Forum Discussion
Excel data comparison to find duplicates from unique text
DonnaStaMaria Perhaps the attached workbook is something that could work for you. I've used formulae that work in all Excel versions. If you are on the latest, consider exchanging VLOOKUP for XLOOKUP. If you want to make something more dynamic and robust, consider using structured tables, and/or Power Query. The latter would require some learning, if you have never used it before.
Rather than relying on conditional formatting and visual checks, I added some columns to each data set (First and Mid) to do som cross-check between them. If you put a filter on the extra columns you can fairly easily create listings with all changes between terms.
DonnaStaMaria Perhaps the attached workbook is something that could work for you. I've used formulae that work in all Excel versions. If you are on the latest, consider exchanging VLOOKUP for XLOOKUP. If you want to make something more dynamic and robust, consider using structured tables, and/or Power Query. The latter would require some learning, if you have never used it before.
Rather than relying on conditional formatting and visual checks, I added some columns to each data set (First and Mid) to do som cross-check between them. If you put a filter on the extra columns you can fairly easily create listings with all changes between terms.
Riny_van_Eekelen wow, this was perfect for what I needed. Thank you so much! You have saved three of us countless hours, trying to sort through hundreds of records. Thank you, from all of us in my team.
