Hi can anyone help?
I have posted this question at
https://www.mrexcel.com/forum/excel-...ml#post4858826
Moderator Edit; also posted at: http://www.ozgrid.com/forum/showthread.php?t=204653
I have hundreds of rows of data with 11 columns A:K that I need to filter (sheet1).
I would like to first filter all the rows (A2:K) using the name in column A so all the rows for Sarah are showing and then filter all these rows using column E leaving only the rows (A2:K) that start with '0' (E:K)
Then repeat the process for David to leave only the rows (A2:K) that start with '1'(E:K)
Then again with Tom to leave only the rows (A2:K) that start with '-1'(E:K)
Then again with Bethany leaving rows starting with '2'(E:K)
And again with John leaving rows '-2'(E:K)
And again with Katie leaving rows '3'(E:K)
Deleting all the rows filtered out.
Bookmarks