| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding The MAX Value
My data table looks like this:
ID Date QTY BOX005 20070103 19626 BOX005 20070104 9618 BOX005 20070105 17465 BOX005 20070108 20612 BOX226 20070109 13310 BOX226 20070110 10859 BOX226 20070111 30335 BOX226 20070112 20015 I am trying to create a table for each ID that shows the Date and Qty of the Maximum Qty - like this table: ID Date QTY BOX005 20070108 20612 BOX226 20070111 30335 The actual data table has around 7000 rows. Thank you in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding non-zero value | Excel Discussion (Misc queries) | |||
| Finding last used | Excel Worksheet Functions | |||
| finding value | Excel Discussion (Misc queries) | |||
| finding the "end" | New Users to Excel | |||
| Finding Value | Excel Worksheet Functions | |||
Threaded Mode
