# Display data in different column based on number condition

1. ## 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.

thank you for help,

Sarin

2. ## Re: Display data in different column based on number condition

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

Drag it down and right

Hope this helps!

3. ## 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. ## Re: Display data in different column based on number condition

Originally Posted by sarinky
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:
`Please Login or Register  to view this content.`

Drag it down and right

5. ## 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

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

#### 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