Eric D,

Here is an option that I have used mutliple times in importing data.
Especially from PivotTables.

=IF(A2="",B1,A2)

Basically, place this formula in a new column, and change the cell
references as needed. My example is as such:

SEL <New Column
a a
a
a
a
a
a
b b
b
b
b

Hope this helps.

--
--Thomas [PBD]
Working hard to make working easy.


"Eric D" wrote:

I don't know if this is possible but here goes.

I have exported data into excel and in column D there are identifiers i.e.
"IN" & "OUT". In column A there are items that fit into these categories,
but the items switch back and forth between the two. There will be 20 items
that are "IN" with the "IN" appearing in just the first items row and doesn't
change until there are "OUT" items. This switches back and forth. Is there a
formula that can copy the identifier on every row until it changes, so that
every row has a label of IN or OUT?

Am i making sense? Please help!
--
Eric