Hello, hope that someone could help
What I want to do is that use an Excel formula to trigger a popup if the value entered in a particular column is a duplicate unless if the duplicate value is a "-" or a blank cell. The function would be able to run for the whole column.
For example below: Only F7 will have a popup.
<tbody>
</tbody>
I am currently using data validation and I checked the Ignore blank to ensure that if the cell is blank, the data validation would not run.
I chose custom and initially, I wrote: =COUNTIF(F:F,F2=1) Writing this runs for all duplicated values, which is not what I want.
Then I wrote: =(COUNTIF(F:F,F2=1)<>"-")Writing this suddenly stop checking duplicated values. No popup even when there are duplicated values.
Hope that I could get some help. Thank youuu
What I want to do is that use an Excel formula to trigger a popup if the value entered in a particular column is a duplicate unless if the duplicate value is a "-" or a blank cell. The function would be able to run for the whole column.
For example below: Only F7 will have a popup.
1 | F |
2 | Number |
3 | 1234 |
4 | - |
5 | 1233 |
6 | |
7 | 1234 |
8 | - |
<tbody>
</tbody>
I am currently using data validation and I checked the Ignore blank to ensure that if the cell is blank, the data validation would not run.
I chose custom and initially, I wrote: =COUNTIF(F:F,F2=1) Writing this runs for all duplicated values, which is not what I want.
Then I wrote: =(COUNTIF(F:F,F2=1)<>"-")Writing this suddenly stop checking duplicated values. No popup even when there are duplicated values.
Hope that I could get some help. Thank youuu
Last edited: