findin values

Hi
i have a spreadsheet that is set up as a grid
column B is faults
columns c to z are hours(24)
in the faults column i have ten faults
So we have

FAULTS 1 2 3 4 5 6 7
Fault 1 1 2
Fault 2 1 4
Fault 3 2
~~
~~
~~
totals 1 5 4

what i want to do is look through column c(hour 1) and return only the
faults(column B) and Qty where a fault has something other than zero or
Blank
i need to ignore the totals

can anyone please point me in the right direction?

thanks


kevin

Hi Kevin

Select A1:Z1
Data>Filter>Autofilter
Choose drop down on hour required and select Not Blank

Regards

Roger Govier



kevin carter wrote:

>Hi
>i have a spreadsheet that is set up as a grid
> column B is faults
>columns c to z are hours(24)
>in the faults column i have ten faults
>So we have
>
> FAULTS 1 2 3 4 5 6 7
> Fault 1 1 2
> Fault 2 1 4
> Fault 3 2
> ~~
> ~~
> ~~
>totals 1 5 4
>
>what i want to do is look through column c(hour 1) and return only the
>faults(column B) and Qty where a fault has something other than zero or
>Blank
>i need to ignore the totals
>
>can anyone please point me in the right direction?
>
>thanks
>
>
>kevin
>
>
>