formula for copying a value in a cell until that value changes
 

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

formula for copying a value in a cell until that value changes
 

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

formula for copying a value in a cell until that value changes
 

this is not working for me. the identifiers i need switch back and forth, so
how do you get it to change back and forth?
--
Eric


"Thomas [PBD]" wrote:

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

formula for copying a value in a cell until that value changes
 

Eric D,

You mean to say that your data comes in as:
a in

out

b in

out

and you would like it to become:
a in
a in
a out
a out
b in
b in
b out

if not, I might need some clarification, an exact example could help.
--
--Thomas [PBD]
Working hard to make working easy.


"Eric D" wrote:

this is not working for me. the identifiers i need switch back and forth, so
how do you get it to change back and forth?
--
Eric


"Thomas [PBD]" wrote:

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

formula for copying a value in a cell until that value changes
 

Nevermind I think i can work with this ... i had the formula wrong ... thanks
a bunch!
--
Eric


"Thomas [PBD]" wrote:

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