| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Searching for data and placing in new worksheet
Is there any method by which, on a large spreadsheet being used as a
database, I can search for repeating data, take that data and place in a new worksheet. I have tried advanced filters and pivot tables but this does not seem to be the most elegant solution. Because it is a large database/worksheet, pivot tables become unworkable |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I put data in excel in placing order? eg first, second, th. | Excel Discussion (Misc queries) | |||
| Placing Trendlines Behind Data Points | Charts and Charting in Excel | |||
| retaining fonts when placing excel worksheet into pagemaker? | Excel Discussion (Misc queries) | |||
| Searching and Retrieving data from a Worksheet | Excel Worksheet Functions | |||
| Worksheet reference (i.e placing worksheet name in a cell) | Excel Worksheet Functions | |||
Hybrid Mode
