Selecting data for report

  • Thread starter Thread starter Lost in excel
  • Start date Start date
L

Lost in excel

I need help which is probably basis to most of you, thanks in advance

I have a spreed sheet with this type of data

Item Quantity Price Total
xxx 23 $64 xxxx
xxx 0 $74 xxxx
xxx 14 $222 xxxx

What I would like to do is be able to create a seperate spreed sheet that
only counts the items that total over 0. Is this possible

Thanks

jim
 
You could use Autofilter and select "is greater than"

Data > Filter > Autofilter

Click on the filter arrow on the Quantity Column and select:

Custom and select "is greater then" and zero from the arrow dropdowns.

You can then copy and paste the data without the zeros.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Back
Top