lookup functions

L

Laurelle

I'm not sure which function to use. This is what I have:
Sheet #1
- has 9 column
- has 200 rows
- Column A contains numbers from 1 to 9 in no specific order
A B C D E F G H I
1 3 12 15 16 2 6 8 9
3 6 1 5 2 8 7 32 44
5 2 5 9 3 8 6 20 21
1 8 10 17 33 35 40 50 100

- Columns B to I contains numbers

What I want should look like this in Sheet #2 brought in from sheet #1

A B C D E F G H I
1 3 12 15 16 2 6 8 9
1 8 10 17 33 35 40 50 100

Can you let me know how I can accomplish this?
 
J

JBeaucaire

If you're simply wanting to only see the rows of data with "1" in column A,
you can do that by AutoFilter. The only requirement is that your data have a
row of titles for each column across the top.

1) If they don't have titles, add them.
2) Click on the titles row
3) Select Data > Filter > AutoFilter to turn it on
4) Select the drop down for column A and choose "1"

You should now be looking at the only the rows you wanted. You could copy
everything at once to Sheet2 now, if you want, since the copy would only take
the visible rows...another benefit of the AutoFilter.

Or, you can just work with the data in place. Once you start using an
AutoFilter you may find the need for a second sheet unnecessary.
 

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

Top