Ask Your Question

Bring Entire Row To Another Sheet If D1 Meets Criteria

asked 2017-01-20 23:00:28 +0200

bdenn gravatar image


Question: How do I display cells A1, B1, C1, D1 on a different sheet if E1 says AMEX?

I want all rows that have AMEX in column E to display in this list on another sheet and everything that is not AMEX, say Best Buy to be excluded from this list.

Thanks! Bdenn

edit retag flag offensive close merge delete

3 Answers

Sort by » oldest newest most voted

answered 2017-01-20 23:26:52 +0200

updated 2017-01-20 23:27:37 +0200

You may put this formula to A1 of second sheet's A1:


and then drag the formula to A1:D[N].

edit flag offensive delete link more

answered 2017-01-20 23:32:11 +0200

bdenn gravatar image

Mike, That works but I want to make sure no blank rows exist. so if row 1, 2, 4 are AMEX and row 3 is best buy I want to not display this row.

Thanks, Bdenn

edit flag offensive delete link more

answered 2017-01-21 00:23:39 +0200

m.a.riosv gravatar image

updated 2017-01-21 00:24:32 +0200

If you want a selection with result on other sheet, then the easy way it's using a pivot table, also can be done with an advanced filter a bit more complicated to understand an use but regular expressions are available for selection.


edit flag offensive delete link more


For the pivot table how do you create the cell to no AMEX?

bdenn gravatar imagebdenn ( 2017-01-21 00:29:54 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-01-20 23:00:28 +0200

Seen: 32 times

Last updated: Jan 21 '17