#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Debby Bunce
 
Posts: n/a
Default LIst Problem

Fellow Excellians,

I need a little help

Picture my screen

I have 16 teams and about 12 to 15 people per team

Cell C1 TO C100 Contains Various Team Names
Cell D1 to D200 Contains peoples Names



In Cell A1 Contains "Team Name"

in Cell A2 i want to select a person from the list i have created in C1 & C2
but it needs to filter out only the people that play for that team selected
in A1


Anyone Got any idea's


Thanking so much in advance


Steve





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
Matching Lists Where List Size is Unequal zgall1 Excel Discussion (Misc queries) 1 February 16th 06 11:21 PM
List box setup, placement, and functionality Ladybug726 New Users to Excel 3 November 21st 05 03:52 AM
Filtered list & maximum no columns problem claytorm Excel Discussion (Misc queries) 0 August 24th 05 10:52 AM
Update master list with other lists Chab Excel Worksheet Functions 0 August 4th 05 03:46 PM
loop trough e-mail address list to send task lists with outlook Paul. Excel Discussion (Misc queries) 2 April 14th 05 11:48 AM


All times are GMT +1. The time now is 10:02 AM.

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"