Validating same entered data in one cell

[ricrodrig]

I am trying to validate the value of an entered number in one cell. Just the same way you do when trying to register here in BigResource. They asked you to enter your email address 2 times to make sure you entered correctly.
Is there some kind of formula that allows you to do that in Excel, providing some kind of Alarms or display error messages indicating that the second value you entered does not match with the first entered one?

Your prompt response will be higly appreciate it.

Best Regards,

Ricardo Rodriguez from Chicago area

 

[PaddyD]

hi - welcome to the board.

a data validation formula is what you need

=a1=b1

..or something.

 

[ricrodrig]

Thank you Paddy;however, what you are suggesting me is not exacly what I am trying to do. I am actually trying to validate same entry data in the same cell. I do not need to enter same data in another cell to validate it to validate it -- that's something simple to do.

 

[PaddyD]

step us through the details of an example of what you're trying to achieve.

 

[ricrodrig]

OK Paddy,
Let's assume that I am entering 16 digit number in one cell en everything is fine. What I need is to write a code or a formula that once I entered my 16 digits number, the same cells clear-up and it shows up a message requesting me to re-enter the same value to validate that it is exactly the number that I am trying to enter. If I enter by mistake another number, it will display an error message saying that the second 16 digits number I entered does not match the first one.

Thanks,

Ricardo

 

[PaddyD]

how do we know that the 'right' number is getting entered?

again, rather than the form of the problem, give us a concrete example of what you want to happen from start to finish.

 

[ricrodrig]

Hi Paddy,
Just think that this is to verify that the second entered number you typed in the cell is exactly the same as firt one you entered. That's why I mentioned the example when you are signing-in at any website services, they ask you to enter you contact email address and ask you again to re-entered to make sure that in fact it is the same one you pretending to provide.

 

[PaddyD]

Ok. Now I get you. To do that you're going to need some vba (to give you a form to enter the data, store it, enter again and validate before putting into a cell).

vba's not really my thing, but you'll still need to provide more info to get this done - where in the worksheet does this need to be done? just one cell or lots?

 

[ricrodrig]

Hi Paddy,
The cells that need this formula to be implemented are C25, E25 and F25.

Thanks,

Ricardo