Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
NBM
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Max
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Biff
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I wrap Excel columns in a printout? R2 Excel Discussion (Misc queries) 1 April 1st 06 09:47 AM
Excel columns disappearing Steve Lewington Excel Discussion (Misc queries) 4 February 24th 06 01:09 PM
How do i copy columns of data in notepad into microsoft excel? Jason Excel Discussion (Misc queries) 1 February 10th 05 10:20 PM
print excel columns on less pages a_ryan1972 Excel Discussion (Misc queries) 1 February 9th 05 06:41 PM
Columns in Excel will not allow user to click in them Kim Excel Discussion (Misc queries) 1 December 28th 04 07:37 PM


All times are GMT +1. The time now is 11:50 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"