Formula < 4
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
"DBru" wrote in message
...
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.
|