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