Hello, I am creating a spreadsheet to be used by people who are unlikely to use anything but auto-filter.
In this spreadsheet, I have several rows that I want to remain on the view, regardless of the auto-filter selection. Please see my example below.
If column A is filtered for Europe, I still want Global to appear, or if B is filtered for Japan, I still want Global to appear. However, if C is filtered for February, the January Global can disappear.
Is anyone aware of a way to do that that is very user friendly (i.e. it does not require a custom filter)?
Thanks!
A B C D
Europe Sweden January 123
Europe Norway January 234
Europe Spain January 345
Asia Japan January 456
South Am. Argentina January 678
GLOBAL - January 789
Europe Sweden February 987
Europe Norway February 876
Europe Spain February 765
Asia Japan February 654
South Am. Argentina February 543
GLOBAL - February 432
In this spreadsheet, I have several rows that I want to remain on the view, regardless of the auto-filter selection. Please see my example below.
If column A is filtered for Europe, I still want Global to appear, or if B is filtered for Japan, I still want Global to appear. However, if C is filtered for February, the January Global can disappear.
Is anyone aware of a way to do that that is very user friendly (i.e. it does not require a custom filter)?
Thanks!
A B C D
Europe Sweden January 123
Europe Norway January 234
Europe Spain January 345
Asia Japan January 456
South Am. Argentina January 678
GLOBAL - January 789
Europe Sweden February 987
Europe Norway February 876
Europe Spain February 765
Asia Japan February 654
South Am. Argentina February 543
GLOBAL - February 432
Last edited: