Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting Data
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...o&userid=34709 View this thread: http://www.excelforum.com/showthread...hreadid=547510 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ranking query | Excel Discussion (Misc queries) | |||
sorting data and automatic graphs | Charts and Charting in Excel | |||
Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
Automatically sorting data | Excel Discussion (Misc queries) | |||
how do you prevent data from changing values when sorting linked . | Excel Discussion (Misc queries) |