Thanks, but if a forum dedicated to Excel doesn't make it easy to add excel tables (apparently it is required to get an answer) without installing addons or programs to convert it to HTML OR allow you to upload a file like other excel forums do then this may not be the right place for such questions.
And if the detailed information I provided including actual formulas doing 90% of the work already and an image of the actual fields isn't enough for someone to help then it is clear that no one here has the answer or knows how to first dedupe then filter results in excel. (the formulas I've provided already do each of these separately)
I apologize. I was under the impression that the "Excel Questions" forum was the correct place to submit these kinds of questions.
Thanks anyway...
I saw this remark and I want to make some comment on it.
The OP sure has a point that the explanation how to create a decent excel table with "Copy-Borders-Paste" could be more precise. The first time I tried it that way it was a big failure. Luckily my excel and html/BBcode knowledge is enough to handle it and look for a solution myself. But for an Excel novice it could be explained a little bit better.
As far as posting compleet workbooks as an attachment. That's a "No-no" for me. I see that option in some excel forums and the problem is that you don't see a lot of "Live" solutions. For example, the OP posts a question and the answer most of the time is: "Look at the attached workbook".
For me it's very satisfying to see people post their knowledge, formulas or code snippets within the reply. It makes the overall discussion better to follow.
Last, the OP is a little bit annoyed because of the questions he gets thrown at him. Well, I see those questions only as an effort to get the problem clear on the table so that the respondent can give a better and suitable answer to the Op's question. Nothing wrong with that. Now, the OP doubts if this is the correct forum to answer his question. In my view this is one of the top forums concerning Excel so I advice him te re-evaluate his question and poste a decent screenshot because the link didn't work either.