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
I have two long columns of digits and need to identify same-row nonequal
pairs. How can this be done? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to identify same row matches in two columns of #s using Excel
"NBM" wrote:
I have two long columns of digits and need to identify same-row nonequal pairs. How can this be done? One way .. Assume data in cols A and B, from row2 down Put in C2, copy down: =A2=B2 Where col C evaluates to: FALSE would be the rows you're interested in Just do a Data Filter Autofilter on C1, select FALSE from the droplist to filter out all rows with FALSE for closer inspection And if there's possibility that some numbers in cols A/B might be text numbers Put instead in C2, copy down: =A2+0=B2+0 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#3
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) |