Forum Discussion
count repeated values under different filter
I'm trying to count "D5" in column Notifications where 1) column item is not blank 2) column status=Done 3) Equipment# has a repeated value When Notification =D1 the count in my example table is1...
I think the simplest solution is to split the tables i.e. D1 in rows in 1 table, other D's in the other table. You can then join the tables using equipment number and your other conditions. This will only work if there is 1-Many relationship. You can use Power Query to do this.
- unluckily its a many to many
anyway thanks for your help.