Conditional fill - IF cell IS NULL and condition is met.

[rholmes]

I Have a spreadsheet as shown in the example below:

In column A I have the Account Names. In column B I should have a complete list of all the Partners linked to the accounts or the fact the Accounts are "Direct".

What I need is a formula or script which will check for each cell in column B if it is blank, if true then check to see if the Account Name in column A already has a Partner assigned then enter the Current Partner else enter the word "Direct"

So for example the first blank cell is B11 and A11 does not equal B11 so it is a different Account to the Partner in B10 therefore display "Direct" in B11. However when you get to Partner E this would need to be filled against all Company H in column A.

I hope this is clear as I have tried nested IFs, ANDs etc but either get a circular reference warning a zero, the word "Direct" or FALSE.

Thanks in anticipation

Robert

[TABLE="width: 476"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Account Name[/TD]
[TD]Current Partner[/TD]
[/TR]
[TR]
[TD]Account A[/TD]
[TD]Partner A[/TD]
[/TR]
[TR]
[TD]Account A[/TD]
[TD]Partner A[/TD]
[/TR]
[TR]
[TD]Account A[/TD]
[TD]Partner A[/TD]
[/TR]
[TR]
[TD]Account B[/TD]
[TD]Partner B[/TD]
[/TR]
[TR]
[TD]Account B[/TD]
[TD]Partner B[/TD]
[/TR]
[TR]
[TD]Account B[/TD]
[TD]Partner B[/TD]
[/TR]
[TR]
[TD]Account B[/TD]
[TD]Partner B[/TD]
[/TR]
[TR]
[TD]Account B[/TD]
[TD]Partner B[/TD]
[/TR]
[TR]
[TD]Account C[/TD]
[TD]Partner C[/TD]
[/TR]
[TR]
[TD]Account D[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Account D[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Account D[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Account D[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Account D[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Account D[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Account D[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Account D[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Account E[/TD]
[TD]Partner D[/TD]
[/TR]
[TR]
[TD]Account F[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Account G[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Account G[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Account G[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Account H[/TD]
[TD]Partner E[/TD]
[/TR]
[TR]
[TD]Account H[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Account H[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Account H[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Account J[/TD]
[TD]Partner F[/TD]
[/TR]
[TR]
[TD]Account J[/TD]
[TD]Partner F[/TD]
[/TR]
</tbody>[/TABLE]

 

[rholmes]

Please note my typo:

So for example the first blank cell is B11 and A11 does not equal B11 so it is a different Account to the Partner in B10 therefore display "Direct" in B11 SHOULD READ

"first blank cell is B11 aa A11 does not equal A10 it is a different Account to the Partner in B10 therefore display "Direct" in B11"