**Our Take: Find Hidden Duplicates in Your Filtered Data With Ease**
We think this user has put their finger on a genuinely common pain point, and the solution is simpler than most people assume. When you filter a spreadsheet to focus on three specific rejection codes, you're already doing the right thing: narrowing the noise. But the problem is that filtering hides duplicates just as effectively as it hides irrelevant rows. The job references that appear more than once stay invisible unless you ask the right question. This user wants to know how many times a job was rejected after being reissued, and they want that count broken out by frequency, once, twice, seven times. That's not a niche request. It's a core reporting need that traditional spreadsheets make unnecessarily hard.
Here's what that means in practical terms. You can solve this with a single helper column and a COUNTIFS formula. In a new column, write: `=COUNTIFS(A:A, A2, B:B, B2)`. That will return the number of times each combination of rejection code and job reference appears in the full dataset. Then filter that column for values greater than one. You'll see every duplicate pair. If you want to break it down by frequency, how many jobs were rejected exactly twice, exactly three times, and so on, add a second step: use a pivot table with job reference in rows, count of job reference in values, and filter to show only the three rejection codes you care about. The pivot table will give you a clean frequency distribution in under a minute.
What we find most telling about this request is that the user already knows what they need. They just don't have a tool that lets them express it naturally. That's the gap traditional spreadsheets leave open: they expect you to think in cells and formulas, not in questions about your work. "How many jobs were rejected more than once within these three codes?" is a human question. Translating it into a COUNTIFS formula is a workaround, not a feature. The real opportunity is a tool that listens to the question as you ask it and returns the answer without requiring you to become a formula writer.
The takeaway is straightforward. If you're filtering data to isolate a subset and then hunting for duplicates, you're doing two things right: you're being precise about what matters, and you're hitting the limit of what manual filtering can do. The fix is a COUNTIFS and a pivot table, but that's only the tactical answer. The strategic one is to ask why your spreadsheet can't just say, "Here are the jobs rejected more than once, sorted by frequency." That question is worth holding onto.