BillHarris
New Member
- Joined
- Aug 5, 2002
- Messages
- 14
I am trying to use the Data /Validation function to show a warning message when a duplicate number is input into the current cell(i.e F4), which matches a number which could have been input into a cell within the range (F8:F5000).
Please could you advise if such a function is possible in Data validation, and if so the correct syntax to use.
Alternatively is there any other function that could achieve the desired result.
Thanks
Please could you advise if such a function is possible in Data validation, and if so the correct syntax to use.
Alternatively is there any other function that could achieve the desired result.
Thanks