Bier de Stone (slavezombie) wrote,
Bier de Stone
slavezombie

VLOOKUP function and IF and LastDay, and shoot me now

DATE AMNT PAYMENT STYLE
4/12/7 6.00 check
4/13/7 30.00 check
4/13/7 10.00 cash
4/14/7 45.00 check
4/14/7 20.00 cash
4/14/7 45.00 check


$15.00 $20.00 $5.00
$40.00 $7.50
$25.00

This is what I've got so far. I'm learning to use COLUMNS, COUNTIF, SMALL and FREQUENCY (among other Excel function commands.) I dubplicated a formula for filtering duplicates. Ironic, isn't it. The problem is, I don't want to filter the duplicates, I want to filter out the empty spaces. There is a helpful assortment of sites focused on spreadsheet instruction and one of them is called Officekb. In it, is an entry made by JMB. I am using the idea he/she had for handling data with blank cells, but I can't seem to weed out the function that eliminates duplicate occurances. So, it looks like I'm not wasting time after all, and more important… I'm not a dork.

Subscribe
  • Post a new comment

    Error

    Anonymous comments are disabled in this journal

    default userpic

    Your reply will be screened

    Your IP address will be recorded 

  • 0 comments