imhereman121
09-24-2015, 11:28 AM
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! :)
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! :)