Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
compaing data in columns
Hi,
I have two sets of data, data in sheet 1 column a has about 400 rows in each row there is data with wild cards, sheet 2 have about 4000 rows and has the data without the wild cards, i want to be able to what data in sheet2 appears in sheet 1, cannot seem to get this to work, example data shown below Sheet 1 Sheet 2 APAXX12 APADR12 APAXX34 APATY89 APRXX89 APRJNDT APRXXDT x Is the wild card in sheet1 Please Help i am going crazy!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Checking data in 2 columns against a further 2 columns.... | Excel Worksheet Functions | |||
Sorting Data into columns without replacing the columns with data | New Users to Excel | |||
Help in code Steve G wrote to move data from 4 columns to 21 columns | Excel Programming | |||
Arrange data spanning 8 columns and 3 rows to 24 columns and 1 row | Excel Discussion (Misc queries) | |||
Transposing three columns into one row after manipulating data in columns | Excel Discussion (Misc queries) |