| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Sorting Data
I have informations for transactions: A1:A10= date B1:B10= Name C1:C10 = Costs There are rows that contain no data. Examle: rows 1.3.4,9 may have data rows 2,5,6,7,8,10 would be empty I'd like to sort the data to elimated the empty rows at the following locations and show 4 consecutive rows of data. : A12:A22= sorted dates B12:B22= Sorted names C12:C22= Sorted costs Any help is appreciated, Thanks Travelersway -- travelersway ------------------------------------------------------------------------ travelersway's Profile: http://www.excelforum.com/member.php...o&userid=17623 View this thread: http://www.excelforum.com/showthread...hreadid=516707 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ranking query | Excel Discussion (Misc queries) | |||
| sorting data and automatic graphs | Charts and Charting in Excel | |||
| Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
| Automatically sorting data | Excel Discussion (Misc queries) | |||
| how do you prevent data from changing values when sorting linked . | Excel Discussion (Misc queries) | |||
Threaded Mode
