Data Filtering

[HT]

I am trying to figure out how I can filter data from a specified range. What
I am specifically trying to do is similar to auto filtering. I have a large
inventory list and I can get the same items from different vendors. Example:
Column 1 = Stock Item, Column 2 = Vendor 1, Column 3 = Vendor 2, Column 4 =
Vendor 3 etc. What I want to do is be able to filter a vendor name across
those vendor columns and have it show the products I can get from the vendor
I chose. The auto filter will only filter the vendor and products in that
column, but the vendor could be in any of the vendor columns and I need it to
find the vendor wherever it appears. Is there a way to accomplish this in
excel 2003. Thanks

 

[Joerg Mochikun]

Using a better layout, with one column for Stock Item and another one for
Vendor, would enable you to use the powerful database functions that Excel
offers, but if you are stuck with your layout you could try the following:

Assuming that row 1 contains the titles "Stock Items", "Vendor 1", "Vendor
2", you should type into D1 the name of the vendor you want to filter.

Type into D2 the formula
=COUNTIF(B2:C2,$D$1)
and copy down to the bottom of your list.

Now you can use Autofilter to filter column D for the value 1 (=vendor name
you typed into D1)

Cheers,

Joerg

 

[Herbert Seidenberg]

Easily done in Excel 2007
No hidden rows.
Automatic reset, consolidation.
http://www.mediafire.com/file/yttngdzzwlj/12_12_08b.xlsm

 

[Joerg Mochikun]

OP's question was: "Is there a way to accomplish this in excel 2003"