| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to identify same row matches in two columns of #s using Excel
Hi!
In a third column enter this formula and copy down: =IF(A1<B1,TRUE,"") If the pair doesn't match the formula will return TRUE. Biff "NBM" wrote in message ... I have two long columns of digits and need to identify same-row nonequal pairs. How can this be done? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I wrap Excel columns in a printout? | Excel Discussion (Misc queries) | |||
| Excel columns disappearing | Excel Discussion (Misc queries) | |||
| How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
| print excel columns on less pages | Excel Discussion (Misc queries) | |||
| Columns in Excel will not allow user to click in them | Excel Discussion (Misc queries) | |||
Hybrid Mode
