| 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 |
| 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) | |||
Threaded Mode
