View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Greg Greg is offline
external usenet poster
 
Posts: 331
Default VLOOKUPS to Count Unique numbers

Can I use a VLOOKUP to return a count of unique values associated with
certain people? Ie. can I use a vlook up to lookup and then count of a number
of unique reference numbers associated with a person called 'John Smith' and
then put it in a particular cell?