Display data in different column based on number condition

**sarinky** · 11-06-2012, 04:47 AM

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

**:) Sixthsense :)** · 11-06-2012, 05:02 AM

In B20 cell

Formula:

Please Login or Register  to view this content.

Drag it down and right

Hope this helps!

**sarinky** · 11-06-2012, 05:23 AM

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

**:) Sixthsense :)** · 11-06-2012, 05:30 AM

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

**sarinky** · 11-06-2012, 05:39 AM

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