Mar 02 2018
12:04 AM
- last edited on
Jul 25 2018
11:14 AM
by
TechCommunityAP
Mar 02 2018
12:04 AM
- last edited on
Jul 25 2018
11:14 AM
by
TechCommunityAP
Hello,
please help me find a solution:
I need to count the number of distinct text and number values in column $M:$M , when in column $E:$E is written "*italija*", and when in column $F:$F is written "saus", also - it should not count blank cells.
Now I am doing this in pivot: filtering column F with "saus", than filtering column E with "italija", than copying column M in another sheet, removing dublicates and counting the cells.
Aug 12 2019 01:00 AM