Hi!

Why not just copy/paste to the other sheet then sort by
the column that contains the #1, #2 etc?

Biff

-----Original Message-----
Example I want to move all the rows that have a #1 in the
first column to a
new work sheet and #2 and so on. I can use this function
=IF('Email
Leads'!A2=1,1,"") and =IF('Email Leads'!A2=1,'Email
Leads'!B2,"") but that
looks for a certain cell. If I have over 25 cells to look
from, what is the
function to use? Thanks
1 Bound Tree
1 Bound Tree
2 ICOM
2 ICOM
2 ICOM
3 Skedco Inc
3 Skedco Inc

.