Counting strings of consecutive numbers in a column
in [General]
|
From: SamG on 27 Jan 2010 01:21 Hi I want to be able to count strings of consecutive numbers in the one column. eg: Seagrass Seagrass Seagrass Seagrass NA NA NA Seagrass Seagrass Seagrass NA ... So i want to count the number of times Seagrass occurs in the one string, then count how many times it occurs int he next string. eg in the example above: 4 & 3. I am at a total loss thanks
From: Jacob Skaria on 27 Jan 2010 02:25 Check out your previous post.. -- Jacob "SamG" wrote: > Hi I want to be able to count strings of consecutive numbers in the one column. > > eg: > > Seagrass > Seagrass > Seagrass > Seagrass > NA > NA > NA > Seagrass > Seagrass > Seagrass > NA > .. > > So i want to count the number of times Seagrass occurs in the one string, > then count how many times it occurs int he next string. eg in the example > above: 4 & 3. > > I am at a total loss > > thanks >
|
Pages: 1 Prev: Data to Date conversion with multiple formats Next: Hiding Formulas when the value is "0"? |