| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to calculate the data of the last order
A B C D
1 P O Date Code Kgs $ 2 01-Jan-08 R 1 10 3 03-Feb-08 F 2 20 4 07-Mar-08 X 3 30 5 10-Mar-08 Z 10 40 6 27-Apr-08 G 5 50 7 01-May-08 Z 6 60 For code Z, I need a formula to calculate the $ of the last order. Z of course can have several dates. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can I calculate S&H on a sliding scale in an order form? | Excel Worksheet Functions | |||
| how do i calculate the order quantity? | Excel Worksheet Functions | |||
| Making Excel Calculate In Correct Order | Excel Discussion (Misc queries) | |||
| Daily Macro to Download Data, Order and paste in order | Excel Worksheet Functions | |||
| What function or formula do I use to calculate ROI with this data? | Excel Worksheet Functions | |||
Threaded Mode
