lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
Hi
I know the formula to use to prevent duplication, thanks for your help. So I went to Data Validation->custome then wrote this formula
= countif($a1:$a5,a1)=1
but did not fully understand it
here is my understanding
This formula will be apply on all the range
=countif(range,a1) =1
=countif(range,a2) =1
=countif(range,a3) =1
=countif(range,a4) =1
=countif(range,a5) =1
let say i want to enter 100 in cell a4, so the formula is =countif(range,a4)=1, so this formula is true because I have a1= 100 therefore excel wont accept me to enter that value. Am I right?
<tbody>
</tbody>
I know the formula to use to prevent duplication, thanks for your help. So I went to Data Validation->custome then wrote this formula
= countif($a1:$a5,a1)=1
but did not fully understand it
here is my understanding
This formula will be apply on all the range
=countif(range,a1) =1
=countif(range,a2) =1
=countif(range,a3) =1
=countif(range,a4) =1
=countif(range,a5) =1
let say i want to enter 100 in cell a4, so the formula is =countif(range,a4)=1, so this formula is true because I have a1= 100 therefore excel wont accept me to enter that value. Am I right?
100 |
200 |
300 |
<tbody>
</tbody>