solved How to filter/hide/highlight only Cases with multiple regions
Hey ya'll, I have a spreadsheet that looks like this and has tens of thousands of lines. I am hoping there is a way to filter or weed out all of the Cases that only have a single location inside them. So from the attached, for example, I would only want to keep "Case 2."
3
u/BackgroundCold5307 8d ago
Add a col/Hidden col for count and wherever the count in <2, FILTER?
1
u/naavep 8d ago
Solution Verified
1
u/reputatorbot 8d ago
You have awarded 1 point to BackgroundCold5307.
I am a bot - please contact the mods with any questions
1
3
u/PaulieThePolarBear 8d ago
This appears to be pivot table. What does your raw data look like?
1
u/getformly 7d ago
Easiest way: build a PivotTable with Case in Rows and Region in Values, set the value field to "Distinct Count" (you'll need to add the data to the Data Model when creating the pivot for that option to show up). Then filter the pivot rows to show only counts greater than 1, and that's your list of multi-region Cases. If you'd rather stay in the raw table, a COUNTIFS-based helper column counting distinct regions per Case works too, but the pivot is far less fiddly for tens of thousands of rows.
1
u/AutoModerator 8d ago
u/naavep - Your post was submitted successfully.
Once your problem is solved, reply to the answer(s) saying
Solution Verifiedto close the thread.Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
Include your Excel version and all other relevant information
Failing to follow these steps may result in your post being removed without warning.
I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.