Solved Conditional copy of rows to a new Excel spreadsheet

July 6, 2015 at 14:28:04
Specs: Windows 8
I would like to copy rows from one sheet to another, but only those rows from which a particular cell is >0. The rows containing 0 in that cell, I do not want copied over. Is there a simple formula for that?

See More: Conditional copy of rows to a new Excel spreadsheet

Report •

#1
July 6, 2015 at 15:36:28
✔ Best Answer
If you are copying from Sheet 1 to Sheet 2 starting at cell A1 try this:

=IF(logical test, value if true, value if false)
=IF(Sheet1.A1>0, Sheet1.A1," ")

You can drag this out for the row width and column depth.

EDIT: The IF formula is placed in cells that are in Sheet 2. The original data is in sheet 1. I hope this helps. if this is not clear let me know and I will try to clarify further.

message edited by dcutl002


Report •
Related Solutions


Ask Question