Prev: Forumal writing for imported sheets
Next: Missing sheet tabs and horizontal scroll bar
From: Candida on 31 Mar 2010 12:02
I have two work sheets that contain bill of material information of about
3000 component items required to build a system. There have been updates to
the bill of material therefore, I need to compare the two worksheets and
create a detailed list of changes or updates from the 3/9 bill of material to
the 3/30 bill of material created. All of the columns headers are the same
are the same for both worksheets, however there may be some added or
subtracted rows or just additional information populated into the columns
that were already in place such as Revision level in row 1 column F may have
went from revision "A" to revision "B" or the qty may be different in Column
H. Can someone help me to compose a formula to compare the two sheets. My
columns are from A thru BI and my row numbers are from 1 to 3000. Please
help.
From: Luke M on 31 Mar 2010 12:44
For an exact check of placement data:
='Sheet 1'!A1 = 'Sheet 2'!A1

Copy down/across to BI3000. Any FALSE indicates a change.

However, since you have some added/deleted rows, you might be better to do a
quick check like:
=ISNUMBER(MATCH(A1,'Sheet 2'!A:A))

Which will check and see if A1 appears anywhere in column A of sheet 2. Hope
this gives you some ideas.

--
Best Regards,

Luke M
"Candida" <Candida(a)discussions.microsoft.com> wrote in message
news:C3612FB2-38F5-4E0F-B1F3-2C6D3CAAE310(a)microsoft.com...
>I have two work sheets that contain bill of material information of about
> 3000 component items required to build a system. There have been updates
> to
> the bill of material therefore, I need to compare the two worksheets and
> create a detailed list of changes or updates from the 3/9 bill of material
> to
> the 3/30 bill of material created. All of the columns headers are the same
> are the same for both worksheets, however there may be some added or
> subtracted rows or just additional information populated into the columns
> that were already in place such as Revision level in row 1 column F may
> have
> went from revision "A" to revision "B" or the qty may be different in
> Column
> H. Can someone help me to compose a formula to compare the two sheets. My
> columns are from A thru BI and my row numbers are from 1 to 3000. Please
> help.


 | 
Pages: 1
Prev: Forumal writing for imported sheets
Next: Missing sheet tabs and horizontal scroll bar