I AM USING DATA VALIDATION FEATURE
I WANT TO AVOID DUPLICATE NUMBERS AND ALSO PLEASE SHOW ME HOW TO DELETE DUPLICATES IN EXCEL.
I WANT TO DISPLAY NUMBERS BETWEEN 100 TO 300 FROM A RANGE OF NUMBERS
=AND((COUNTIF(A:A,A1,<=1),(A1>="100",A1<="300"))
I HAVE USED THIS FORMULA BUT UNABLE TO SOLVE MY ISSUE
Solved by I. E. in 28 mins