Comparing worksheets

Resolved · High Priority · Version 2016

Wed 20 Nov 2019, 17:12 Delegate Nelson said...

Nelson has attended:
Excel Intermediate course

Comparing worksheets

How can i compare two versions of a worksheet to identify changes between them.

Wed 20 Nov 2019, 19:55 Trainer Jens said...

RE: Comparing worksheets

Hi Nelson,

Thank you for the forum question.

Unfortunately there is no "magical" tools in Excel which can do this.

I found a video on Youtube with some ideas which may be useful

https://www.youtube.com/watch?time_continue=233& ;v=DyEDODl3e2U&feature=emb_logo

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Wed 27 Nov 2019: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Calculate age or service

The DATEDIF() function in Excel calculates the number of days, months, or years between two dates. So, this function makes it easy to calculate a person's age. To try this tip:

In a blank worksheet, type the birth date in cell A1, using slashes to separate day, month, and year.
In cell A2, type =DATEDIF(A1,TODAY(),"y") and press ENTER.

View all Excel hints and tips