Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Set out below are three columns of data starting at A1, B1, C1 respectively.
Is it possible to match column B and C to A? The columns are identical except that the order is different. The data does vary in name and number of course. HOLBECK GHYLL INDIAN TRAIL 94 SPANISH ACE PACIFIC PRIDE 80 HARRY UP MAGIC GLADE 55 COSEADROM TEXAS GOLD 83 PIC UP STICKS MISARO 96 RACCOON MR WOLF 94 MR WOLF SPANISH ACE 79 CONTINENT HARRY UP 56 CANADIAN DANEHILL TALBOT AVENUE 94 MAGIC GLADE CONTINENT 96 MISARO LITTLE EDWARD 80 LITTLE EDWARD PEOPLETON BROOK 56 SAFARI MISCHIEF DIANE“S CHOICE 94 GEORGE THE SECOND SAFARI MISCHIEF 96 PEOPLETON BROOK ORANMORE CASTLE 92 BOND BOY HOLBECK GHYLL 66 DIANE“S CHOICE RACCOON 61 TALBOT AVENUE BOND BOY 45 RAINBOW BAY COSEADROM 65 PACIFIC PRIDE CANADIAN DANEHILL 69 INDIAN TRAIL PIC UP STICKS 36 ORANMORE CASTLE RAINBOW BAY 78 TEXAS GOLD GEORGE THE SECOND 45 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Column matching - sorting. Fairly hard problem, I think. | Excel Discussion (Misc queries) | |||
Matching problem | Excel Worksheet Functions | |||
Matching data and linking it to the matching cell | Links and Linking in Excel | |||
A matching problem | Excel Worksheet Functions | |||
matching problem using VBA | Excel Worksheet Functions |