May 25 2007, 03:17 PM
I'm trying to find out a formula that counts all the sequence.
It's going to be a long table(w/ info.) so, I was wondering if there would be a formula that will count the sequence of each occurance.
The result would be:
May 25 2007, 03:52 PM
Are they sorted? If so (assuming data starts in A1)...
Enter 1 in cell b1.
Enter this formula in b2:
May 27 2007, 02:09 AM
And for the case they're not sorted:
enter in B1, copy down along the data in A.
May 31 2007, 08:22 AM
THANKS a BUNCH GUYS!!!!!
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here