Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Line information pulled out base on date
I have a spread sheet with 4 columns named (Row3)::
Month End, Posted, Accrual, Amount. Posted & Accrual columns are text and what I am looking for is that when a date changes in A1 and matches a date under month end, I can get (in separate cells) the correspondent value for posting Accrual and Amount. a sample of one of the rows would be: Month End Posted Accrual Amount 1/27/06 Feb06 25 days Mar06 10 days 25,500.00. I appreciate your help with this. fernando Note: I tried to use index function but it does not work with text. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) | |||
Data Base Link | Excel Discussion (Misc queries) | |||
Help - Information with time and date | Excel Discussion (Misc queries) | |||
How can I sum information in a list with a date range? | Excel Worksheet Functions |