I have a list of collections every month, cash, credit, check. I would like
to be able to get a list of the check # and amounts on another worksheet in
order and no spaces in between.

Try something like this:

in the first column type:
=IF(ISERROR(SMALL(Sheet1!$A$1:$A$10,ROW(1:1))),"", SMALL(Sheet1!$A$1:$A$10,ROW(1:1)))
to get the check #

then in the next column:
=IF(A1="","",INDEX(Sheet1!$B$1:$B$10,MATCH(A1,Shee t1!$A$1:$A$10,0)))
to get the matching amount

select both cells and copy down as far as needed.

HTH
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=498917