| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Match data uneven columns
Hi,
I have values in A and I would like to compare that with a list of values in B. All of the values in B will be in A but the values in A may not be in B. What I would like to have happen is for the corresponding B value to line up on the same row as the A value. Does that make sense at all? Thanks Diddy |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Match data uneven columns
In helper column C:
=IF(ISNUMBER(MATCH(A2,B:B,0),A2,"") Copy down as needed, then either hide column B, or copy, paste special - values. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Diddy" wrote: Hi, I have values in A and I would like to compare that with a list of values in B. All of the values in B will be in A but the values in A may not be in B. What I would like to have happen is for the corresponding B value to line up on the same row as the A value. Does that make sense at all? Thanks Diddy |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Match data uneven columns
Thank you Luke,
I added a bracket =IF(ISNUMBER(MATCH(A2,B:B,0)),A2,"") Many thanks Diddy "Luke M" wrote: In helper column C: =IF(ISNUMBER(MATCH(A2,B:B,0),A2,"") Copy down as needed, then either hide column B, or copy, paste special - values. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Diddy" wrote: Hi, I have values in A and I would like to compare that with a list of values in B. All of the values in B will be in A but the values in A may not be in B. What I would like to have happen is for the corresponding B value to line up on the same row as the A value. Does that make sense at all? Thanks Diddy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combining Uneven Columns | Excel Worksheet Functions | |||
| Charting xy scatter of uneven columns of data | Charts and Charting in Excel | |||
| lookup with uneven columns | Excel Worksheet Functions | |||
| Parse data with uneven lengths and different delimiters | Excel Worksheet Functions | |||
| Generate a smooth curve from uneven data points in a "stepped" co. | Excel Worksheet Functions | |||
Linear Mode
