Duplicate entry not allowed in excel -answer to preet makkar

1069 views 3 replies

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
ARTICLESHIP 28 June 2026
Article Assistant

Sharma Chetan And Company

Gurgaon

CA Inter

View Details
Company
10 June 2026
Senior Account Executive

JDS Advisory LLP

Ahmedabad

CA Inter

View Details
Company
20 June 2026
Assistant Accounts Manager

Fintax Professionals

Gurgaon

CA Inter

View Details
Company
ARTICLESHIP 09 June 2026
Article Trainee

Numbertree LLP

Mumbai

CA Inter

View Details
Company
Featured 24 June 2026
HEAD - AUDIT AND TAXATION

A R JADHAV AND ASSOCIATES

Mumbai

CA Inter

View Details
Company
ARTICLESHIP 24 June 2026
CA Article Trainee

Rahul Dang & Associates

Pune

CA Inter

View Details
Company
25 June 2026
AUDIT MANAGER

JDAS & ASSOCIATES

New Delhi

CA

View Details
Company
24 June 2026
Chartered Accountant

CA Darshita Shah & Co

Nadiad

CA

View Details