Thread: formula to copy a row to another spreadsheet based on a single condition

I have a spreadsheet that receives constant updates and I need a formula to copy a complete row to another spreadsheet based on a single condition:
A B C D E F G
TEAM
136 2/24/2010 Carlos Miro XOXO 138 Paid online
119 Lisa Lamora XOXO1 128 599
103 Brittany Lumpkin XOXO3 128 188
136 Carlos Miro XOXO1 1289
136 Amaury Alvarez XOXO111
103 Carlos Miro XOXO112
103 Candace Sowdon XOXOXO2 Paid online
119 Mauricio Gomez XOXOXO 1209 Paid online


(Please see attachment for details)


Based on the input of this table, I want to be able to extract the rows that belong to team 103 (for example) and copy them into another table (for that team alone).

I don't want to use Advance filter, but would like to use a formula. I've tried vlookup, but it would these arenot unique rows, I will only get the first line.

I doubt if you can do this with a formula,why not use Advanced Filter or a PivotTable.

Your attachment does not seem to be there