#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
goodmike
 
Posts: n/a
Default return a list


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

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Norman Jones
 
Posts: n/a
Default return a list

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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Lookup a value in a list & return multiple corresponding values medic Excel Worksheet Functions 2 May 30th 06 11:38 PM
Drop down list to return row number? infojmac Excel Discussion (Misc queries) 4 May 22nd 06 10:06 PM
Return a price based on a customer from a drop down list Pete Elbert Excel Discussion (Misc queries) 7 May 1st 06 02:54 AM
return a list goodmike Excel Worksheet Functions 1 January 28th 06 11:17 PM
Lookup values in a list and return multiple rows of data Amanda L Excel Worksheet Functions 2 December 2nd 04 04:48 PM


All times are GMT +1. The time now is 06:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"