| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display individual number totals for rows
I had the following question answerd by Stefi earlier. Thanks again.
How do i get only one inidvidual number to be displayed in the first relevant row rather than the same number in every row as below A B 1 2 3 2 2 3 2 4 1 2 5 1 6 4 3 7 4 8 4 In B1: =COUNTIF(A:A,A1) and copy it to B4, B6, etc. Regards, Stefi €˛Mally€¯ ezt Ć*rta: Hi If i have a list of numbers sorted in column A i want to total the numbers which are the same to be displayed in column B. Please see below A B 1 2 3 2 2 3 2 4 1 2 5 1 6 4 3 7 4 8 4 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Column Totals For Individual Pages | Excel Worksheet Functions | |||
| Add totals at end of the report with unknow number of rows with VB | New Users to Excel | |||
| Calculate and display individual error bars for individual points | Charts and Charting in Excel | |||
| Calculate and display individual error bars for individual points | Charts and Charting in Excel | |||
| How do I multiply Column G Totals by a number and display the res. | Excel Discussion (Misc queries) | |||
Threaded Mode
