| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Matching check to payment amounts
If on my spreadsheet I break out a column that just has checks in (col A) I
would like to in column (B) match all the places that the check is applied. I have used numbers in col (B) but if I could use the letters of the alphabet that would even be better, but either way would be a great help. A B c d 1235 1 R $500.00 1795 2 R $150.00 1999 3 R $ 12.00 1795 2 R $545.00 2007 4 R $195.00 1235 1 R $100.00 1795 2 R $ 10.00 Thanks Donna |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to find matching criteria in 1 column, then add amounts in a | Excel Worksheet Functions | |||
| How do I use Excel 2007 to determine late payment amounts | Excel Discussion (Misc queries) | |||
| Is there a template for a Check Payment Voucher | Excel Worksheet Functions | |||
| Format dollar amounts for check printing | Excel Discussion (Misc queries) | |||
| matching dupliclates and then looking up the corresponding amounts | Excel Discussion (Misc queries) | |||
![Donna[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
