Microsoft Office Forums - View Single Post - Data Validation

Thread: Data Validation

View Single Post

Old

11-17-2023, 11:16 PM

firozmohammed firozmohammed is offline

firozmohammed is offline

firozmohammed uses Windows 11

Windows 11 firozmohammed uses Office 2021

firozmohammed uses Office 2021

Office 2021

Novice

The original poster

Join Date: Nov 2023

Posts: 3

firozmohammed is on a distinguished road

Default

Thank you for the prompt response and help. I have used the following formula:
=COUNTIF($E$3:$E$20000,E3)=1

Thank you once again.

Reply With Quote