With the account numbers in A1 down in B1 use:

=COUNTIF($A$1:A1,A1)

But i fail to see how you can graph it.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"help" wrote in message
...
Need to take a column of account numbers and have it total each number
every
time it comes up. will being graphing it on another worksheet