| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct - Pulling info based on lenght of time between dates
I need the formula to search column A:
If there are any matches in column A, AND the amounts in column B are the same AND the dates are within 30 days of each other in column C, Result = Y. Otherwise = €œ€ Plan # Amount $ Rcvd. Date Paid Formula Result 300531 2,500.00 1/15/2007 Y 300056 8,900.00 1/18/2007 300531 2,500.00 1/31/2007 Y 350011 4,800.00 1/31/2007 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trying to select a specific range based on the time value of user form input | New Users to Excel | |||
| varying validation info based on preceding info | Excel Discussion (Misc queries) | |||
| Calculating time increments from dates during working hours | Excel Worksheet Functions | |||
| IF statement for time based data | Excel Worksheet Functions | |||
| update info on 2 sheets @ same time | Excel Worksheet Functions | |||
Threaded Mode
