Search matching values in the same range

[simpauw]

Dear All,

Please see my file attached.
The thing i'm trying to do is to create a lookup field in column X.
This field looks up in column B if a file number appears more than 1 time.
I have a formula for this if the same number appears right above or under the selected line.

=IF(B6=B7;"Gecombineerd";"")&IF(B6=B5;"Gecombineerd";"")

But I actually want to look up in the whole column B, except for the selected cell of course.

Can someone help me?

[Special-K]

You only need one Gecombineerd if there's a duplicate though, not all of them strung together.

Try

in X4
=IF(COUNTIF(B$4:B$1000,B4)>1,"Geocombineerd","")
and copy down the column

[Fluff13]

How about

Please Login or Register  to view this content.

[simpauw]

Thanks both! works perfectly.

[Fluff13]

You're welcome & thanks for the feedback