Logic for duplicates with condition

[Rediska]

Hello dear Excellians,
Please help with yet another question...
Given (columns):

.....A......B......C.....D
1 boo....wo.....do
2 boo....wo.....do...BA

Question:
How to copy cell D2 ("BA") into D1 if values in cells A1:C1=A2:C2 (Duplicates)?


Thanks,
Yours truly

 

[Luke M]

Can you elaborate on your example what the rest of the layout might look like?
Otherwise, could just do:
=IF(AND(A1=A2,B1=B2,C1=C2),D2,"")

 

[Rediska]

Sorry, wasn't clear.
(And formula didn't work...)

I have a list of about 5000 records (Columns A,B,C,D).

Column D contains metadata, but not always provided.

What I need is:

• If D populated for any two same records in the list, the record without metadata (D) should be deleted;
• IF D is not populated, only one record should stay (I apply simple "Remove Duplicate" function to clean it up, this one is easy).

I couldn't apply Remove Duplicates function with conditions, so I am trying to solve backwards -copy data and then remove duplicates.

I played with formulas but to no success.
Hope this helps.

 

[Nebu]

Hi:
May be something like this (after removing the duplicate record without metadata, your bullet point 2.)

=IF(AND(COUNTIFS($A$2:$A$3,A2,$B$2:$B$3,B2,$C$2:$C$3,C2)>1,D2=""),"Delete","Do Not Delete")

and filter for "Delete" Flag to remove the record without metadata.

Thanks