C
Chiccada
Hello,
Yesterday I created a table and by using the custom format ;;; I managed
to hide all but the first line of each category and still get all lines of
the same instance to show in an auto filter. Today I open the sheet and try
to use the auto filter. All I get now is the visible line only. eg
Yesterday I made:
Bob 1
Bob 2
Bob 3
Look Like
Bob 1
2
3
Today I now only get
Bob 1
No edits have been made whatsoever. How can I get it back? I really need
this back as I want my print format to hide the repetitions but the auto
filter to still be fully functional.
Cheers,
Chiccada
Yesterday I created a table and by using the custom format ;;; I managed
to hide all but the first line of each category and still get all lines of
the same instance to show in an auto filter. Today I open the sheet and try
to use the auto filter. All I get now is the visible line only. eg
Yesterday I made:
Bob 1
Bob 2
Bob 3
Look Like
Bob 1
2
3
Today I now only get
Bob 1
No edits have been made whatsoever. How can I get it back? I really need
this back as I want my print format to hide the repetitions but the auto
filter to still be fully functional.
Cheers,
Chiccada