number sequence

I am in need of assigning a re-occurring number sequence to a large data set, based on cell value. A small sample of the data set shows below, in column A: I need to generate a re-occurring number sequence in column B, like showing below: So in column A, for every entry of AX1002, the...

How do I write a formula that achieves Column B? When a blank cell appears in Column A, Column B must also leave the cell blank. But on the next cell if there is a filled cell in Column A, it must continue the number sequence from where it was last left in Column B.

Can anyone let me know what formula i can use to create an order based on a column? The example below uses the Family column to order the sets in number sequence (order column) and increment by 1 each time the number changes. Than you in advance, much appreciated...

If I have a long list of numbers, how do I find where that list of numbers is not consecutive. How do I show when the sequence changes from 5 to 8 and from 9 to12? 1 2 3 4 5 8 9 12

Hello, I'm trying to find out how to list which rows a number sequence occurs, in Column A, in a simple way, that doesn't make me search through a massive column in a workbook. I just want to see the rows it occurs in, without having to go down to those rows. The number sequence to find is...

Hi, I'm currently using =COUNTIFS(A1:A1000000,11,A2:A1000001,21,A3:A1000002,31) but I want to modify it to not only count the number of occurrences of 11,21,31 in column A, but to also list them by row. For example,,, .........A 25.....11 26.....21 27.....31 . . . 15000 11 15001 21...