Closed Thread
Results 1 to 2 of 2

Faster way to categorize data (Faster than nested-if)

  1. #1
    Registered User
    Join Date
    02-07-2014
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    8

    Faster way to categorize data (Faster than nested-if)

    I have to define some 12 categories, satisfying conditions from multiple different columns(some are string, some are no.). How should I go on proceeding with this. If I use nested if, it will take 12 if statements. Is there a faster and nice way to do this.

    E.g. Cat 1 if it satisfies conditions from Col A, B,F,Y (some of these columns are string like Yes/No, names and some are no.)
    Cat 2 if it satisfies conditions from Col B, E,G,I,M,O,U (some of these columns are string like Yes/No, names and some are no.)
    Cat 3 if it satisfies conditions from Col D, H,L,N,Y,Z (some of these columns are string like Yes/No, names and some are no.)

    and so on..

    How to go on about this

  2. #2
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2013
    Posts
    4,337

    Re: Faster way to categorize data (Faster than nested-if)

    Duplicate thread.

    Thread Closed.
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to make data entry faster in excel ?
    By Indra Rai in forum Excel General
    Replies: 2
    Last Post: 10-30-2013, 10:49 AM
  2. data on same worksheet faster?
    By kriminaal in forum Excel General
    Replies: 1
    Last Post: 12-13-2010, 03:50 PM
  3. Which is faster: data manipulation in an array or worksheet?
    By Peaceful4getFul in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-10-2007, 01:23 PM
  4. [SOLVED] faster way of data entry
    By jd in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 08-11-2006, 07:20 PM
  5. Replies: 2
    Last Post: 09-28-2005, 06:05 AM

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