Forum Discussion
How to hide rows if a cell value is above a specified value from a different cell?
Like this, but in formula it shall be relative reference for the row, not absolute. Other words $A14, not $A$14. And it shall be first (most top left) cell of your range
Please see attached, "not visible" region is in grey.
Hi SergeiBaklan. Thanks for replying.
Silly question, but what cell would I put it in? Can it not be done as a formula with an IF, such as:
IF cell value > C4, hide all rows that occur afterwards
I tried this, but nothing changes.
You can see that I have put your formula, with white formatting, to be applied to my entire dataset.
What am I doing wrong? Many thanks.
Like this, but in formula it shall be relative reference for the row, not absolute. Other words $A14, not $A$14. And it shall be first (most top left) cell of your range
Please see attached, "not visible" region is in grey.
Thanks so much SergeiBaklan. I managed to get it working.
Good, you are welcome
Hi again SergeiBaklan.
How can I make it so that the formulas in my sheet only apply to the visible data and ignores what is now hidden?
Is that possible?Also, I want to calculate the total amount payable based on the following:
IF repayment number (between 1 and 84) (cells A14 to A97) is less than number of months (cell C4) THEN sum column E (cells E14 to E97), otherwise blank.
My formula looks like this, but it results in an error (#VALUE!), can you help please?=IF(A14:A97<$C$4,SUM(E14:E97),"")
Thanks!