beecher wrote:
Hey Ken,

Thanks again for the help. I put the macro into visual basics and was able
to compile a sequential list using the formula
=incrementrow($A$1:$A$100,Row(A1). I, however, ran into some problems when
trying to plug in this formula into each column of data. For instance, I'm
using the following spreadsheet:

Column A Column B
2 $A$1
2 $A$1
2 $A$1
2 $A$1
3 $A$5
3 $A$5
3 $A$5
4 $A$8
4 $A$8
4 $A$8

I'm trying to get an address plugged in to each cell of column B that
corresponds with the address of a cell in column A that represents the last
transition. Let me know if these instructions need clarification, thanks
again, beecher

Hi beecher,

Clarification is needed.

Is the example you gave...

Column A Column B
2 $A$1
2 $A$1
2 $A$1
2 $A$1
3 $A$5
3 $A$5
3 $A$5
4 $A$8
4 $A$8
4 $A$8

an example of what you are trying to achieve?

If so, then except for the $A$1s,
=IF(A2=A1+1,ADDRESS(ROW(),COLUMN(A1),B1) in column B, starting at the
row containing the second column A value (can't be in the first row
because it refers to the row above it, and there isn't a row above row
1) then filled down produces the same result. If you want the $A$1's
then type $A$1 in B1 and the rest will be generated by the formula.

Does your column A data always increment by just one?

Ken