View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
phd4212 phd4212 is offline
external usenet poster
 
Posts: 12
Default Help putting cells in different categories

Hey,
I have a list of 15 different sources and I need to put them into 5
different categories. I know that I could great a gigantic OR array in my
formula, but I was curious if there was an easier way.
So I have category Customer that includes Request, email and inquiry
Category Company that includes News, Internet, Sales, Phone and Magazine
That is an example of 2 of the 5 categories...any help would be appreciated.
Thanks