Thread: Formula < 4
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
L. Howard Kittle L. Howard Kittle is offline
external usenet poster
 
Posts: 698
Default 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.