LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 33
Default Matching Problem Possible?

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
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
Column matching - sorting. Fairly hard problem, I think. A S-D Excel Discussion (Misc queries) 13 April 7th 06 01:52 PM
Matching problem JaB Excel Worksheet Functions 1 December 14th 05 01:32 PM
Matching data and linking it to the matching cell yvonne a via OfficeKB.com Links and Linking in Excel 0 July 13th 05 07:30 PM
A matching problem Les Excel Worksheet Functions 3 November 18th 04 05:45 PM
matching problem using VBA mango Excel Worksheet Functions 1 November 1st 04 01:51 PM


All times are GMT +1. The time now is 02:46 PM.

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"