probably a simple table problem

[Kashgarinn]

Hi there.

Ok, I have a table with 5 columns which I keep the data in.

On another sheet I want a table which arranges the data from that tabl
in ascending order, and throws out the values which have a 0 in it.

Here's an example

Barn - 1 - 0 - 1 - 2
farm - 0 - 2 - 1 - 0
firm - 2 - 1 - 0 - 0

A drop-down list picks if you arrange the data depending on column 2
3, 4 or 5. Column 1 is never listed as a choice (of course, as it'
just the name for the thing).

Let's say we pick column 1, then the table I want puts firm at the top
then barn, and doesn't show farm.

How can I do this?

K

 

[BrianB]

You could use Data/Filter/Autofilter.
select Custom from the dropdown at the top and set the filter to ..
"does not equal" ...... 0. Copy and paste to another sheet.

You could use Advanced Filter to copy to another sheet with colum
criteria <>0.
See Excel Help for this

 

[Kashgarinn]

BrianB: thanks for replying. However, I'm not sure that that is a
relevant thing.

Here's a run-down of what I want.

On one sheet, I want my original table, which I add to or edit perhaps
once a week or so. I don't want any changes or anything done to it.
It's supposed to be edited by me, and nothing else.

Next, on another sheet I want an instance table of the original table.
This table could have the data-list thingy on it.. however I want a
drop-down-list which selects what column to arrange the table to
(highest value first, lowest values last), and then removes any values
which are 0. How can I do this?

How do I make an instance of the original table?

And my second question, how do I make a drop-down-list choose which
column to arrange the instanced table to?

I don't care if I need to do this in 2 or even 3 tables, just as long
as it gets done so it works.

Thanks for any replies.
K.