Sarah
How about using DataFilterAuto or Advanced and copy results to a new sheet.
You could automate it by using a macro.
Debra Dalglesih has a sample workbook that filters and moves the data to a new
worksheet.
http://www.contextures.on.ca/excelfiles.html#Filter
Scroll down to.......
FL0013 - Create New Sheets from Filtered List -- uses Advanced Filter to create
separate sheet of orders for each sales rep visible in a filtered list; macro
automates the filter.
Gord Dibben MS Excel MVP
On Wed, 24 Jan 2007 11:39:02 -0800, Sarah
wrote:
Hi there,
I have a huge data set in 3 columns. The first column labels the datapoints
in columns 2 and 3. There are 5 labels, so there are many datapoints with the
same label. They are not in order (and can't be.) Is there anyway to use a
vlookup or something similar to go to the first column, look for label x and
return all the data rows in a list on a new spreadsheet? A bit like sumif
without the sum.
Thanks!