View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sean Sean is offline
external usenet poster
 
Posts: 208
Default Help with mailing list!! If 3+ people @ 1 address, send 2, if 5+ s

So, I guess I am in need of help with an "IF THEN" statement here... I have
18k records on a sheet. I am trying to 'auto-evaluate' the database - I
don't want to send 10 catalogs to 1 address if there are 10 customers. I
just want to send 2 for up to 5 customers, 3 for 5+... I don't want to waste
that much paper (both capital, and physically, paper). I was hoping I could
simply filter down the listings, not from 10 to 1, but from 10 to 3, and from
5 to 2... Does this make sense? Any help is greatly appreciated...

Thanks,