extracting data from a table

[Andyd74]

I have a table with names against codes, with amounts for each entry. I want to display each entry that is more than 0 in another report table. i.e.

code a code b code c
andy 4 2 7
bob 0 0 1
martin 2 0 0


So here, i want to go through each column and put the name,the code and the amount in another three cells, as long as the amount is more than zero.

Thanks

Andy

[Debra Dalgleish]

You can use an Advanced Filter to extract the records where the amount
is greater than zero. There are instructions in Excel's Help, and here:

http://www.contextures.com/xladvfilter01.html


Andyd74 wrote:
> I have a table with names against codes, with amounts for each entry. I
> want to display each entry that is more than 0 in another report table.
> i.e.
>
> code a code b code c
> andy 4 2 7
> bob 0 0 1
> martin 2 0 0
>
>
> So here, i want to go through each column and put the name,the code and
> the amount in another three cells, as long as the amount is more than
> zero.
>
> Thanks
>
> Andy
>
>


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html