Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Matching
Hello,
I have a question. I have two sets of data, one of which is contained in the other. The problem is, the big set has additional data that I want to isolate for the shorter data set. For example: a 123 123 b 234 789 c 345 234 a 456 890 b 567 c 678 a 789 b 890 where column A is the additional data, column B is the large set, and C is the small set. I want to pull out the instances where the data in a single cell in column C matches any single cell in column B. My result is: 123 a 789 a 234 b 890 b Can anyone give me any ideas? I'm really stuck here. Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Matching
adjust to fit.looking in col J for a match in col K and returning col I
=INDEX(I:I,MATCH(K1,J:J)) -- Don Guillett Microsoft MVP Excel SalesAid Software "Demosthenes" wrote in message ... Hello, I have a question. I have two sets of data, one of which is contained in the other. The problem is, the big set has additional data that I want to isolate for the shorter data set. For example: a 123 123 b 234 789 c 345 234 a 456 890 b 567 c 678 a 789 b 890 where column A is the additional data, column B is the large set, and C is the small set. I want to pull out the instances where the data in a single cell in column C matches any single cell in column B. My result is: 123 a 789 a 234 b 890 b Can anyone give me any ideas? I'm really stuck here. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enter Data on one tab, then find matching data on another tab | Excel Worksheet Functions | |||
Matching a column of new data to existing larger data set. | Excel Worksheet Functions | |||
Matching identical data using data only once in the matching proce | Excel Discussion (Misc queries) | |||
Can I merge data in 2 sheets matching rows of data by last name? | Excel Discussion (Misc queries) | |||
Matching data and linking it to the matching cell | Links and Linking in Excel |