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 August 2026
PAID ARTCILE ASSISTANT

My Legal Tax Consultants Pvt. Ltd.

Noida

CA Inter

View Details
Company
ARTICLESHIP 14 August 2026
Article Assistant

N J Suresh & Associates

Bengaluru

CA Inter

View Details
Company
ARTICLESHIP 17 August 2026
CA Article Trainee

ASC Group

Noida

CA Inter

View Details
Company
ARTICLESHIP 29 August 2026
Article Assistant

RRPM & ASSOCIATES LLP

Chennai

CA Inter

View Details
Company
21 August 2026
Accountant

A G International

Kolkata

B.Com

View Details
Company
28 August 2026
Assistant Manager

NRS AND ASSOCIATES

Kozhikode

CA Inter

View Details
Company
ARTICLESHIP 08 August 2026
Article Assistant

Sanath Sheshagiri & Co.

Bengaluru

CA Inter

View Details
Company
Featured 19 August 2026
Chartered Accountant

apricus india

Pune

CA

View Details