Extracting data

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

Guest

Hi, all

Need your help for the following:
Have a excel database with 75 columns and about 1750 rows.
How can I extract the contents of a full row, when a specific criteria
is met on column 1?

Any ideas?

Tks in advance
 
Hi
you could use multiple VLOOKUP statements. e.g. something like
=VLOOKUP(value,I1:X100,COLUMN(A:A),0)
and copy this to the right
 
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

Extracting Data 2
How to filter rows data based on background color of individual cells 1
Merged Cells Limitations 1
how do you have 2 criterias be picked up in a lookup? 2
Excel Extract Text from decimal separated string 6
Moving data in rows to columnar 2
Need some help 2
How to extract list of persons available from an availability list 7

Back
Top