I have 2 excel sheets with email addresses, many of the same email addresses appear on both sheets. i want to know which addresses are on sheet A but not on sheet B.

- Find differences between two Excel workbooks or worksheets
- Find differences between two Excel workbooks or worksheets
- How to find data in an Excel table
- How to find data in an Excel table
- How to find the highest 2 numbers from 3 columns
- Difference between 2 times in yyyy.mm.dd hh:mm
- How to divide an access database into 2 excel sheets by code
- How to find Asterick?
- How to set background on the Excel sheet
- How do I repeatedly find text in an Excel sheet?
- How to copy rows from one excel sheet to another in the same XLS file
- Look up for values between 2 excel sheets
- How to find a value in a sheet and return the column letter or number of the cell
- Excel 2003 - How to delete Custom Formating when Excel sheet is Lo
- Difference between two months
- How to make Unique coloumn in Excel sheet ?
- How to Find Maximum using 2 or more filters
- How to find and copy values on sheet 2, based on a list on sheet 1
- How to find and copy values on sheet 2, based on a list on sheet 1
- Can excel calc the difference between 2 dates removing weekends?
- Find difference between 2 times after filtering
- How to consolidate different Excel sheets?
- Return differences in 2 excel files to third excel file
- Compare 2 excel sheets

Often an Excel spreadsheet gets modified over time and you want to find

out what has changed.

Or you may import data into Excel worksheets and want to see how the

imported data has changed as well.

There is a neat little utility called DiffEngineX which produces

difference reports when run on two different Excel workbooks. It also

automatically copies the workbooks being compared and highlights the

different cells.

It has advanced options such as grouping equivalent changes together

such that one change to a range of cells is reported instead of tens of

separate changes.

If you want to download a free 30 day trial go to

http://www.florencesoft.com

Compare Excel Workbooks Files Diff Tool

--

savage_planet

Often an Excel spreadsheet gets modified over time and you want to find

out what has changed.

Or you may import data into Excel worksheets and want to see how the

imported data has changed as well.

There is a neat little utility called DiffEngineX which produces

difference reports when run on two different Excel workbooks. It also

automatically copies the workbooks being compared and highlights the

different cells.

It has advanced options such as grouping equivalent changes together

such that one change to a range of cells is reported instead of tens of

separate changes.

If you want to download a free 30 day trial go to

http://www.florencesoft.com

Compare Excel Workbooks Files Diff Tool

--

savage_planet

Functions LOOKUP() The LOOKUP function finds a value in a single row or column and matches it with a value in the same position in a different row or column.

... how to find data in a table (or range of cells) by using various built-in functions in ... Range_Lookup: A logical value (TRUE or FALSE). If TRUE or omitted, an approximate ...

a)What if the numbers are all the same?

e.g(80,80,80)

b)What if there is 2 lowest number ?

e.g(75,60,60)

c)What if there is 2 highest number?

e.g(90,90,50)

Thanks.

col A

2010.12.27 06:27

2010.12.27 08:45

2010.12.27 09:37

2010.12.27 10:33

col B

2010.12.27 08:10

2010.12.27 09:15

2010.12.27 10:29

2010.12.27 13:38

and i'm trying to subtract A from B but getting nowhere, i'm trying to get the answer in dd-hh:mm

i'm looking for the time elapsed.

thanks for any help anyone can give

I have an access database of around 90k records but I need to divide it into 2 excel sheets (still working in xl2003)

I did have limited success with CopyFromRecordset since it only allows for a maximum

I have done that by hand, but I am sure there must be a macro way to it

obviously I hardly know how to use access --

solution can be either a macro in Access or a macro in Excel, but I tried and I haven't managed to import data from the database even through the menus. The database has password and aparently some sort of problem since I miss an access module I think.

hints are welcome!

Bernat

Can anyone tell me how to set a background in the sheet of Ms Excel? I have

only Ms Excel 2003 and once I am able to do it accidentally. Now I forget it

and would like to do it again.

--

Vatana

again for text that is cleary there it doesn't respond.

I am having a problem to copy rows from one excel sheet to another in the same XLS file, based on the condition.

The base idea is that if the first column valus is 1 then that row is copy to "Sheet1" and if the value is 2 then that row will copy to "Sheet2".

Can any one can help on this....

thanks

arjun

I'm trying to find the correct formula for this, but no joy so far. Wondered if you guys can help?

Sheet1 shows a list of reference numbers in column A.

I want to look for the value that's Sheet1 cell A10 in sheet2 (one cell in range $11:$60) and I want to return in Sheet1 cell B10 the column letter or number where the value is found on Sheet2.

Any idea on how to achieve this? I have excel 2007 and excel 2010 installed.

Please let me know if you need more info.

many thanks in advance.

Kind regards,

A.

I don't know, if this is possible or not.

I want to delete Custom Formating when Excel sheet is Lock.

Go to Sheet 1 > Go to Format Cells, Custom and attempt to delete one of the

user created custom formats.

Try to execute above procedure when sheet is locked.

Thanks,

Suresh Kemnaik

in that particular column.

How to find the the above? Any one can help me out? Please....

in rows and columns). In column C the values are unique (actually Company

symbols).

On sheet 1, I want to enter a number of company symbols (ranging from one to

many)

And then I want to use a 'macro' (or equivalent) to:

- look at the list on Sheet 1

- go to Sheet 2

- Find the same values

- Highlight the entire row(s) and /or copy them

- Paste them to a third sheet

I do not know VBA very well, so any suggestions are very much aprreciated

I am using Excel 2003 (on my PC) and then migrating the result to Office

2004 for Mac.

in rows and columns). In column C the values are unique (actually Company

symbols).

On sheet 1, I want to enter a number of company symbols (ranging from one to

many)

And then I want to use a 'macro' (or equivalent) to:

- look at the list on Sheet 1

- go to Sheet 2

- Find the same values

- Highlight the entire row(s) and /or copy them

- Paste them to a third sheet

I do not know VBA very well, so any suggestions are very much aprreciated

I am using Excel 2003 (on my PC) and then migrating the result to Office

2004 for Mac.

between 2 dates and removing the weekends at the same time using a formula?

i applied a filter to a column of data then want to find the difference in time between 2 cells (one above the other). problem is, applying the filter messes up the cell references.

after applying the filter, i use this formula for time difference between the 2 cells

=MOD(TEXT(G300,"00:00")-TEXT(G299,"00:00"),1)*1440

with the filter however, what happens is the cell references become jumbled, like

=MOD(TEXT(G300,"00:00")-TEXT(G28,"00:00"),1)*1440

does anyone know how i can force the cell references to be relative, even if i change the filter? thanks in advance!

I recieve the file generally in a different order than what was previously sent so I always sort on the first column to begin the comparison. The files always have the same columns. The updated file may have added or deleted rows or just changes to some of the columns in a row.

I want to be able to select which columns to compare because there is information in some of the columns that I do not need to know if changes have occurred.

I would like to have the differences to be shown in a new excel file that would show the full row that a change has been made and would also like to have the new file highlite in a color or shading what the change was, i.e. the full row would be highlited if the row was added or deleted, or just the column that was changed in that row.

I have attached three files that show all of the columns that I need to compare and have includded two columns that I do not need to compare i.e. location and employee so that, if possible, these types of columns can be deselected in the compare operation. The three files show the original file, the updated or changed file and finnally the new file that has just the changes highlited with what the changes are.

Thank you.

What I am looking for is an automatic way to compare (not by sight).

thanks, Michael