You can use exact function as well =exact(A1, B1) Sent from BlackBerry® on Airtel
-----Original Message----- From: SAJID MEMON <sajidwi...@hotmail.com> Sender: excel-macros@googlegroups.com Date: Mon, 27 Dec 2010 17:15:52 To: Excel Group<excel-macros@googlegroups.com> Reply-To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Need Help URGENTLY - zip file Dear You can compare two files with if formula just copy one file in second file and use =IF(columne one = columne two,"ture","false") hope you can easily find errors thanks > Date: Thu, 23 Dec 2010 01:31:23 -0800 > Subject: $$Excel-Macros$$ Need Help URGENTLY - zip file > From: vilaschav...@gmail.com > To: excel-macros@googlegroups.com > > Hi friends, > > I have two files and want to compare oct with nov to find out changes > oct to nov. in step 1 to step 4 please its urgently > > i attached file with this mail. > > > -- > With Best Regards, > --------------------------------------------------------------------------------- > Vilas Chavan > Email : cvi...@ymail.com, vilaschav...@gmail.com > Mumbai - Maharashtra > 9967458882 > > -- > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts