LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Putting consecutive time in cells mrmnz Excel Discussion (Misc queries) 3 October 22nd 08 08:44 PM
Putting Multiple Cells into 1 FormulaQuestioner Excel Discussion (Misc queries) 10 October 1st 08 06:25 AM
Pulling info 2 cells and putting it in one Ian Excel Worksheet Functions 3 September 14th 07 07:24 PM
Putting row numbers in cells [email protected] Excel Discussion (Misc queries) 3 November 5th 06 12:53 AM
counting categories of text cells Brownjc96 Excel Discussion (Misc queries) 3 May 30th 05 01:37 PM


All times are GMT +1. The time now is 04:13 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"