Comparing two large excel speadsheets.

UEHOOSIER

New Member
Joined
Jun 28, 2015
Messages
2
I have a large original report of 200 rows and 60 columns. I need to compare it to be exactly the same as the test report. It contains numbers and words. I am currently using the cell speak to compare. Is there is a quicker way?
Thank you.
 

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,547
Have a third workbook, linking to cells in those to compare, like:
Code:
='[Original rep.xlsx]Data'!A1='[Test rep.xlsx]Data'!A1
in cell A1, copied to cover the range of the reports.

The cells that are the same will be TRUE, and those that don't will be FALSE.

If you have access to Excel 2013 (Microsoft Office Professional Plus 2013) or through Office 365, you have access to a new feature in Excel that allows you to electronically compare two workbooks and identify any differences in those workbooks. This new feature – Compare Files – will also do what you want:

Comparing Two Workbooks with Excel 2013's Compare Files Feature
 

bountiful

New Member
Joined
Jun 18, 2015
Messages
31
Hey thanks guys for all the participation, this really is a great board!
I did'nt quite understand what you were saying before when you were trying to help me, sorry!

here's my function as it is now. Have I fxed what you were talking about?
Code:
Public Function InColumnn(strSearch As String, r As Range) As Boolean
Dim c As Range
Dim result As Boolean
Set c = r.Find(strSearch, , xlValues, xlWhole)
If c Is Nothing Then
    result = False
    'InColumn = False    ' this makes Excel unhappy
Else
    result = True
    InCoulumn = True     ' whereas this does not...
End If
End Function
 

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,547
Hey thanks guys for all the participation, this really is a great board!
I did'nt quite understand what you were saying before when you were trying to help me, sorry!

here's my function as it is now. Have I fxed what you were talking about?
Code:
Public Function InColumnn(strSearch As String, r As Range) As Boolean
Dim c As Range
Dim result As Boolean
Set c = r.Find(strSearch, , xlValues, xlWhole)
If c Is Nothing Then
    result = False
    'InColumn = False    ' this makes Excel unhappy
Else
    result = True
    InCoulumn = True     ' whereas this does not...
End If
End Function

Are you sure you've posted to the right thread?
 

Forum statistics

Threads
1,148,277
Messages
5,745,818
Members
423,980
Latest member
zimza

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top