excel duplicate check/warning

[harryuk]

Hello, thanks for the add.

i am trying to make my sheet give me a warning when a duplicated number is inputted. The problem i have with a data validation check is doesn't see the cell as text. The cell contains (=G3&A3) this gives me the text. Is there anyway to make the data validation see the formula as the text created.

Hope this make sense

Harry

[Pepe Le Mokko]

Administrative note

Welcome to the forum

in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

Please take a moment to read it and attach a sheet accordingly.

Thanks you for helping us help you

[harryuk]

Hi thanks when I click on the attachment button it only comes up with a grey bar, Thanks

[Pepe Le Mokko]

Follow the instructions in the bar. DO NOT use the paper-clip ( it's U/S)