Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula < 4
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|