Closed Thread
Results 1 to 4 of 4

Large Data - Sorting and Categorizes under Specific Requirements by Formula

  1. #1
    Registered User
    Join Date
    07-22-2012
    Location
    Chittagong
    MS-Off Ver
    Excel 2007
    Posts
    36

    Large Data - Sorting and Categorizes under Specific Requirements by Formula

    Hi Experts,
    I stuck with more problem, let me clear you by seeing the new attached file. I am not a native Englishman, so, I tried my best to explain my problem in Excel Sheet in new attached file. Please help me to get it done.

    Requiremtns
    I want the same result in E2 to E**** with upper instruction in Cell F2:G14 by using formula

    Account Type Requirements
    CD Account no. (Cell B2:B***) which start with 111 & 131
    SB Account no. (Cell B2:B***) which start with 12
    MTDR Account no. (Cell B2:B***) which start with 2
    SCHEME Account no. (Cell B2:B***) which start with 3
    LOAN Account no. (Cell B2:B***) which start with 7
    PL Account no. (Cell B2:B***) which start with 903, 904
    PO Account No. 90211010009
    CLG Account No. 90113200068
    IBTA Account No. 90131010010
    OTHERS Account no. (Cell B2:B***) which start with 901, 902; Except Account No. PO, CLG & IBTA Account (90211010009, 90113200068 & 90131010010)



    Again thanks for helping me.

    Regards
    rif
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    01-23-2014
    Location
    Calgary, Alberta
    MS-Off Ver
    Excel Office 365
    Posts
    32

    Re: Large Data - Sorting and Categorizes under Specific Requirements by Formula

    Good morning Rif, you say that you want "the same result in E2:E***" but you don't say the same as what? Do you want it to match Column D?

  3. #3
    Registered User
    Join Date
    07-22-2012
    Location
    Chittagong
    MS-Off Ver
    Excel 2007
    Posts
    36

    Re: Large Data - Sorting and Categorizes under Specific Requirements by Formula

    Thanks for your help.
    Yes, I want those match in "D" Column as per requirements note on "F" & "G" Column.

    Regards

    rif

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Large Data - Sorting and Categorizes under Specific Requirements by Formula

    I asked you NOT to start a duplicate thread.

    Administrative Note:

    Welcome to the forum.

    Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

    Please see Forum Rule #5 about thread duplication.

    I am closing this thread, but you may continue here in the original thread.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula for checking against specific rules/requirements
    By Lauris K in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-19-2019, 09:21 AM
  2. Need a Formula that Categorizes Cell Value Based On Value Range
    By mbibanker1 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-03-2017, 01:40 PM
  3. Stuck exporting data with specific requirements
    By Prestonc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-17-2016, 10:25 AM
  4. Replies: 8
    Last Post: 08-29-2013, 06:40 PM
  5. Sorting/Rearranging Large data set
    By flashyoyo in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-04-2012, 11:00 AM
  6. Sorting large data set
    By David1234 in forum Excel General
    Replies: 0
    Last Post: 09-27-2011, 06:31 PM
  7. Selecting a number of requirements from a large list
    By DentonHTHS in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-20-2008, 09:15 PM

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