Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
count names
hi all€¦. Im trying to count the number of times a name is on consecutive
cells. Sounds easy but I can't find a function for this, maybe a little macro that goes cell by cell on each row? I appreciate your help, for example: A1 = AAA A2 = AAA A3 = blank A4 = AAA A5 = AAA A6 = AAA Then my results should be equal to 2 since the name AAA appear in two groups, first group 2 times and second group 3 times. -- Thank you... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Names NOT #N/A | Excel Worksheet Functions | |||
Count Names | Excel Discussion (Misc queries) | |||
Count Names | Excel Worksheet Functions | |||
Count Names | Excel Discussion (Misc queries) | |||
Count names | Excel Worksheet Functions |