| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Total instances of the same numbers from one column?
If your data is in column A (starting A1) then in B1 (and copy down)
=IF(COUNTIF($A$1:A1,A1)=1,COUNTIF(A:A,A1),"") HTH "Aimcorep" wrote: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Total instances of the same numbers from one column?
One way,
=IF(MATCH(A1,A:A,0)=ROW(),COUNTIF(A:A,A1),"") HTH, Paul "Aimcorep" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Total all instances of an entry for analysis | Excel Worksheet Functions | |||
| Counting single instances in a column | Excel Discussion (Misc queries) | |||
| How can I total just the numbers in a column and ignore non-numeric strings? | Excel Worksheet Functions | |||
| find text in column h and total the corresponding numbers if colum | Excel Discussion (Misc queries) | |||
| locating all instances of text in a column | New Users to Excel | |||
Hybrid Mode
