conditional formatting_copying lines

Hello,
could you please help me to solve the following problem:
I have used the conditional formatting to find duplicates in one column (A); in another one (f. eg.B) I would like to have only these values which are not duplicated (not coloured).

I attach an Excel sheet with sample data.

Thank you for any advice.

Malgosia

hi,

if you want to get not duplicated data first you must select range B1:B6 and then write array formula in selected range:

{=INDEX($A$1:$A$6;SMALL(IF(COUNTIF(A1:A6;A1:A6)=1;ROW(INDIRECT("1:"&ROWS(A1:A6)));"");ROW(INDIRECT("1:"&ROWS(A1:A6)))))}

Notice, You should aproove the formula with CTRL+SHIFT+ENTER (signs "{" and "}" appear after aprooving).

regards

Hi,
Thank you ver much for your help. It works

Regards,
Malgosia