Duplicate Info From The Cell Above based on true / false

[ellison]

Hi, we are trying to:
i) duplicate anything that is in Info-V1 into Info-V2 (regardless of what is in the marker column)
ii) if Info-V1 is empty, but the marker is TRUE, enter into Info-V2 the next non-blank cell from above in Info-V1
ii) if Info-V1 is empty, and the the marker for that row is FALSE, leave Info-V2 blank

Hopefully this may help to explain a little.........

super-spreader-fill-down-by-formula-BUT-only-on-rows-which-are-TRUE.xlsx
	A	B	C	D	E
1	Marker	Info-V1	Info-V2		Manual Notes (not needed, just here to try to help explain)
2	TRUE	alpha	alpha		Duplicate the string if it is Info-V1: alpha
3	TRUE		alpha		If there is nothing in Info-V1, check the marker, if it is TRUE, duplicate the next non-blank cell from above in Info-V1: alpha
4	FALSE	beta	beta		Duplicate the string if it is Info-V1 (regardless of if the marker is TRUE or FALSE): beta
5	FALSE				If there is nothing in the Info-V1 AND the marker for the row is FALSE, leave blank
6	FALSE				If there is nothing in the Info-V1 AND the marker for the row is FALSE, leave blank
7	FALSE	charlie	charlie		Duplicate the string if it is Info-V1 (regardless of if the marker is TRUE or FALSE): charlie
8	FALSE				If there is nothing in the Info-V1, check the marker, if it FALSE, leave blank
9	FALSE	delta	delta		Duplicate the string if it is Info-V1 (regardless of if the marker is TRUE or FALSE): delta
10	TRUE		delta		If there is nothing in Info-V1, check the marker, if it is TRUE, duplicate the next non-blank cell from above in Info-V1: delta
11	TRUE		delta		If there is nothing in Info-V1, check the marker, if it is TRUE, duplicate the next non-blank cell from above in Info-V1: delta
12	FALSE				If there is nothing in the Info-V1, check the marker, if it FALSE, leave blank
13	FALSE				If there is nothing in the Info-V1, check the marker, if it FALSE, leave blank
14	TRUE	echo	echo		Duplicate the string if it is Info-V1 (regardless of if the marker is TRUE or FALSE): echo
Sheet1

Thanks for taking a look!

 

[Scott Huish]

Perhaps
=IF(B2<>"",B2,IF(A2,C1,""))

 

[ellison]

Absolutely BRILLIANT!
Huge thanks Scott