How to display data based on criteria

[Roz Davis]

I have lets say 3000 rows of data. I know how to use Filter to display only what I want, then copy to a separate spreadsheet. And I've done the copy the entire master sheet to a 2nd sheet and cut on filter to display only what you want......

... is there a function that I can use with the IF statements or something to point from one spreadsheet to another and display ONLY if criteria is met

Or do I have to write VB

I sure hope this makes sense.

 

[alansidman]

Trying to visualize your needs. Perhaps a Vlookup

http://www.techonthenet.com/excel/formulas/vlookup.php

Alan

 

[Roz Davis]

Yes... I have. Let me see if I can explain better

I have 10 rows and 2 columns of data
SHEET1
A B
1 10 aaa
2 25 bbb
3 10 aaa
4 25 bbb
5 10 ccc
6 10 aaa
7 25 ddd
8 25 bbb
9 10 aaa
10 10 ddd

On SHEET2
I only want any row with 10 in column A
ON SHEET3
I only want any row with 25 in column A

When I use on SHEET2.... IF(sheet1!A,10,...etc)... if its NOT it still takes up a row on SHEET2. I only want it there IF it meets the criteria.

I would end up with 6 on SHEET2 (10), AND 4 rows on SHEET3 (25)

I want to do is there a formula/function or something that can do this?