|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 22nd, 2007, 02:30 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup
Hi
i have two column with similar but not equal values haw can i use vlookup to see wich elements of the B column are not in the A column? Thanks a lot 
|
|
#2
August 22nd, 2007, 02:46 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
vlookup
One way ..
Assuming data in row2 down Place in C2: =ISNUMBER(MATCH(B2,A:A,0)) Copy down to the last row of data in col B Then do an autofilter on col C, filter out FALSE -- Max Singapore http://savefile.codm/projects/236895 xdemechanik --- "zolabus" wrote: Hi i have two column with similar but not equal values haw can i use vlookup to see wich elements of the B column are not in the A column? Thanks a lot
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
