Replies

Great. Worked like a champ!!!

Thanks!!!

Great. Worked like a champ!!!

Thanks!!!

Always 4 hyphens and always in the same position.

Thanks.

Always 4 hyphens and always in the same position.

Thanks.

Auto Filter did the trick.

Thanks!

Auto Filter did the trick.

Thanks!

How do I stop processing other rules? Also, you state apply another rule(s). What other would I apply?

All I want to do is to take all messages from xyz@yahoo.com and put in an inbox folder.

Thanks.

How do I stop processing other rules? Also, you state apply another rule(s). What other would I apply?

All I want to do is to take all messages from xyz@yahoo.com and put in an inbox folder.

Thanks.

So far, no. I have an exact match on senders address and am using this in the rule – to no avail.

So far, no. I have an exact match on senders address and am using this in the rule – to no avail.

Steve, man this is slick. Thanks a bunch! Hey, mind helping me to understand the formula?

=OR(AND(E2=E1,D2=D1),AND(E2=E3,D2=D3))

I think I may know but please tell me if correct. This is saying – the 1st AND part – if e2=e1 and d2=d1 then assign true; 2nd AND is if e2=e3 and d2=d3 then assign true. The OR then says for the overall expression – if either AND statement is true then assign a TRUE to overall expression – else false.

Is this remotely correct? Also, what is the benefit of cutting and pasting – as value the true/false evaluation?

Thanks again!!!!!

Steve, man this is slick. Thanks a bunch! Hey, mind helping me to understand the formula?

=OR(AND(E2=E1,D2=D1),AND(E2=E3,D2=D3))

I think I may know but please tell me if correct. This is saying – the 1st AND part – if e2=e1 and d2=d1 then assign true; 2nd AND is if e2=e3 and d2=d3 then assign true. The OR then says for the overall expression – if either AND statement is true then assign a TRUE to overall expression – else false.

Is this remotely correct? Also, what is the benefit of cutting and pasting – as value the true/false evaluation?

Thanks again!!!!!

Ok. Here is the attached file. Assume this has 5k rows of data vs. 5… If you will note, rows 2 and 3 Amount and Line Descr are identical. What I’d like to do is:
1. Identify all duplicates whereby these 2 fields are the same.
2. Isolate all duplicates such as rows 1 and 2 on this worksheet where all duplicates are together as opposed to being mixed w/the non-dup rows or move the dups to a separate workseet.

Thanks again.

Ok. Here is the attached file. Assume this has 5k rows of data vs. 5… If you will note, rows 2 and 3 Amount and Line Descr are identical. What I’d like to do is:
1. Identify all duplicates whereby these 2 fields are the same.
2. Isolate all duplicates such as rows 1 and 2 on this worksheet where all duplicates are together as opposed to being mixed w/the non-dup rows or move the dups to a separate workseet.

Thanks again.

Steve, thanks. What type of incremental details do you need?

Once I decipher the unique entries, I’d like to be able to group them (both duplicate records) together (and then again all duplicates in one part of the spreadsheet) vs. them being mixed in the other 5000 rows of data.