Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Comparing Addresses from 2 different Worksheets

Try copying the formulas directly from my response and paste directly into
the formula bar in your sheet, then press CTRL+SHIFT+ENTER to confirm it.

Attached is a sample with the earlier 2 array formulas implemented:
http://www.freefilehosting.net/download/3jeie
AAH.xls

You can copy n paste directly from the sample's formula bar into your actual
sheet's formula bar.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:15,700 Files:353 Subscribers:53
xdemechanik
---
"AAH" wrote in message
...
Hi Max

I am now getting a "too many arguments for this function" error, then it
highlights the zero at the end of the function.
--
AAH



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
Comparing two worksheets David Excel Discussion (Misc queries) 1 February 19th 07 05:12 PM
answer to odd results when comparing hyperlink addresses Patricia Shannon Links and Linking in Excel 0 March 9th 06 07:28 PM
Comparing two Worksheets double__T Excel Worksheet Functions 2 February 17th 06 06:37 AM
Comparing Two Worksheets for changes Jugglertwo Excel Discussion (Misc queries) 1 December 7th 05 08:56 PM
copying addresses from one workbook to another into several worksheets Hans Excel Worksheet Functions 1 July 27th 05 06:10 PM


All times are GMT +1. The time now is 05:42 PM.

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

About Us

"It's about Microsoft Excel"