Hi all,

I have a spreadsheet that I need to set up but I can't figure out if what I
want to do is possible...

The spreadsheet tracks clients that have 10+ deals outstanding with us and
tracks which person covers the client, how many trades there are, etc.

I was wondering if there is automated way/formula to pull ONLY the clients
with ten or more trades out of a list of thousands of clients.

For example, say I have 280 different clients in my data pool, but only 15
of them have more than 10 lines. How can I write a formula to "search" the
big pool and only pull out the stats for the clients with 10 or more?

Thanks in advance.