findin values

[kevin carter]

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

 

[Roger Govier]

Hi Kevin

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

Regards

Roger Govier