I have one array B3:E6, I want to enter in this array only numeric value. I entered one value in the array (ex 32) again I enter repeated the same value in the array anywhere, then I want to show error massage like “Check again” otherwise ok. How I can solve this problem through data validation or other method?
Thank you for remembering ; however , as I said it earlier , I always think of people like Aladin Akyurek on MrExcel.com , whose number of posts is around 60,000 ! And when I go through that site I see that almost everyone refers to his posts as the ultimate reference. Compared to such people , I feel very much like a novice.