Hi there
I am trying to setup a sheet where you are only allowed to have a certain entry once a day. I want the data valadation to stop the user if they try to enter the value again for the day
What i have done so far is that i have highlighted column B where you enter the values. In column AQ i have a countif formula that count the data as you enter it. The data validation that i require is once the value in column AQ is more than one, then an error message must pop-up that stop the user and say " You can only enter the claim number once a day"
I have tried this formula in the custom validation but it does not work =COUNTIFS($B$4:$B$5000,"="&B4,$AO$4:$AO$5000,"="&AO4)<2
Any ideas where i am going wrong?
I am trying to setup a sheet where you are only allowed to have a certain entry once a day. I want the data valadation to stop the user if they try to enter the value again for the day
What i have done so far is that i have highlighted column B where you enter the values. In column AQ i have a countif formula that count the data as you enter it. The data validation that i require is once the value in column AQ is more than one, then an error message must pop-up that stop the user and say " You can only enter the claim number once a day"
I have tried this formula in the custom validation but it does not work =COUNTIFS($B$4:$B$5000,"="&B4,$AO$4:$AO$5000,"="&AO4)<2
Any ideas where i am going wrong?
i no where i went wrong. Formul should be =COUNTIFS($B$4:$B$5000,"="&B4,$AO$4:$AO$5000,"="&AO4)=1
