complex IF statements in Excel

December 11, 2015 at 06:48:12
Specs: Windows 7
I have data in excel from columns A-F. In Column E, if there was an error it displayed a value, if the column is correct there was no value in Column E. How can I create a function (maybe an if statement?) that pulls the entire column if there is an error value in column E and copy's it into a new sheet in Excel.

message edited by MelanieJ

See More: complex IF statements in Excel

Report •

December 11, 2015 at 17:50:06
I'm confused.

What does "if the Column is correct" mean?

What does Column E have to do with the data in columns A:F?

What column do you want to copy?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question