View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jake Jake is offline
external usenet poster
 
Posts: 83
Default counting unique values conditionally

hello,
let's say I wanted to count the number of names that appear in column A only
during the month of January in Column B. However I do not want to count each
name more than once. Like below, I would only like to count Jim's name once
so the answer would be 2 (Jim and Steve).

col. A col. B
Jim 1/05/09
Dan 2/11/09
Steve 1/28/09
Jim 1/16/09

Please Help!