If column shows yes, show text from cell above

[thedeadzeds]

Hi Guys,

I have 3 columns as per below. If column A (Duplicate) shows yes I need column C (Result) to show the result from cell above in column B (Name). If not just show the text from column B. So the result column should look as per below. Can someone please help? Thanks

Duplicate	Name	Result
	Dave	Dave
	Jim	Jim
Yes	Steve	Steve
Yes	Paul	Steve
	Jim	Jim
	Carol	Carol
	Chris	Chris
	Bob	Bob

 

[Joe4]

Your example does NOT seem to follow this condition:

If column A (Duplicate) shows yes I need column C (Result) to show the result from cell above in column B (Name). If not just show the text from column B

That would suggest that in the first line with the "Yes", it should be pulling "Jim", not "Steve".

Do you perhaps mean that it should only pull from the Name above on the second "Yes" line (and not the first)?
If that is the case, will the "Yes" entries always show up in pairs, or more (at least two in a row)?

If those assumptions are correct, place this formula in C2 and copy down for all rows:

=IF(AND(A1="Yes",A2="Yes"),B1,B2)

 

[thedeadzeds]

Sorry, yes this is =correct:
Do you perhaps mean that it should only pull from the Name above on the second "Yes" line (and not the first)?
If that is the case, will the "Yes" entries always show up in pairs, or more (at least two in a row)?

and the Yes entries will always show up in pairs or more but they will always be listed together. For example:

Duplicate	Name	Result
	Dave	Dave
	Jim	Jim
Yes	Steve	Steve
Yes	Paul	Steve
	Jim	Jim
	Carol	Carol
	Chris	Chris
	Bob	Bob
	Dave	Dave
	Jim	Jim
Yes	Steve	Steve
Yes	Paul	Steve
Yes	Jim	Steve
Yes	Carol	Steve
	Chris	Chris
	Bob	Bob

 

[Joe4]

OK, did you try my solution that I posted in the previous post?
I think that will do what you want.

 

[thedeadzeds]

That does work but only for 2 duplicates. Any more and it doesn't

 

[Joe4]

That does work but only for 2 duplicates. Any more and it doesn't

Kind of a brute force method (I am sure that there are more elegant solutions), but this should work.

In you first cell (C2), just enter:

=B2

Then, in cell C3, enter:

=IF(AND(A1="Yes",A2="Yes",A3="Yes"),C2,IF(AND(A2="Yes",A3="Yes"),B2,B3))

and copy down for all rows.

 

[thedeadzeds]

Perfect thanks so much

 

[Joe4]

You are welcome.