I don't understand this question. Would column B just have the numbers in it? The text to columns function would do that with the example you've given. But I think I'm missing something.
Post by spankswife on Nov 12, 2012 16:45:50 GMT -5
I have like 1500 lines of data in col A, and in col B, I want a formula to number them the was I have shown (like if col A repeats 5 times, in B I want it to number them 1-5)
Post by ellipses84 on Nov 12, 2012 16:58:47 GMT -5
This is only good if you have a lot of consecutive numbers. Type 1, 2, then click on the bottom right corner of the cell with a 2 and drag it down to the cells below until the cell where your numbering ends.