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