Friday, December 13, 2024

Prevent duplicate entry in excel.

On the Settings tab, choose "Custom" from the Allow drop down list and enter =COUNTIF($D:$D,D2)=1 into the Formula box
at
Labels: , ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

How not to fill filtered out cells when dragging down from another sheet

Steps: Apply your filter in Sheet1 . Select the range where you want to paste the formula (e.g., A2:A100 ) but only visible cells will...