View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sam Sam is offline
external usenet poster
 
Posts: 1
Default Adding Counter to column for number of identical file numbers

Is there a formula or easy way to add a counter to a file? For example
if I have a file number that appears on a file 2 times and another 3
times and another 5 times I get the following results.

Column (A) Column (B)
File Number Results
9565845 1
9565845 2

9552456 1
9552456 2
9552456 3

5695695 1
5695695 2
5695695 3
5695695 4
5695695 5