| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
macro and/or functions
I have a table below that I want to only to see the materials with the last
purch date. material purch date A 1/2/2008 A 2/10/2007 A 2/12/2008 A 12/2/2006 A 3/23/2008 A 8/17/2007 B 1/2/2008 B 2/10/2007 B 2/12/2008 C 12/2/2006 C 3/23/2008 C 8/17/2007 -- Sue |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
macro and/or functions
See other post. Pls post in only one group
-- Don Guillett Microsoft MVP Excel SalesAid Software "Sue" wrote in message ... I have a table below that I want to only to see the materials with the last purch date. material purch date A 1/2/2008 A 2/10/2007 A 2/12/2008 A 12/2/2006 A 3/23/2008 A 8/17/2007 B 1/2/2008 B 2/10/2007 B 2/12/2008 C 12/2/2006 C 3/23/2008 C 8/17/2007 -- Sue |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
macro and/or functions
i couldnt tell if it worked on the first one. sorry bout that
-- Sue "Don Guillett" wrote: See other post. Pls post in only one group -- Don Guillett Microsoft MVP Excel SalesAid Software "Sue" wrote in message ... I have a table below that I want to only to see the materials with the last purch date. material purch date A 1/2/2008 A 2/10/2007 A 2/12/2008 A 12/2/2006 A 3/23/2008 A 8/17/2007 B 1/2/2008 B 2/10/2007 B 2/12/2008 C 12/2/2006 C 3/23/2008 C 8/17/2007 -- Sue |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
macro and/or functions
Here's my best guess:
A2:A13 = mat code B2:B13 = dates E2:E4 = A, B, C Enter this array formula** in F2 and copy down to F4: =MAX(IF(A$2:A$13=E2,B$2:B$13)) Format as DATE ** array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER) -- Biff Microsoft Excel MVP "Sue" wrote in message ... I have a table below that I want to only to see the materials with the last purch date. material purch date A 1/2/2008 A 2/10/2007 A 2/12/2008 A 12/2/2006 A 3/23/2008 A 8/17/2007 B 1/2/2008 B 2/10/2007 B 2/12/2008 C 12/2/2006 C 3/23/2008 C 8/17/2007 -- Sue |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there any function or macro to get all the available functions? | Excel Discussion (Misc queries) | |||
| Formula or Macro to insert Data in Cell when having more than 7 Functions | Excel Worksheet Functions | |||
| Help combining formatting in macro functions | Excel Worksheet Functions | |||
| efficiency: database functions vs. math functions vs. array formula | Excel Discussion (Misc queries) | |||
| Creating & Combining Macro to Functions | Excel Worksheet Functions | |||
Hybrid Mode
