Notifications
Clear all
General Excel Questions & Answers
4
Posts
3
Users
0
Reactions
54
Views
Topic starter
Hi
I want to count a distinct ( duplicate value should be count as one)value from a column based on other criteria.
For example in attached sheet if you filter cable in column B and SCM in column c and if we count the column A with out duplicate then the count is 3.
as like below
| Description | SCM | No Corrections | Reclass | AP | Merger | Remove |
| cables | 3 |
Posted : 09/11/2020 1:11 pm
Nothing attached, you need to click upload
Posted : 10/11/2020 1:29 am
Topic starter
Hi
Sorry i didn't notice the upload option, attached attachment.
Posted : 10/11/2020 4:37 am
Hello,
Almost same question as in this post.
See attached file. I have used same formula as provided by Mynda in linked post, just added a second filter condition. You need of course be able to use dynamic arrays for this to work. Hope this helps.
Br,
Anders
Posted : 10/11/2020 6:26 pm
