Posted to microsoft.public.excel.misc

Jennifer Hammonds Jennifer Hammonds is offline

external usenet poster

Posts: 1

Compare two columns

I am looking to compare information in column G to column H. These are
number formats as below. I found this formula =OR(EXACT(G3, H2:H427)) but
its returning False on all lines. What I'm thinking is happening is that the
next line will read (G4, H3:H427) so the H column is moving down each time.
What am I doing wrong? I have approx 430 lines that I need to compare to see
if they show in the other column. Can you help me please?
G H
0000756892 0000829670

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Compare Two Columns	Michael Laferriere	Excel Worksheet Functions	5	February 3rd 07 09:01 PM
COMPARE 2 COLUMNS	Gary''s Student	Excel Discussion (Misc queries)	0	June 7th 06 07:53 PM
Compare 4 columns?	Deb	Excel Worksheet Functions	1	May 16th 06 09:14 AM
Compare two columns	Need Helper	Excel Discussion (Misc queries)	3	December 4th 04 03:08 AM

All times are GMT +1. The time now is 06:43 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us