Data Design & Filter

  • Thread starter Thread starter Kevin H. Stecyk
  • Start date Start date
K

Kevin H. Stecyk

I am using Vista and Office 7.

I have data that is the analogous form of "Part Numbers" and "Locations". I
have Col A with various "PartNos" and Columns B through K of "Locations".

If Location1 has the specific part number, then the Location cell is "TRUE".
If Location1 is missing the part, then the Location cell is "FALSE".

I would like to use the dropdown filter to select the part number in ColA,
and then show only those locations that are true.

At present, when I select the part number, I see all locations with their
TRUEs and FALSEs. I would like to just see the locations with TRUEs. Is
there a way to do this?

My specific situation does not deal with inventory control. However, this
"inventory example" is analogous to my situation and is easy to explain.
 
Back
Top