| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
when the column text is different, how to insert one row below eac
I have a spreadsheet with column, Date, Name, Amount. only a few columns, but
a few thousand rows with same Name, different Date and different Amount. Sample below: Date Name Amount 4/1/07 John 100 4/1/07 Michael 200 4/2/07 John 110 4/2/07 Michael 220 4/4/07 John 130 4/4/07 Michael 230 First I will sort the above by Name then by Date, then I insert one blank row just below John. When I have a hundred different Names, How to automatically insert one blank row when the Name is different? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert cell text every 5 rows in a column | Excel Discussion (Misc queries) | |||
| text box insert in Excel - text box lines print on second copy | Excel Discussion (Misc queries) | |||
| How to insert text in one column and populate numbers in another | Excel Worksheet Functions | |||
| how insert same text in empty cells in column (10000 rows) | Excel Worksheet Functions | |||
| Need a macro to insert text in a cell that already has text.Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
