Count number of instances of an act. #

Are all duplicate account numbers in groups as per your example? If so then assuming the account numbers are in B2 down use this formula in A2 copied down

=IF(B2<>B1,COUNTIF(B2:B$55000,B2),"")

If account numbers are in any order try

=IF(COUNTIF(B$2:B2,B2)=1,COUNTIF(B2:B$55001,B2),"")

Any ideas on how to auto run the right macro using that number?

Ive got a macro for each number of instances 1 - 12. So if there are 3 instances of account 357, I need it to choose macro "three" and run it.

Any ideas?

Thanx!

Any ideas on how to auto run the right macro using that number?

Ive got a macro for each number of instances 1 - 12. So if there are 3 instances of account 357, I need it to choose macro "three" and run it.

Any ideas?

Thanx!