Results 1 to 5 of 5

Display data in different column based on number condition

Threaded View

  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.

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