can I pull only data from a sheet greater then 0
Dear Expert
I'm trying to pull data from a seperate sheet to another to create
labour coverage chart. I would like to pull it over without bringin
any rows with 0 values so that there are no empty spaces in th
chart. when i try an if equation to do this it just doubles the dat
between 0's
the data would originally look like thi
name in ou
joe 9:00 15:0
dav
mike
chris 12:00 20:0
I would like to pull the data to the chart page so that it come
across to a set sized data table like thi
name in duratio
joe 9:00 6:0
chris 12:00 8:0
I would appreciate anyone assistance in this matter
|