Hello all,

The group I'm a part of receives a spreadsheet with errors every morning and have to manually go through and remove the duplicates.

I'm seeing if there is a way to do it with a macro and I've posted this on a diff. board and got part of the way there.

Example of data:

x serverA Shadow x x x x x 55
x serverA F:\ x x x x x 55
x serverA C:\ x x x x x 10

This shows that serverA (in Column B) had 3 errors (2 55 codes and 1 10 code). Error codes are in column I. The other columsn (D-H) do have other random data in them but not really necessary (same with column A). What I'd like to see when I run the macro is this finished product:

x serverA Shadow, F:\ x x x x x 55
x serverA C:\ x x x x x 10


Any help would be appreciated!