Duplicate entry not allowed in excel -answer to preet makkar

Dear Sir <br> i want to make an excel sheet in which i want that duplicate entries should not be allowed. <br> For Example in cell A1 if i write a name Raj <br> and again in cell say D5 i write Raj, it should not allow the entry and give an error message "Duplicate Entry"... Is it possible?

 

 

Answer: See attached file (A simpel answer to it)

Replies (3)

attached file is here

THANKS FOR SHARING SIR.yes

Regards,

RAJESH CHOUDHARY

Thanks Sir :)

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
19 September 2026
Finance Manager

Mugdha Art Studio

Hyderabad

CA

View Details
Company
08 September 2026
Audit Executive

Thammana & Associates

Srikakulam

B.Com

View Details
Company
09 September 2026
Semi Qualified CA / CA Inter - 2 Groups Cleared

Getmyca Consultant Pvt Ltd

New Delhi

CA Inter

View Details
Company
Featured 21 September 2026
Consultant - Reporting

Finrep Advisors LLP

Mumbai

CA

View Details
Company
ARTICLESHIP 18 September 2026
Industrial Trainee

Twenty Point Nine Five Ventures Private Limited

Noida

CA Inter

View Details
Company
19 September 2026
CA/Semi-CA/BCom

Pravin Sarvaiya

Mumbai

CA Inter

View Details
Company
22 September 2026
Account Assistant

Chirag P Shah & Co. Chartered Accountant

Pune

B.Com

View Details
Company
09 September 2026
SENIOR AUDITOR & ACCOUNTS MANAGER

Anupam Parashar & Co.

Ghaziabad

CA Final

View Details