Microsoft Excel Data Validation - Avoid Duplicate

Hello,

I have data validation configured gathering from list of data from Sheet 2 and displaying information using Data Validation on Sheet 1.

However, my goal is: When the object is already listed using data validation on Sheet 1's cell A2 for example, selections for cell A3 becomes limited and information provided on cell A2 should no longer appear
 on the selection for other cells (e.g. A4) and moving forward.

Is this something possible?

Thanks a lot! Really poor excel skills here and trying to fix that up and couldn't help but to reach some experts out there.

Cheers!

Ben
support@blutonetech.com.au
Fernando MarambioAsked:
Who is Participating?
 
AlanConnect With a Mentor ConsultantCommented:
Hi Ben,

How about the attached?

Does that work?

Alan.
EE-29067384-Data-Validation-Test-Ve.xlsx
0
 
AlanConsultantCommented:
Hi Ben,

Probably easiest if you could post your file and we can add to it - creating from scratch or trying to type it all up will be laborious.

Thanks,

Alan.
0
 
Fernando MarambioAuthor Commented:
Data-Validation-Test.xlsxHi Alan,

Thank you for your advise.

I have attached now an excel file of what I am trying to achieve and screenshot of what I am trying to attain in the data validation.

So basically, when doing data validation you list of names and you want to select items from those list of names.

What I want to happen is that, when moving into a different cell, whatever I have already selected should no longer appear as part of the current selection as shown on the screenshot.

Thanks!
Ben
0
Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

 
Fernando MarambioAuthor Commented:
Hi Alan, thanks! That is just exactly what I am trying to achieve.
0
 
Fernando MarambioAuthor Commented:
Good job Alan! More points for you.
0
 
AlanConsultantCommented:
Glad to help :-)

Alan.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.