deposit tickets

  • Thread starter Excel otomatic AmDeposit ticket
  • Start date
E

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.
 
P

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
 
Top