+ Reply to Thread
Results 1 to 5 of 5

Display data in different column based on number condition

  1. #1
    Forum Contributor
    Join Date
    01-25-2012
    Location
    Cambodia
    MS-Off Ver
    Excel 2010
    Posts
    135

    Display data in different column based on number condition

    Dear All,

    I have stuck with finding formula to display certain data based on the number condition.

    I have several columns with thousands of row. There is a column called "Quantity". The current spreadsheet attached display all, but I want it to display only when it meet condition in Quantity column.

    For example. If in col "Quantity" is 3, I want the data to display only in col "H", if in col "Quantity" is 4, I want the data to display only in col "D" and col "H", and so on.

    Please see the sample attched,

    thank you for help,

    Sarin
    Attached Files Attached Files
    Last edited by sarinky; 11-06-2012 at 05:40 AM.

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,701

    Re: Display data in different column based on number condition

    In B20 cell
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Drag it down and right

    Hope this helps!


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Forum Contributor
    Join Date
    01-25-2012
    Location
    Cambodia
    MS-Off Ver
    Excel 2010
    Posts
    135

    Re: Display data in different column based on number condition

    Hi Thank you for you reply; however, there are some missing conditions:

    - If Col "Quantity" = blank, I want to show "--" from "A" to "H"
    - If Col "Quantity" = 2, I want to show "--" from "A" to "H"
    - If Col "Quantity" = 3, I want to show data in Col "H" only and the rest show "--"
    - If Col "Quantity" = 4, I want to show data in Col "D" and Col "H", and the rest show "--"
    - If Col "Quantity" > 4, I want to show data from Col "A" to Col "H"

    Hope my explanation is clear,

    Regards,
    Sarin

  4. #4
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,701

    Re: Display data in different column based on number condition

    Quote Originally Posted by sarinky View Post
    Hi Thank you for you reply; however, there are some missing conditions:
    Regret for the inconvenience, since I read upto the word show but

    In B20 cell
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Drag it down and right

  5. #5
    Forum Contributor
    Join Date
    01-25-2012
    Location
    Cambodia
    MS-Off Ver
    Excel 2010
    Posts
    135

    Re: Display data in different column based on number condition

    Dear Sixthsense,

    Done! thank you very much. Sorry that my explanation is not very clear. I just edit in your formula COLUMN()=7

    Again, I am appreciated your help,

    Sarin

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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