Excel General

[sjanaswamy]

Hi there,

If I have two columns of numbers in an excel spreadsheet is it possible
to put in some formulae or some other function thatlist out the common
numbers in both the columns. Basically I need to eliminate the #'s in
column A that figure in Column B too.

Thanks for the help.
Cheers,
Srini

 

[Niek Otten]

Look here:

http://www.cpearson.com/excel/duplicat.htm#HighlightingDuplicates

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|
| Hi there,
|
| If I have two columns of numbers in an excel spreadsheet is it possible
| to put in some formulae or some other function thatlist out the common
| numbers in both the columns. Basically I need to eliminate the #'s in
| column A that figure in Column B too.
|
| Thanks for the help.
| Cheers,
| Srini
|
|
| --
| sjanaswamy
| ------------------------------------------------------------------------
| sjanaswamy's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=14057
| View this thread: http://www.excelforum.com/showthread.php?threadid=573850
|