formulas

[help]

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

 

[Sandy Mann]

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk