Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
comparing two columns
I have a spreadsheet in Excel 2000 that has two columns. Basically I
want to find out which of the lesser-number-of-numbers columns has a matching number in the larger-number-of-numbers column. It would look like this A B -------- -------- 1561465 1561465 < 1654345 4564343 1545485 8452154 < 8452154 1454654 1654652 1365145 1546848 8545212 9546531 2584521 6543546 1564654 5452133 2154542 1777754 8959599 9546531 < Thanks! for anyone's help BrianCampbell |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
comparing two columns
We can use conditional formatting:
say the data are in columns A & B Select A1 and pull-down Format Conditional Formatting... Select Formula Is and enter: =(COUNTIF(B$1:B$65536,A1)0) and select a bright background color copy this cell and paste/special format down the whole column then Select B1 and pull-down Format Conditional Formatting... Select Formula Is and enter: =(COUNTIF(A$1:A$65536,B1)0) and select a bright background color copy this cell and paste/special format down the whole column All the matches will be hi-lighted -- Gary''s Student " wrote: I have a spreadsheet in Excel 2000 that has two columns. Basically I want to find out which of the lesser-number-of-numbers columns has a matching number in the larger-number-of-numbers column. It would look like this A B -------- -------- 1561465 1561465 < 1654345 4564343 1545485 8452154 < 8452154 1454654 1654652 1365145 1546848 8545212 9546531 2584521 6543546 1564654 5452133 2154542 1777754 8959599 9546531 < Thanks! for anyone's help BrianCampbell |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
comparing two columns
In C1 put this formula and copy down.....
=IF(ISNA(VLOOKUP(B1,A:A,1,FALSE)),"","<") Vaya con Dios, Chuck, CABGx3 wrote in message oups.com... I have a spreadsheet in Excel 2000 that has two columns. Basically I want to find out which of the lesser-number-of-numbers columns has a matching number in the larger-number-of-numbers column. It would look like this A B -------- -------- 1561465 1561465 < 1654345 4564343 1545485 8452154 < 8452154 1454654 1654652 1365145 1546848 8545212 9546531 2584521 6543546 1564654 5452133 2154542 1777754 8959599 9546531 < Thanks! for anyone's help BrianCampbell |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing multiple columns | New Users to Excel | |||
Comparing Columns, Then copying data | Excel Discussion (Misc queries) | |||
Comparing stacked columns | Charts and Charting in Excel | |||
comparing columns | Excel Discussion (Misc queries) | |||
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) |