| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
retrieve duplicate values from arrays
My spreadsheet contains the following:
A B C D 1 123 xxxx x1x1 12345 2 101 yyyy y1y1 23456 3 123 zzzz z1z1 34567 4 215 aaaa a1a1 89100 In another spreadsheet, I want to get all data using column A as the criteria including those with duplicate values and not just the first one. In effect I want my other worksheet to show: A B C D 1 123 xxxx x1x1 12345 2 123 zzzz z1z1 34567 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding Duplicate Arrays in a table | Excel Discussion (Misc queries) | |||
| Retrieve values from 2 worksheets. | Excel Worksheet Functions | |||
| Using CORREL with arrays containing null values | Excel Discussion (Misc queries) | |||
| Problem with plotting a chart when using arrays as Values and Xvalues | Charts and Charting in Excel | |||
| Two arrays need highlight duplicate in one of the array | Excel Worksheet Functions | |||
Threaded Mode
