View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tinkerbell1178 Tinkerbell1178 is offline
external usenet poster
 
Posts: 3
Default Count duplicates once

I need to count how many different codes/numbers are in a list, and some of
them are duplicated. eg:

300001600
300001600
300002465
300001435
300005642

I need the result to show that there are 4 different numbers, rather than 5
in total.