COUNTIF() in Excel (Office 2013)
Dear All I want to Eliminate the possibility of entering a Duplicate item in a range. I used =COUNTIF($C$3:$C$151,C3)<=1 in Excel (office 2013) in Custom Data Validation. Below is the Error I get. I am not able to figure it out. Please give your input. 
Solution
Try this:
=COUNTIF( $C$3:$C$151; C3 ) <= 1
- Best option to refresh a single query using VBA
- Repeat VBA Code to run for another cell in the same sheet
- Create a folder and sub folder in Excel VBA
- How to loop in excel without VBA or macros?
- Configure default number format to 0 decimal places for new/existing workbooks in Excel 365 ProPlus?
- Delete objects and replace spaces left after that with symbols in black (color)
- EXCEL randbetween- text representation - clarification
- How do I access a historical weather API from open-meteo in Excel using VBA?
- Finding the correct remaining customer term with a given goods volume
- Speeding Up Index-Match for Large Dataset
- How to get current time in VBA as string? Ex. 7:38 PM, I want "073800"
- Data cleanup for large data set
- Adding a newline character within a cell (CSV)
- Excel SORT Function in Conjunction With UNIQUE, TOROW & VSTACK
- Hide and Unhide Rows via Single Button
- Xlwings Excel and Windows Task Scheduler issues
- Put borders below all the rows with the last date value in a date series
- Issue with IF sentence containing AND & OR functions
- Unprotect an Excel file programmatically
- Complicated xlookup across two sheets with multiple criteria
- Sumif times (datetime format) are greater than 22:30
- How to loop concatenate separately, groups of rows with VBA?
- SumProduct over sets of cells (not contiguous)
- Adding a "0" to the beginning of a 4 digit excel cell to make it a zip code.
- Can't unprotect an excel worksheet in Workbook_BeforeSave
- Change formula to a function that evaluates the starting formula
- Chart range based on the value in a cell
- Changing cell colour using VBA in Excel
- How to color excel cells with specific values in dataframe Python
- Talend import, transform a raw file and export to CSV