Index Match IF Duplicate

Please Login or Register  to view this content.

I need this code to first of all check

IF A7 is not duplicated in the index b2 : b14. If it is duplicated then say duplicate!

IF A7 is not duplicated then run the code above.
(ps the code above if there is an error displays "False" how do i get it to display "Error Check"

Any help is appreciated I am a beginer.

You're tackling some advanced stuff for a beginner.

Okay, first your question....

Please Login or Register  to view this content.

Where I wrote "Something Else" is where your second equation would go.

The equation you wrote however

Please Login or Register  to view this content.

will only return a True or a False depending on whether

Please Login or Register  to view this content.

returns an error or not. What exactly are you trying to do with your original formula?

Assuming you are attempting to retrieve from column B, whatever row you find in column A matching A7, then the formula should be written

Please Login or Register  to view this content.

So the whole thing would be;

Please Login or Register  to view this content.

ChemistB

Please Login or Register  to view this content.

I have edited the code so it matches what i require but I have one problem. the duplicate issue. if c1 appears more than once between a1 and a7 then there is duplicate so it needs attention. (in an ideal world c1 should only appear once between a1 and a7 but sometimes it appears more than once so i need it to tell me that so I can investigate further.) if it only appears once then indexmatch as above otherwise Error Check.

Ahhh, okay you need to use COUNTIF

Please Login or Register  to view this content.

ChemistB

will give it a whirl