Filter by Formula

[Berrett]

I have a set of data on one tab of an Excel workbook. On another tab (or ideally in another workbook) I would like to produce a list of records that match a certain criterion. Here is a generic example.

On the Raw Data tab I have raw records like this (imagine two columns - one with a color and another with a score):
Color Score
Red 96
Blue 68
White 96
Black 37
Red 25
Blue 41
White 29
Black 55
Red 14
Blue 71
White 26
Black 45
Red 43
Blue 45
White 46
Black 41
Red 22
Blue 39
White 85
Black 46

On the Filtered Data tab I want to see a list of all records that are RED - without blank records in between. So the data on the Filtered Data tab would look like this:

Color Score
Red 96
Red 25
Red 14
Red 43
Red 22

Can that be done?

 

[Legacy 436357]

Yes I believe this will do it:

Excel Workbook
	A	B	C	D	E
1	Color	Score		Color	All Matches
2	Red	96		Red	96
3	Blue	68			25
4	White	96			14
5	Black	37			43
6	Red	25			22
Sheet1