Comparing two lists in Excel

[Jimmy Joseph]

I have two lists of partnumbers in excel

1. All active partnumbers (in column B of the worksheet"All_partnumbers")
2. Active Partnumbers with a active linkage in BOM.(in column B of the
worsheet "BOM_linkage_num")

All partnumbers are formatted as text. (some of the partnumbers are purely
numerical, some are alpha numeric and some starts with "0", hence formatted
as text)

I would like to compare list 1 with list 2 and excel to format the
partnumber in list 1 to Bold if that partnumber has an existence in list 2.

Help please!

Regards,

Jimmy Joseph

 

[aaron.kempf]

in a database; you could say 'select partnumber from lista where
partnumber not in (select partnumber from listb)'

it's a lot easier to do things like this in the database world

good luck on leaving excel and diving into databases

 

[Bob Umlas]

Name the list2. Say it's called List2 (on BOM_Linkage_num).
select list1, use format/conditional formatting, change "cell value is" to
"Formula Is", enter this formula (assumes active cell is B1)
=NOT(ISERROR(MATCH(B1,List2,0)))
then click the format button, the Font tab, select Bold.

Bob Umlas
Excel MVP