Forum Discussion
Solved
Using wildcards within a IF statement
All, I have the following formula: =IF(J53<>"";(SUM((IF(FREQUENCY(IF(('10 Accounts with tasks'!$M$2:$M$50000=K$51)*('10 Accounts with tasks'!$E$2:$E$50000>=$B$1)*('10 Accounts with tasks'!$E$2:...
If unique Account Name are counting, when apply FILTER to this column and wrap by UNIQUE
=COUNTA(UNIQUE( FILTER(Table3[Account Name], ISNUMBER(SEARCH($I16&"*",Table3[Assigned To: Full Name]))* (Table3[Account Record Type]<>"Dermatologist")* (Table3[Day Visited]>=$B$1)* (Table3[Day Visited]<=$D$1)* ISNUMBER(SEARCH(J$14&"*",Table3[Account Name])) ) ))
If unique Account Name are counting, when apply FILTER to this column and wrap by UNIQUE
=COUNTA(UNIQUE(
FILTER(Table3[Account Name],
ISNUMBER(SEARCH($I16&"*",Table3[Assigned To: Full Name]))*
(Table3[Account Record Type]<>"Dermatologist")*
(Table3[Day Visited]>=$B$1)*
(Table3[Day Visited]<=$D$1)*
ISNUMBER(SEARCH(J$14&"*",Table3[Account Name]))
)
))
SergeiBaklanThanks!!!!
Only one more strange thing is that he also gives a "1" visit for Dennis --> Klein Pharma while there are no visits at Klein Pharma by Dennis.