Forum Discussion
count the unique values with 2 condition
Hello, want to ask .. how to count the country who reach the "book/detail" url with the unique IP .. thank you ..
Hi, to both!
Another approach could be (in Matt's File) - [Both Formulas need enter with CSE Ctrl + Shift + Enter]
[H3] : =COUNT(1/FREQUENCY(IF((B2:B8=F4)*(C2:C8=G4),A2:A8),A2:A8))
[G8] : =COUNT(1/FREQUENCY(IF((B2:B8=F8),A2:A8),A2:A8))
Blessings!