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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
AlanConsultantCommented:
Hi Ben,

How about the attached?

Does that work?

Alan.
EE-29067384-Data-Validation-Test-Ve.xlsx
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.