| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
find data based on conditon of a maximum date
I need to write a fomula that will give me the data in column C (quantity
received) after finding the most current date in column B (date received). Example: if the product was Test, I would need to end up with the quantity received of 25,00 PRODUCT DATE RCVD QTY. RCVD TEST 01/24/08 10,000 HELP 12/18/07 40,000 HELP 02/12/08 3,000 TEST 02/12/08 25,000 Any assistance with this formula would be greatly appreciated. Thanks. HELP 02/12/08 3,000 -- gcmontgomery30 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Get data with certain conditon | Excel Discussion (Misc queries) | |||
| Conditional formatting data based on the maximum in the set | Excel Worksheet Functions | |||
| Find Maximum date | Excel Worksheet Functions | |||
| Need to find Min value based on date range entered | Excel Worksheet Functions | |||
| Need to find Min value based on date range entered | Excel Worksheet Functions | |||
Threaded Mode
