Selecting all that equal 'x'

[XFrog]

Okay. I have an employee database and I can do this in MySQL database or whatever, but I need this in Excel. So I'm trying to figure out if I have say this:
fname - lname - employee#
Michael - A - 321
Fred - B - 453
Tom - C - 765
Michael - D - 984
George - E - 345
Hank - F - 865

I want to make a function that would grab all the names that = 'Michael'
and diplay them like this:
Michael - A - 321
Michael - D - 984

Can I even do this in Excel?

Thanks

 

[wigi]

Hello

Yes, the Autofilter will do this. You can find it under "Data".

 

[XFrog]

Thank you.