Dublicate

[Ekstamm]

I have a formula that checks my sheet if the number is typed or not in a specifik coulmn and makes me a "status" if it is Patched nor not. (the number is the name of a fixture)

=IF(ISNUMBER(MATCH(A:A;'ART48-1'!D2:D56;0));"PATCHED";"")

Kan I extend this formula to also find Duplicates and then type DUBBLE instead of Patched but still leave the cell empty when nothing is found.
I was then planning on using validation to make a popup with an error that says you can not write the same number twice.

Does that make any cense?

 

[Matty]

If I follow correctly, is this what you wanted?

=IF(COUNTIF('ART48-1'!D2:D56,A2)=1;"PATCHED";IF(COUNTIF('ART48-1'!D2:D56,A2)>1"DUBBLE";""))

Where A2 is a Cell containing the value of interest.

Matty

 

[Ekstamm]

This workes perfect. Just don't understand where the A2 comes from. Thats the part I cant get my head round.

 

[Matty]

I missed off a semi-colon in my previous post. It should be like this:

=IF(COUNTIF('ART48-1'!D2:D56,A2)=1;"PATCHED";IF(COUNTIF('ART48-1'!D2:D56,A2)>1;"DUBBLE";""))

Where A2 contains the name of a "fixture".

Matty

 

[Ekstamm]

I noticed the Semi-colon. I got it to work just fine!

Thx!