Hey
How can i with Excel formula do this:
1. First search a column for a specific value and count them. With this forumla
=ANTAL.OM(Blad1!A:A;"*SUSUS*")
(antal om = count if)
2. Now i want to take that search result and look for how many that have another value in another column.
So how many with SUSUS and have in another column "F"
So search in the result of the first formula.....
How can i with Excel formula do this:
1. First search a column for a specific value and count them. With this forumla
=ANTAL.OM(Blad1!A:A;"*SUSUS*")
(antal om = count if)
2. Now i want to take that search result and look for how many that have another value in another column.
So how many with SUSUS and have in another column "F"
So search in the result of the first formula.....