I'm trying to write a formula so that excel will go through a list of names and count unique names (not duplicates). So I have three columns of data. For Excel to count the first column, I have: =DCOUNTA($B$5:$B$30,1,$J$5:$J$6)
The B's refer to my data (including the header cell), and the J's refer to my criteria, which is: =COUNTIF(B6:B30,B6)=1
This seems to work (not that I am exactly sure how).
But my problem is now I want to do the same thing for three columns that aren't next to each other.
Any ideas? Let me know if what I'm trying to do doesn't make sense...
Thanks for reading,