lookup functions

  • Thread starter Thread starter Laurelle
  • Start date Start date
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?
 
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.
 
Back
Top