if, then

Occasional Visitor

I have 2013. I am trying to say if there is a value in a specific column of a specific worksheet, I want to copy that row to a different worksheet to build a spreadsheet of just those rows with that word. Is it possible?

1 Reply

@Nans2013 

 

Are you in a position to update your version of Excel? If so, what you want to do would be a breeze with a relatively new function called FILTER. Here's a video demonstrating it.