Sorting Data

Giganews Newsgroups
Subject: Sorting Data
Posted by:  dgoodrid (dgoodrid.28qfl0_1149180306.1043@excelforum-nospam.com)
Date: Thu, 1 Jun 2006

Does anyone know how to Look throught a list of cells with specific data
in them, and then pick the first entry of a selected item name and then
get more data from that selection. Then look for the 2nd entry and do
the same until there are no more entries.

Example:-

"Home Name"  "Home Score"  "Away Score"    "Away Team"
-------------------------------------------------------
England                3                1                  Sweeden
Germany              0                9                  Iran
Italy                    4                  4                  Spain
Holland                0                0                  Argentina
Germany              2                20                England

What i want is to pick all of England Games's as you enter them down a
long list. The Data i would need to extract would be "Home Name" "Home
Score" "Away Score" "Away Team" and then list then in the order they
appear in the list. Then do the same for all other teams. Into a list
like below

**England**
"Home Name"  "Home Score"  "Away Score"    "Away Team"
-------------------------------------------------------
England                3                1                  Sweeden
Germany              2                20                England

**Germany**
"Home Name"  "Home Score"  "Away Score"    "Away Team"
-------------------------------------------------------
Germany              0                9                  Iran
Germany              2                20                England

--
dgoodrid
------------------------------------------------------------------------
dgoodrid's Profile:http://www.excelforum.com/member.php?action=getinfo&userid=34709
View this thread:http://www.excelforum.com/showthread.php?threadid=547510

Replies