| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting Member numbers?
Hello,
Need some help. What I'm trying to do is count the members number like below. I have my data set sorted by member number asc and admit date sorted asc. So the 1,2,3,4..etc would be in starting in cell C2...Thank you for your help 123456 1 123456 2 123456 3 123456 4 456789 1 456789 2 567894 1 887459 1 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting Member numbers?
Try this:
=COUNTIF(A$2:A2,A2) Copy down as needed. -- Biff Microsoft Excel MVP "Lime" wrote in message ... Hello, Need some help. What I'm trying to do is count the members number like below. I have my data set sorted by member number asc and admit date sorted asc. So the 1,2,3,4..etc would be in starting in cell C2...Thank you for your help 123456 1 123456 2 123456 3 123456 4 456789 1 456789 2 567894 1 887459 1 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting Member numbers?
Thank you... that worked GREAT!!!
"Lime" wrote: Hello, Need some help. What I'm trying to do is count the members number like below. I have my data set sorted by member number asc and admit date sorted asc. So the 1,2,3,4..etc would be in starting in cell C2...Thank you for your help 123456 1 123456 2 123456 3 123456 4 456789 1 456789 2 567894 1 887459 1 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting Member numbers?
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Lime" wrote in message ... Thank you... that worked GREAT!!! "Lime" wrote: Hello, Need some help. What I'm trying to do is count the members number like below. I have my data set sorted by member number asc and admit date sorted asc. So the 1,2,3,4..etc would be in starting in cell C2...Thank you for your help 123456 1 123456 2 123456 3 123456 4 456789 1 456789 2 567894 1 887459 1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| current time member | Excel Discussion (Misc queries) | |||
| how to I make member list that indicates when subs due | Excel Worksheet Functions | |||
| Member database question! | Excel Worksheet Functions | |||
| condition - member of a group | Excel Discussion (Misc queries) | |||
| How do I put each member of string concatenation in its own line? | Excel Worksheet Functions | |||
Linear Mode
