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