lookup information in a row like a record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a worksheet that dumps data which each row reads like a record. I
need to search through that worksheet and under one column (identifier) take
all records that have the same identifier and bring them into another
spreadsheet - but only certain columns of data. Is this possible in Excel?
 
try data>filter>autofilter

--
Don Guillett
SalesAid Software
(e-mail address removed)
utraceme said:
I have a worksheet that dumps data which each row reads like a record. I
need to search through that worksheet and under one column (identifier) take
all records that have the same identifier and bring them into another
spreadsheet - but only certain columns of data. Is this possible in
Click to expand...
Excel?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help? with extracting unsorted data from a worksheet, no blank lin 4
Lookup value off by one row 2
help needed with lookup and related functions 3
Excel Help to copy information from one row at a time to another sheet 1
How to Auto Reference Worksheet Tab ID's in Formulas? 9
Arranging single-row records across multiple rows 4
lookup data across worksheets, one with 56K rows 4
Returning multiple text data into 1 column from many column entrie 1

Back
Top