| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dates and Quantity sort
I have a random list of dates with quantity ordered along with other data in a worksheet. I would like to transfer the date and quantity ordered only over to another worksheet in date order. so original sheet will have cell A6 03/04/05 cell A7 will have 8 cell B6 03/03/05 cell B7 will have 6 cell C6 01/04/05 cell C7 will have 12 In the new sheet i want the resul to show cell A1 03/03/05 cell A2 will have 6 cell B1 01/04/05 cell B2 will have 12 cell C1 03/04/05 cell C2 will have 8 Can someone show me an example please. Thanks for any help -- foilprint0 ------------------------------------------------------------------------ foilprint0's Profile: http://www.excelforum.com/member.php...fo&userid=6245 View this thread: http://www.excelforum.com/showthread...hreadid=507153 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Updating inventory quantity | Excel Worksheet Functions | |||
| Totals by type between dates | Excel Worksheet Functions | |||
| Count between dates by type | Excel Worksheet Functions | |||
| Inventory sheet to track, order & reduce quantity from master. | New Users to Excel | |||
| Make inventory sheet to track, order & reduce quantity from master | Excel Worksheet Functions | |||
Threaded Mode
