Formula < 4

D

DBru

I want excel to create a list that will tell me which items repeat more than
4 times.

My company is trying to cut down on return mail and we are going to suppress
mailings for people that we receive more than 4 items back without a
forwarding address. We could possibly just log the information in Excel if
we can have it notify us of contracts that fall under the greater than 4
category. It will be a really large file so we need it to automate.
 
L

L. Howard Kittle

This may work for you.

=COUNTIF(A1:A20,A1)>4

I used single digit numbers in A1 thru A20 to represent the mailings that
came back w/o forwarding address for my test. ( I'm not sure how your
entries look.)

I put this in column A.

5 2 2 3 5 3 4 4 4 4 5 5 5 6 5 6 6 6 5 6

Now select the 20 cells and under Format > Conditional Format > Formula is >
=COUNTIF(A1:A20,A1)>4 > Format > Patterns > choose a color > OK >OK.

In my example the highlighted cells are A1 A5 A11 A14, which tells you the
"5 mailings" exceed 4 back and the "6 mailing" exceed 4 back.

HTH
Regards,
Howard
 
Top