View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Wombat Wombat is offline
external usenet poster
 
Posts: 45
Default Counting the number of different entries in a column

Right!

column A contains area codes (two digit numbers, eg. 30), column B customer
numbers (eg 999999)

The lists then go down listing orders. I want to count how many different
customers have placed an order per area (not counting duplicates)

Thanks for any help