Results 1 to 4 of 4

Categorizing Variable using List

Threaded View

  1. #1
    Registered User
    Join Date
    10-09-2011
    Location
    Kuala Lumpur
    MS-Off Ver
    Excel 2003
    Posts
    19

    Categorizing Variable using List

    Hi, I read one of the thread on how actually do you do this.

    What im trying to do is using a set of list (data dictionary) to group data. Reason using list is so I can expand the list in future.

    I manage to use this but I want to slightly improve it.

    =INDEX($E$2:$E$6,MATCH(TRUE,INDEX(ISNUMBER(SEARCH($E$2:$E$6,A2)),),0))
    If you look at the attached example, instead of the formula giving me the column E result i want it to give the column F result.


    Your feedback is most welcome.
    Attached Files Attached Files
    Last edited by freqzz; 11-20-2013 at 01:51 AM. Reason: Solved

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Categorizing a List of Words by Referencing Another List of Phrases
    By samebito in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-29-2012, 02:26 PM
  2. Categorizing Hours Worked
    By MarcLiq in forum Excel General
    Replies: 3
    Last Post: 10-02-2009, 06:28 AM
  3. Categorizing and sorting data
    By DA CPA in forum Excel General
    Replies: 7
    Last Post: 07-03-2009, 03:59 PM
  4. Categorizing labels??
    By gvb in forum Excel General
    Replies: 4
    Last Post: 11-05-2008, 05:00 PM
  5. Categorizing an excel column
    By Anna in forum Excel General
    Replies: 2
    Last Post: 07-15-2005, 03:05 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1