Hello, (please see attachment)
When I'm filtering B column, I would like to know if there is a way to move into next unique filtered data using "+" button and into previous unique filtered data using "-" button. Perhaps there is some key shortcut to move between filtered cells? Everytime pressing filter menu, deselecting current data and then selecting next one is taking too long. Thank you for any help!
Last edited by Pojzon; 10-25-2016 at 01:27 PM.
I make use of a pivot table to get the unique list of values. However, the pivot table sorts the names alphabetically. The data must also be alphabetically sorted.
The pivot table is also used to determine if you are already at the top or the bottom of the data.
Otherwise, the code uses the find command to find the first value of the desired range.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
Thank you for answer, but that's not exactly what I need. I made a gif to explain what i mean: https://gfycat.com/DirtyMisguidedArabianhorse. Is something like this possible?
Nice graphic! I understand now.
OK, basically the same logic, but this time applying the filter instead of going to the first instance of the value.
Sweet! That's what I needed, great job, thank you very much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks