software

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))),quot;quot;, SMALL(Sheet1!$A$1:$A$10,ROW(1:1)))
to get the check #

then in the next column:
=IF(A1=quot;quot;,quot;quot;,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: www.excelforum.com/member.php...foamp;userid=6261
View this thread: www.excelforum.com/showthread...hreadid=498917