Dec 21 2021 06:38 PM
Row A | Row B | Row C |
Customer ID | Class Name | Data Explanation |
123456 | Class A Saturday 11:00 Junior B1 Term 2-2021 | Student A First term registration |
123456 | Class B Sunday 12:00 Junior B1 Term 2-2021 | Student A Mid term change of class |
654321 | Class C Monday 16:30 Senior B2 Term 2-2021 | Student B First term registration |
654321 | Class C Monday 16:30 Senior B2 Term 2-2021 | Student B who did not make any changes |
125256 | Class A Sunday 13:45 Junior B1 Term 2-2021 | Student C who registered Mid term, new |
Dec 21 2021 11:17 PM
Solution@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.
Dec 22 2021 07:36 PM
@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.
Dec 21 2021 11:17 PM
Solution@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.