deposit tickets

[Excel otomatic AmDeposit ticket]

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.

[pinmaster]

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,Sheet1!$A$1:$A$10,0)))
to get the matching amount

select both cells and copy down as far as needed.

HTH
JG