Forum Discussion
How to copy row data matching specific column criteria
jazmarc You may want to use a pivot table for this and filter by the names you are interested in. You could even add a slicer to easily select those names.
Alternatively, if you have the up to date Excel with dynamic arrays you should have a function called FILTER() which can make this process relatively easier if you have something against pivot tables. Basically you can use:
=FILTER(A:A,ISNUMBER(MATCH($AO:$AO,$CC:$CC)))where I have the names listed in column CC (you could change that to a different column, different sheet, or defined name)
and then copy that right for however many columns you need.
mtarler I'm still working with your FILTER idea. Tried pivot table too. I keep coming back to how do I
setup the FILTER to be aware of the 10 names that do not change but may appear in today's daily report?
Here's a very small subset of my data. Names were changed. I'm trying to copy the rows that match certain names in column E to another spreadsheet (DailyRptB.xlsx). I'm really only concerned with matching on names, not numbers. For simplicity sake say Terri cooper, Barbara, Connie, JC Frank names are the rows I want to MATCH and FILTER on. Whatever FILTER criteria I use, tomorrow the column values may not have Terri, Barbra etc. but have Yuri, Tiffany, Marc (who also comprise my unique group of Sales people).
SO my Filter should incorporate those names too in case they show up during the week.
Will my Filter function look like this?
=FILTER(A:A,ISNUMBER(MATCH($E:$E="Terri Cooper","Barbara","Connie","JC Frank","Yuri","Tiffany","Marc"$B:$G)))
Then how does the copy to another spreadsheet work?