| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Selecting only rows of data with unique identifier
I have a worksheet with many hundreds of rows of data and 16 columns. In
column P there is an identifier (numeric). Can I use a formula in a second worksheet to reproduce the first worksheet but only picking out the rows where either the identifier is unique or in the case where there are duplicates picking out just one of these rows (any one will do). Thanks!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Ignoring Rows When Extracting Data From One Worksheet To Another | Excel Worksheet Functions | |||
| Selecting rows based on criteria | Excel Discussion (Misc queries) | |||
| Excel: How to choose data on two separate rows in the same column | Excel Worksheet Functions | |||
| ranking query | Excel Discussion (Misc queries) | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Threaded Mode
