I have a formatted table example below, and I would like the filter function to be duplicated in another sheet:
I would only like the filter function for "User" to be duplicated on another sheet. So the user of the file could filter only by "User", and the rest of the main table would be filtered accordingly. Is this even possible?
P.S. I understand that you can create a slicer to filter, but I have many unique values in the "User" column, and would like for it to be searchable.