| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
BIG PROBLEM
Dear all,
see the following data : Location Part no. Qty. In-date A1 637A 1000 01-MAY-2004 B1 807K 500 03-MAY-2004 B2 807K 1000 03-MAY-2004 C4 639A 2000 03-MAY-2004 C5 637A 500 11-MAY-2004 C10 807K 1000 03-MAY-2004 D1 639A 2000 04-MAY-2004 Above data is a simplified data for my question. Now, if I just want to show the data which the In-date is 03-may- 2004, and then the different part no will be distinguished by insert a row. Below is my wanted result. Location Part no. Qty. In-date C4 639A 2000 03-MAY-2004 B1 807K 500 03-MAY-2004 B2 807K 1000 03-MAY-2004 C10 807K 1000 03-MAY-2004 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
BIG PROBLEM
Maybe autofilter?
-----Original Message----- Dear all, see the following data : Location Part no. Qty. In-date A1 637A 1000 01-MAY-2004 B1 807K 500 03-MAY-2004 B2 807K 1000 03-MAY-2004 C4 639A 2000 03-MAY-2004 C5 637A 500 11-MAY-2004 C10 807K 1000 03-MAY-2004 D1 639A 2000 04-MAY-2004 Above data is a simplified data for my question. Now, if I just want to show the data which the In-date is 03-may- 2004, and then the different part no will be distinguished by insert a row. Below is my wanted result. Location Part no. Qty. In-date C4 639A 2000 03-MAY-2004 B1 807K 500 03-MAY-2004 B2 807K 1000 03-MAY-2004 C10 807K 1000 03-MAY-2004 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Colon at the end of excel file name(ex: problem.xls:1, problem.xls | New Users to Excel | |||
| Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
| problem with a conditional max problem | Excel Discussion (Misc queries) | |||
| Problem when multipple users access shared xl-file at the same time, macrocode for solve this problem? | Excel Programming | |||
Linear Mode
