pullling only non-zero value rows from a table
Posted by kevin on August 27, 2001 8:35 AM
I have a table in excel that contains three columns with numbers and a fourth column that sums the first three columns. I need to pull data from this table into a new table, but i want it to only pull the rows that contain a total greater than zero. for example if I have data in rows 1, 2, 3, 5, and 6, and there is zero in row 4, I want the data to get pulled into a new table where the data from row 1 will get pulled to row 1, row 2 to row 2, row 3 to row 3, (row 4 will not get pulled), row 5 to row 4, and row 6 to row 5. Hope this makes sense. Can anyone help with this?
Thanks,
Kevin