Generate a List of All Items iN Column A that Match a Criteria in Column B

All,

I have a sheet that i need to extract a list from. The data would be like below. What i would like is a list of all the ID's that Match a Specific Manu. List all ID's that have a Manu of SG. Should return a column that has 1000,1003,1006,1009 and on... I'm think this could be done with Index and match but cant quit figure it out. Any Help Please

ID Manu
1000 SG
1001 IT
1002 AGS
1003 SG
1004 IT
1005 AGS
1006 SG
1007 IT
1008 AGS
1009 SG
1010 IT
1011 AGS
1012 SG
1013 IT

Pivot table would make that in a snap.

Pete

Thank for the response, While it true that a pivot table is easy to use for this data. I am trying to automate a CSV output. Can i save a Pivot Table as a CSV i have never tried, just kind of assumed it wouldn't work.

Pete

Give it a go.
Pete

Thanks, That works just fine and allows me to pull all of the data i need out easily... (little embarrassed i didn't just try it in the first place)
Now i'm just simply curios. Could this be done using index and match?

Pete

How about

Excel 2013 32 bit

	A	B	C	D	E
1	ID	Manu
2	1000	SG		SG	1000
3	1001	IT			1003
4	1002	AGS			1006
5	1003	SG			1009
6	1004	IT			1012
7	1005	AGS
8	1006	SG
9	1007	IT
10	1008	AGS
11	1009	SG
12	1010	IT
13	1011	AGS
14	1012	SG
15	1013	IT

Sheet: Smith

Excel 2013 32 bit

	E
2	=IFERROR(INDEX($A$2:$A$15,SMALL(IF($B$2:$B$15=$D$2,ROW($A$2:$A$15)-ROW($A$2)+1),ROWS($1:1))),"")

Sheet: Smith

Works Great Thanks

One more question before I mark this closed. In the provided formula how would i reference the sheet name for a criteria instead of $d$2?

This can possibly work for me. Thanks.