ExcelBanter - return a list

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - return a list (https://www.excelbanter.com/excel-worksheet-functions/94642-return-list.html)

I have 50 employees listed and have columns that represent 6 different
skills. I want to generate a list of the employees that have a given
skill.
I am usually good at figuring this logic out , but am having a brain
cramp??

mike

--
goodmike
------------------------------------------------------------------------
goodmike's Profile: http://www.excelforum.com/member.php...o&userid=30936
View this thread: http://www.excelforum.com/showthread...hreadid=553079

Hi Goodmike

Consider using Excel's autofilter featu

Data | Autofilter

If you are not familiar with this feature, see Debra Dalgleish's tutorial
at:

http://www.contextures.com/xlautofilter01.html

---
Regards,
Norman

"goodmike" wrote in
message ...

I have 50 employees listed and have columns that represent 6 different
skills. I want to generate a list of the employees that have a given
skill.
I am usually good at figuring this logic out , but am having a brain
cramp??

mike

--
goodmike
------------------------------------------------------------------------
goodmike's Profile:
http://www.excelforum.com/member.php...o&userid=30936
View this thread: http://www.excelforum.com/showthread...hreadid=553079