-
Removing duplicates if certain conditions match
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!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules