| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide similar rows
I've imported 7000 rows of data (accounts) and I'd like to hide multiple rows
for the same account. Is there a way to auto indent or convert to outline so I can collapse as needed? I'd like to end up with only one row for each account. Thanks in advance |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hide similar rows
Look at Data - Subtotals
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| max value from multiple rows of similar information | Excel Worksheet Functions | |||
| How to add similar rows in excel sheets | New Users to Excel | |||
| remove rows in one sheet from similar rows in another | Excel Worksheet Functions | |||
| Specify which rows to NOT hide, and have excel hide the rest | Excel Programming | |||
| Aligning similar rows | Excel Worksheet Functions | |||
Hybrid Mode
