Thread: Counting Data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Byron720 Byron720 is offline
external usenet poster
 
Posts: 61
Default Counting Data

In a column I have hundreds of airway bills. I need to calculate how many
different numbers I have in that report. Not the total (I can go to the last
row for that) and not the frequency. For example:

9140266155
9182187486
9182187556
9182187556
9182187464
9182187464
9140266166
9140266166
9140266170
9140266170
9140266181

Here the formula here should give me 7 which is the number of different
AWB's there are.