J
JMay
At work someone supplies with with a near-table of info like:
A B C D E
1 asdfsdf sadfsadf sfasdf sfasdf 89.00
2 wertewrt ewrtet ertwert ertwrt 50.00
3 cvbxcvb cxvb xcvbcvb cvbv 45.00
4 0 0 ABCD 124.00 0
Then another block (like above) starting at row 5 except maybe
it has 6 line items, then a 3rd block with 12 line items...inconsistent
to the end
I'd like to In Column F enter a function that will
replicate the "ABCD" value on each row (example in F1:F3)
and all other Blocks.. down thru the end of the worksheet.
Is there a function that will do that?
TIA,
JMay
A B C D E
1 asdfsdf sadfsadf sfasdf sfasdf 89.00
2 wertewrt ewrtet ertwert ertwrt 50.00
3 cvbxcvb cxvb xcvbcvb cvbv 45.00
4 0 0 ABCD 124.00 0
Then another block (like above) starting at row 5 except maybe
it has 6 line items, then a 3rd block with 12 line items...inconsistent
to the end
I'd like to In Column F enter a function that will
replicate the "ABCD" value on each row (example in F1:F3)
and all other Blocks.. down thru the end of the worksheet.
Is there a function that will do that?
TIA,
JMay