HI all,
thank you for the help you could provide.
I'm currently busy with a code to sort a lot of data and I'm stuck ...
I need to deleted specific rows with same ID but non-matching values (without taking into account blanks)
To help you :
ID Value1 Value2 Value3 Value4 A1 21 22 24 A1 21 23 24 A2 12 12 13 A2 12 13 14 A2 13 13 14
in this table, I would keep both rows for A1 because 1) they match the same ID, 2) All values are similar (I'm not taking into account blanks) but I would delete all A2 rows because Value2 is different.
Any idea how to compare column's value for same ID ?
thank you
franck
Bookmarks