| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
counting the number of times shown
In B1 enter: 1
in B2 enter: =COUNTIF($A$1:$A2,A2) and copy down -- Gary''s Student - gsnu201001 "klh84" wrote: I am trying to figure out a way to put a numerical value next to the id that is shown, suggestions? ex: ID This is what I am hoping to get to show up in the next column 55 1 55 2 37 1 46 1 62 1 55 3 89 1 82 1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting number of times a value occurs | Excel Discussion (Misc queries) | |||
| Counting the times a number appears | Excel Discussion (Misc queries) | |||
| Column of Text Shown = Total Times Shown? | Excel Worksheet Functions | |||
| count the number of times the same number shown | Excel Discussion (Misc queries) | |||
| Number of times a number is shown | Excel Worksheet Functions | |||
Hybrid Mode
