LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Total instances of the same numbers from one column?

How do I total the number of occurances of one number from a column? I would
like to return the total in a seperate column at the first occurance of each
new number. If the list contains 8 cells with the number 12345, I would like
that total, 8, to be referenced in the next column at the first occurance of
the number and so on.
Suggestions?
--
Aimcorep
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Total all instances of an entry for analysis AndyHanson Excel Worksheet Functions 3 October 11th 06 06:18 PM
Counting single instances in a column wahur Excel Discussion (Misc queries) 5 July 7th 06 03:11 PM
How can I total just the numbers in a column and ignore non-numeric strings? Bud Excel Worksheet Functions 1 June 30th 06 08:02 AM
find text in column h and total the corresponding numbers if colum adelaide Excel Discussion (Misc queries) 2 February 6th 06 04:47 AM
locating all instances of text in a column Rodney New Users to Excel 5 August 25th 05 03:05 AM


All times are GMT +1. The time now is 05:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"