Forum Discussion
Compare 3 sets of data and display percentage of new entries
Hello, we are running 3 surveys and we would like to compare how many new participants we are getting each time. We have 3 sets of email addresses from each survey. We have following sets of ...
Hello Sergei,
For some reason I'm getting "0" as a result of this formula
=SUM(COUNTIF($B$1:$B$2000,$D$1:$D$2000))
In my case data set 1 is in range B:B, and data set 2 is in range D:D
Vadim, it looks like this and attached
Be sure you enter the formula as array one, i.e. by combination of Ctrl+Shift+Enter
Thank you very much, I dot that working!
You are welcome