Posted to microsoft.public.excel.misc

scubadiver scubadiver is offline

external usenet poster

Posts: 55

row matching using IF

I have two sets of rows that I want to match on account number. I have
formatted them both to number if I subtract one from the other I get zero and
if I add them I get the sum but if I use the following

=IF(D2=L2,1,0)

I still get zero. Can someone explain?

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
Matching	AlexD	Excel Discussion (Misc queries)	1	April 25th 08 03:31 PM
Matching identical data using data only once in the matching proce	Robert 1	Excel Discussion (Misc queries)	1	June 29th 07 04:22 PM
Help with Matching Text Fields - Then Moving the Matching Cells Side by Side	[email protected]	Excel Discussion (Misc queries)	2	June 11th 07 02:38 PM
Matching	cj21	Excel Discussion (Misc queries)	4	January 30th 06 07:40 PM
Matching data and linking it to the matching cell	yvonne a via OfficeKB.com	Links and Linking in Excel	0	July 13th 05 07:30 PM

All times are GMT +1. The time now is 02:22 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us