Excel DataValidation List exclude value in range -

Can anyone think in a clever way that I can exclude a value in the data validation list?

I am using a dropdown (A1) and then data validation list source

  = INDIRECT (LEFT (A1,5) and "LIST") I generate this dependent dropdown (A2).  

The first 5 characters in the first dropdown values ​​form part of the designated range for the second dropdown

However in these dependent lists, I want to ignore the values ​​which are all I can not remove them from named categories, but if possible I would not want to show them in the other dropdown

I know that the named categories From many categories May be made but I'm not sure if it is possible that in the source box using only a named range, it will be dynamically generated with an array formula (I "do not use xxx" instead of other things and id Not to make many designated colors for the Sames list es If this is possible because "Do not use xxx" may be able to use in future and "do not use" will be removed from value)