Hi I am new beginner. And I wish to learn here. Appreciate the help.


I am doing excel database for a company, and I need to ensure the correctness of the input data.
is there any functionality in excel that can check the input data, like it will pop out window for you to enter your data twice and check its consistence?

I know this issue will be partially solved by data validation. But this's very limited as for it will only check the data type. so wont detect any human input error.


Plz help me, thank you sooooo muchhhhhhhh!!

Sky