Match items in 2 lists??? eh help

  • Thread starter Thread starter DanP
  • Start date Start date
D

DanP

Hiya

I have 2 worksheets. One with a long list of names the other with not
so long list of names - Sheet 1 (all clicks), sheet 2 (users at client
x).

I would like to be able to find out how many users at client x clicked
on the site... any ideas how I can run a match on the lists?

Any help/tips much appreciated

thanks

D
 
You can use the tools/filter/advanced filter on both lists
to get unique names (if they are not already unique).
then you can do a vlookup from one to another to see which
match.
 
Thanks - trying both will get there... Im sure this is great help bu
not quite working will see if I can fix.

DP

PS have great weekend
 
Back
Top