I have the following data in columns A & B


Arabic 3
Chinese 4
English 2
French 1
German 3
Italian 1
Hebrew 4
Russion 1
Spanish 3

I would like to create a list in column C, that lists all the languages
where the value is 3 - so column C should look like this:

Arabic
German
Spanish

Is there a formula that can do this?

Any help would be appreciated.

Thanks,
Michael


--
michael.a7
------------------------------------------------------------------------
michael.a7's Profile: http://www.excelforum.com/member.php...o&userid=33027
View this thread: http://www.excelforum.com/showthread...hreadid=565355