compare or filtering and find

  • Thread starter Thread starter eagerowl
  • Start date Start date
E

eagerowl

Q#1. 2 columns next to each other. 1 list on each column.
List #1 (left) contains 100 combinations. 1 combination in
each cell. 3 different numbers make one combination example:
1 2 3 .the combinations are not repeated in the same list.

List #2 (right) contains x number of combinations similar to the one
in list 1.

- compare the 2 lists and highlight the ones that are repeated fro
list 1 into list 2.

Q. #2. One worksheet - universe B- with a huge amount of combinations
all different from each other. Take list #1 and find each one of th
combinations listed in list 1 and highlight'em in
universe B.

Obviously I am not a regular excel user, and try to figure out wit
books but I just couldn't.

Any hel will be appreciated
 
Eagerowl,

Q1.

In cell c2 enter =vlookup(b2,$a$2:$a$lastrownumber,
1,false) and copy down the length of your data in column B.

When a value appears, you have a match, when "#Value"
appears you do not.

Q2.
Depends on the structure of UniverseB, however, you can
use vlookup similarly with reference to a different
workbook, the only trick is that when you use the vlookup,
both sheets must be open.

Steve
 
eagerowl

Q#1. Assuming list 1 is in colum A and starts in A1, and list 2 is in column B and starts in B1. Select column B. Go to Format>Conditional_Formatting. Use "Formula is" and enter

=NOT(ISERROR(MATCH(B1,A:A,0))

Then click format and select whatever type of highlighting you prefer. Now any value from list 1 will be highlighted inlist 2.

Q#2. Same as above

If you need help adjusting this formula post back with specific cell references and ranges

Good Luck
Mark Graesse
(e-mail address removed)


----- eagerowl > wrote: ----

Q#1. 2 columns next to each other. 1 list on each column
List #1 (left) contains 100 combinations. 1 combination in
each cell. 3 different numbers make one combination example
1 2 3 .the combinations are not repeated in the same list

List #2 (right) contains x number of combinations similar to the one
in list 1

- compare the 2 lists and highlight the ones that are repeated fro
list 1 into list 2

Q. #2. One worksheet - universe B- with a huge amount of combinations
all different from each other. Take list #1 and find each one of th
combinations listed in list 1 and highlight'em i
universe B

Obviously I am not a regular excel user, and try to figure out wit
books but I just couldn't

Any hel will be appreciated
 
Back
Top