moonlight22
New Member
- Joined
- Aug 15, 2014
- Messages
- 24
Hi,
I am in desperate need.
I have a file which looks similar to the data below:
<tbody>
</tbody>
I have the file sorted by column D and then E, but what I need to identify next is whats difficult. I need to validate if the same code (column E) and same account (column D) appear in both April and September (column A). If so I need that highlighted so i can delete the data.
Basically, I need to keep any rows where column B, C & D are the same but column E are different based on the date in column A.
I know how to use conditional formatting to delete duplicate rows, but that's not what i need to do because of my requirement of column A.
Please let me know if you have any ideas, the file is very large and i need to finish this before tomorrow a.m...eeek!!
cheers!!
I am in desperate need.
I have a file which looks similar to the data below:
A | B | C | D | E |
20140930 | 3344 | XYZ | 141 | AAB7 |
20140430 | 3344 | XYZ | 141 | AAB7 |
20140930 | 3344 | XYZ | 2196 | AAB7 |
20140430 | 3344 | XYZ | 2196 | AAB7 |
20140930 | 3344 | XYZ | 21345 | T2FG |
20140430 | 3344 | XYZ | 21345 | N8J5 |
20140930 | 3344 | FFM | 58461 | B7GT |
20140430 | 3344 | FFM | 58461 | N8J5 |
<tbody>
</tbody>
I have the file sorted by column D and then E, but what I need to identify next is whats difficult. I need to validate if the same code (column E) and same account (column D) appear in both April and September (column A). If so I need that highlighted so i can delete the data.
Basically, I need to keep any rows where column B, C & D are the same but column E are different based on the date in column A.
I know how to use conditional formatting to delete duplicate rows, but that's not what i need to do because of my requirement of column A.
Please let me know if you have any ideas, the file is very large and i need to finish this before tomorrow a.m...eeek!!
cheers!!