Dears,
Good day! I want to have a vba that will summarize my table with duplication.
Attached here is my table.
It should start to check the data in col A , if it has duplicate or not.
If found duplicate it will compare first the value in col I (status) then check if any different values in col C to H.
- If all having the same value in col I then check duplicate in col C to H, if all the same update col J, leave blank the 1st row, then put a remark value on the 2nd row "This is duplicate data"
- Update col K (Merge), concatenate value in col B, C and I, and add rank number. Leave blank if it is totally the same value on each col I, C to H
(Please see example row 2 and 3 from example table)
If no duplicate found, update col I, count the value in col I (Remarks) and update col K (Merge), concatenate value in col B, C and I, and add rank number.
(Please see example row 8 and 14 from example table)
Any value found difference after checking/counting the value in col I (Status),
- If all having the same value in col I then check duplicate in col C to H, Update the col J (Remarks) with only the col that's having different value
- Update the col K (Merge), concatenate value in col B, C and I, and add rank number.
Please check sheet 2 for the output in col J (Remarks) and K (Merge)
br,
Ivan