how to only see a certain amount of cells based on a particular value

0

Hi,

I want to find out if there is a conditional formating or if there is a formula that will only show particular amount of cells based on a particular value given.

So For example

In my A Column i have a certain number lets say 3

Between B & Q which is 16 Columns i have 1 to 16 listed Respetively per Column.

Between 1 to 16 different there are formulas inside there that bring up unique results and can vary based on the information to either be completely full to column Q or have a few results...

Based on that number 3 how do i only show up 3 results of those repective columns so therefore Column B C D should only show up with its results?

I have highlighted in red specifically what i want to see... i dont need any other results other than the specfic value in A column

Answer
Discuss

Answers

0
Selected Answer

Use the attached one, Thanks

Nilesh

Discuss

Discussion

Nileshraje, please include a summary of the contents of the included file so that user's can better follow what you are posting without having to open the file.

Thanks,
Don
don (rep: 1442) Jun 27, '17 at 5:28 pm
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login