Is it possible to hide rows in excel 365 based on the content of a specific cell? I attached a test file to explain my question well.
Is it possible to hide rows in excel 365 based on the content of a specific cell? I attached a test file to explain my question well.
Last edited by ahmadjumaa80; 07-11-2022 at 03:29 AM.
Looks like there is more to it than what you are asking.
Perhaps you could explain your end result?
To hide rows, other than manually, you would need VBA.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
You could use FILTER to hide certain rows, but it means duplicating all the others, which might not be what you want.
For example:
=LET(x,FILTER(A2:B11,IF(B8<>"",IF(ROW(B2:B11)=ROW(B6),0,1)*IF(ROW(B2:B11)=ROW(B7),0,1),SEQUENCE(ROWS(B2:B11),1,1,1))),IF(x=0,"",x))
Although as mentioned above it seems like there might be more to it, but the above might point you in the right direction.
That's not really hiding rows, it's selectively copying cells/rows elsewhere.You could use FILTER to hide certain rows, …
Yeah, but in some cases it might be the desired result. I agree that the most likely solution is VBA though.
Agreed, so we wait the OP's verdict.Yeah, but in some cases it might be the desired result.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks