| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Function to find row with most current date
I'm wondering if there's a way I could make a function where it would use values from a certain row by means of the most current date within that row. Pretend I have A1="5/25/2005" B1="NaOH" C1="$120.00" A2="6/01/2005" B2="NaOH" C2="$145.00" A3="6/22/2005" B3="HCl" C3="$100.00" so now I want E1 to show me NaOH's most recent price based on column A's date and (of course) column B's chemical (for reference to the correct price). Is this duable? -- malik641 ------------------------------------------------------------------------ malik641's Profile: http://www.excelforum.com/member.php...o&userid=24190 View this thread: http://www.excelforum.com/showthread...hreadid=381354 |
| 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 | |||
| Using date function in an if statement | Excel Worksheet Functions | |||
| Lock in current date | Excel Discussion (Misc queries) | |||
| DATEVALUE OF CURRENT DATE | Excel Worksheet Functions | |||
| How do I program a cell to automaticinput the current date as dat. | Excel Worksheet Functions | |||
Threaded Mode
