K
Ken
Excel2003 ...
Col E ... Contains: Empty Cells, "A" & "I"
Col W ... Contains: Empty Cells & "Qty's"
I wish to return the "Qty" from Col "W" from the 1st record that contains an
Empty Cell above the "I" in Col E.
Issue is: I can have several records in a row with the "I" indicator & I
still wish to return the "Qty" from Col "W" from the 1st record above the
"I's" that contain an Empth Cell.
ie:
Col E Col W
Ind Qty
-- 10
-- 3
A --
-- 10
-- 7
-- 10*
I 3 ... Return 10*
-- 20
-- 20
-- 20*
I 10 ... Return 20*
I 10 ... Return 20*
I 5 ... Return 20*
I 5 ... Return 20*
-- 10
-- 10
Thanks ... Kha
Col E ... Contains: Empty Cells, "A" & "I"
Col W ... Contains: Empty Cells & "Qty's"
I wish to return the "Qty" from Col "W" from the 1st record that contains an
Empty Cell above the "I" in Col E.
Issue is: I can have several records in a row with the "I" indicator & I
still wish to return the "Qty" from Col "W" from the 1st record above the
"I's" that contain an Empth Cell.
ie:
Col E Col W
Ind Qty
-- 10
-- 3
A --
-- 10
-- 7
-- 10*
I 3 ... Return 10*
-- 20
-- 20
-- 20*
I 10 ... Return 20*
I 10 ... Return 20*
I 5 ... Return 20*
I 5 ... Return 20*
-- 10
-- 10
Thanks ... Kha