Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
counting the number of times shown
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
counting the number of times shown
Hi
With ID in column A, insert this formula in B2 and copy it down as required: =COUNTIF($A$2:A2,A2) Regards, Per "klh84" skrev i meddelelsen ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
counting the number of times shown
Hi,
Assuming your data starts in a2 try this in B2 and drag down =COUNTIF($A$2:A2,A2) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "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 |
#4
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 |