Find same text in other sheet to clean up list/namerange

[Bientje]

Hi,

I am new to excel so probably already annoying ;-)

But I have a question:
I have two sheets: "process" and "lists". In the "lists" sheet there are 7 columns with rows containing text values, every column has a name range that is used for several data validation dropdown lists in the "process" sheet.

In the lists are text values that aren't used in the dropdown menus in the "process" sheet, but how can I filter them out so I can clean up my lists?

 

[sudipto3003]

HI,
welcome to the forum, to clear your query by the members it will better if you upload a sample file.

 

[SirJB7]

Hi, Bientje!

As a new user you might want to (I'd say should and must) read this:
http://chandoo.org/forum/forums/new-users-please-start-here.14/

And regarding your issue, consider uploading a sample file (including manual examples of desired output if applicable), it'd be very useful for those who read this and might be able to help you, relieving the contributor of having to build a test file, if necessary. Thank you.

Regards!

 

[NARAYANK991]

Hi ,

How can we identify the entries in the lists which are not used in the drop-downs ?

Can we assume that if the process sheet has many entries , then we take all those entries as valid , and match these against the drop-down lists , and remove all those that do not appear ?

If so , see this file for a formula-based solution.

Narayan