Excel Expert to create macro/vb logic to take data from 1 sheet and create a new sheet of data
Budget: £250 – £750 GBP
A starting excel sheet (sheet 1) that can be updated over time with a replacement data set.
A requirement to apply logic to the data in sheet 1 such that the data must be copied to either sheet 2 or 3 depending on the logic
Sheet 2 all those cars that have a combined set of duplicate values in ALL 5 of the columns specified for the combined duplication criteria
Sheet 3 - all those cars that had unique values in all 5 of the columns specified to check for combined duplicates
A requirement to apply logic to the data in sheet 1 such that the data must be copied to either sheet 2 or 3 depending on the logic
Sheet 2 all those cars that have a combined set of duplicate values in ALL 5 of the columns specified for the combined duplication criteria
Sheet 3 - all those cars that had unique values in all 5 of the columns specified to check for combined duplicates