Extracting Data from a Sheet

[Crispo]

I have a report with a list of headings in rows A2:A99 and figures for each one in B2,C2,D2 and so on. I need to extract from this list only one greater than 0 and put them into another sheet for graph. Obviously I could graph the original sheet, but the graph is to big and it picks up all the 0 balances.

Please help me !

 

[Tazguy37]

Have you looked at Advanced Filter?

In the Excel help file there's a good example: "Filter by using advanced criteria"

You have to have column labels, and a criteria range with the same labels. I'd post and example, but I need to d/l the HTML Maker on this PC.

Hope that helps a bit!

 

[Crispo]

Cheers Taz, I'll give it ago !

 

[Law27]

at column c use this formula

=IF(B6>0,B6,"="&NA())

then the chart data point to column a and column c

hope it helps