I am using windows xp and want to cross reference two excel spreadsheets and take out any duplicated data. How do i do this?

scenario: file ABC.xls has the number 5 in A1 (a closed file) file XYZ.xls has the number 10 in A1 (a closed file) file choose.xls (an open file) has EITHER...

Hello All, I am seeking advice on a formula to give me a count of work order types. I have already spent a few hours getting "close" but not close enough...

Seiko Dress Two-Tone Dark Grey Steel Black Mens Watch SKP310 Discount Watches Site : http://www.watchespurchase.com/ Seiko Dress Two-Tone Dark Grey Steel...

A B C ChoiceA ChoiceB Exp.Date X 11/2/08 X 12/4/08 ...

Is there an EXCEL 2007 formula that counts the number of times a cell (example "A1" only) changes color?

First, I apologize for the vague Subject, but I'm not sure what I need here.... I need to have a formula to look at two values and determine the result based...

is it possible to skip hidden rows to fill a series of numbers. If it is possible please tell me how? Thanks in advance.

I have been racking my brain to figure out why my formula is not working but now I see that when reviewing the results through the functional argument tool I...

I have a workbook with multiple sheets. I would like to link each sheet to a Summary sheet. The tricky part is that I would like to enter the formula one...

I have a large number of cells with date and time like this, "Jan 12, 2001 5:55 pm" I want to truncate the time in the cell and only make it display...

I am attempting to merge text from two different columns ie. C2 and D2 into one column. Once I have the data from the two columns in my new column, I would...

I have been using MSNStockQuotes on a few computers without any problems for months. Now (in the last day or so) , when I press "update Quotes" on any of the...

I'm currently designing a worksheet that contains all of our department tasks. Each task may have one of the following status: Open, On-going, For Review /...

I set A1="1978-9-22", B1="find("-",A1)" and return, but B1 shows #VALUE!, why? How can I resolve it? thanks in advance. A B ...

I have a large worksheet that has a product name and then in the next cell a sum, how do I sum only those equal to a specific product name. I have a list of...

I have two EXCEL 2000 workbooks( Estimates.xls and Prices.xls). Workbook 'Estimates.xls' has 1 worksheet with empty cells (C&D) that need populating if...

Excel 2007, SP1 on Vista I turned a rectangular region (with column headings) into a Table (for ease of adding new rows, etc) in a workbook - it's Table15 in...

I have a list of values in collum A and I wantto keep a running talle in another colulm B is there an easyier way to do this than putting the sum formular in...

Hi! I have one workbook with two sheets. Sheet one is used to define where our consultants are booked every day through the fiscal year. The sheet includes...