Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Lookup closest to
I have the following table
Name Date Amount Anemi Test 31-Dec-11 500 Apnea 1 31-Dec-11 300 NB 1 Panamax 31-Dec-13 275 NB 2 Supramax 15-Nov-11 300 Anemi Test 19 Nov 11 123 Anemi Test 30-Nov-11 200 Anemi Test 31-Dec-11 75 I also have a Starting Date which say in this first instance is 1 Jan 12. I want to find and SUM the value for each item nearest to the starting date. In the above the result for Anemi Test would be 375, the SUM for NB 2 Supramax would be 300 and so on. If I were to make the starting date 1 Dec 11 then the result for Anemi Test would be 200 and for NB 2 Supramax would again be 300. Thanks in advance/sgl |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup closest to | Excel Worksheet Functions | |||
Array Lookup to Find Closest Date and Next Closest Date | Excel Worksheet Functions | |||
Closest value lookup? | Excel Worksheet Functions | |||
how do i look up the closest number valuein a lookup? | Excel Discussion (Misc queries) | |||
Lookup Closest Value | Excel Worksheet Functions |