ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   formulas (https://www.excelbanter.com/new-users-excel/191278-formulas.html)

help

formulas
 
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

formulas
 
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





All times are GMT +1. The time now is 10:14 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com