Autofilter or Advanced filter not working as I want to!

H

Hamidam

Hi...

I have this list of products from A2:A250 , companys orders B2:B250 &
C3:C250 and so on...

what i would like to do is to be able to wiew only the filled cells all
together at the same time for all the companys... say you have en order
on B3 , C216 , D59 then I would like after filtering just see those
three orders and not all 250 products so I would have to scroll and be
observant to see what orders are made... you get it? hmm :confused:

Thanks / Jennifer
 
T

Trevor Shuttleworth

Jennifer

I would suggest that you include a "helper" column, perhaps called "All
Orders" as column E.

Then, in cell E2, add the formula: =COUNTA(B2:D2) and drag down to the
bottom of your data.

Now add AutoFilter on columns A to E. Custom Filter column E on "is greater
than" with a value of 0 (zero).

You should get the desired result.

You'll need to adjust the position of the helper column dependent on the
number of companies.

It might make sense to insert the helper column as column B and then change
the formula to:

=COUNTA(C2:IV2) ... or whatever is the maximum number of companies.

Regards

Trevor
 
H

Hamidam

I have the swedish version of excel so some of the formulas like Find is
Hitta and so on... so there is a little problem of finding the
replacement word for COUNTA... crap microsoft didn't have that in mind
that maybe their programs could be universal so the files could be used
by more than the swedes... shit... and if i install the english version
my boss won't be able to use it anyway... :mad:

anyone who can help me?


Thanks a bunch / Jennifer
 
H

Hamidam

hehe... that was pretty clever! I even understand it!

Thanks very much Trevor! Some solutions are just great! And easy! An
that's the way i like it!

hihi

Jennifer:) :) :) :
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Only print the filled cells? 4
how do I search thru the values in my column and replace with nessesary values 1
How do I use advance filter correctly? 2
Autofilter Not working completely 2
Missing Contacts In List - But found If I Do A Search 3
Filter rows containing cells with values within a range (for example <11 or >10 but <21) 1
Can I Make AutoFilter to be Case-Sensitive? 7
Data Validation Using Lists: help user to find values starting with acharacter (like auto-filter) 6

Top