Hello there.
I have a sheet having dozens of entries (rows) and need to hide some of them (I have a list of these data to be hidden). I know how to apply an advanced filter to show certain data, and I thought, it is possible to use the same technic not for showing, but for hiding also. Unfortunately, I can’t figure out how to do this. Could someone help me? I will very much appreciate that.
Regards
AFAIK you just need to prefix the entry with something like <> in the Filterkriteria-range.
I found the solution thanks to karolus. The prefix <> is needed in front of each record in Filter-criteria table, indeed. The second thing is that rows must be transposed into columns. And the last, each column, created that way, must have the same header (the same as column with data that are going to be filtered out and hidden).