LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11
Default Compare 2 Columns, then output a list

If I have two columns like below. How do I set something up, so that I can
input a Team Name, lets say Team2 for example and then under that team name I
get a list of every player on that team. So for the example below I would
end up with.

Team2
b
c
e


CA CB
Team Players
Team1 a
Team2 b
Team2 c
Team3 d
Team2 e
Team1 f
Team3 g

Thank you in Advance!!


 
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
Compare list of number between two columns Theresa Excel Discussion (Misc queries) 2 April 11th 08 12:32 AM
how to compare two columns and get a output from it [email protected] Excel Worksheet Functions 3 July 5th 06 08:19 AM
Compare 2 columns and output to a 3rd column jamaican jewel Excel Discussion (Misc queries) 1 March 22nd 06 09:26 PM
Compare multiple column of data and list out common and unique component in adj columns kuansheng Excel Worksheet Functions 15 February 1st 06 10:49 PM
Compare 2 columns, and create a list of items that are in both lists ruby2sdy Excel Worksheet Functions 3 October 8th 05 11:04 AM


All times are GMT +1. The time now is 09:39 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"