Like many ofyour users I am at best proficient in excel and realize my shortcomings when achallenge arrives on my desk. I hope my explanation is clear enough to warrantan answer so that I may receive some ideas and help. <o></o>
<o> </o>
I have beforeme 3 spreadsheets of data ranging in length up to 35,000 lines. They share somecommon data fields, ie E-codes (E1234567) and other fields that are unique tothe 3 different spreadsheets. <o></o>
<o> </o>
I am looking todevelop a tracker that will show if one E-code is present on one, two or allthree spreadsheets. Furthermore if it is possible to show the total number of E-codesin a summary that are only present on spreadsheet one, sheets one and two andfinally present on all 3. <o></o>
<o> </o>
I hope that isclear, and should you require further information please ask away<o></o>
<o> </o>
I am aware thisis a task but any advice would be greatly appreciated.<o></o>
<o> </o>
I have beforeme 3 spreadsheets of data ranging in length up to 35,000 lines. They share somecommon data fields, ie E-codes (E1234567) and other fields that are unique tothe 3 different spreadsheets. <o></o>
<o> </o>
I am looking todevelop a tracker that will show if one E-code is present on one, two or allthree spreadsheets. Furthermore if it is possible to show the total number of E-codesin a summary that are only present on spreadsheet one, sheets one and two andfinally present on all 3. <o></o>
<o> </o>
I hope that isclear, and should you require further information please ask away<o></o>
<o> </o>
I am aware thisis a task but any advice would be greatly appreciated.<o></o>