Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

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: 1989) 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