Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Formula Query
I have a spreadsheet where I have to match last payment received to the date
of receipt. At the moment I am manually going through each loan and checking when we received a payment and updating at the end of the spreadsheet. ie. I will go through and see we last received pmt in Jan 08 on Loan 1 and then go across and input Jan 08 in the loan recieved cell. Is there any way for this to be done automatically and to update the date when payment received? Thanks Simon |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Formula Query
The spreadsheet would look something like the below:
Loan No Dec 07 Jan 08 Feb 08 Mar 08 Apr 08 Pmt Received 1. 100 Dec 07 2. 200 Jan 08 3. 300 Mar 08 4. 400 Apr 08 Can anyone assist please? Thanks "Simon" wrote: I have a spreadsheet where I have to match last payment received to the date of receipt. At the moment I am manually going through each loan and checking when we received a payment and updating at the end of the spreadsheet. ie. I will go through and see we last received pmt in Jan 08 on Loan 1 and then go across and input Jan 08 in the loan recieved cell. Is there any way for this to be done automatically and to update the date when payment received? Thanks Simon |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 / MS Query - editing existing query to another sheet | Excel Discussion (Misc queries) | |||
Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
Converting an Excel formula to an Access query formula | Excel Discussion (Misc queries) | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
Excel - Formula Query: Search for and Return Value | Excel Worksheet Functions |