Comparing two sets of data

[LEEP2008]

how can i compare two sets of data showing the data in years and months?

[NBVC]

Where are these differences supposed to be gotten from? Some sample results?

[JBeaucaire]

Please indicate what exactly is being compared. I only see one Reading score for Leah West, so what you want is not clear.

This is a small data set. Enter the answers MANUALLY and then explain how you got those answers, then we'll show you how to automate that.

[LEEP2008]

sorry for the lack of info - i've tried to explain more in the spreadsheet. Thanks for having a look.

[NBVC]

In G5, copied down:

=INT(ABS((INT($D5)+MOD($D5,1)*10/12)-(INT(E5)+MOD(E5,1)*10/12)))+MOD(ABS((INT($D5)+MOD($D5,1)*10/12)-(INT(E5)+MOD(E5,1)*10/12)),1)*12/10

and then copied to column H... but for column H I get different values are you not using column D and F to calculate H?

[LEEP2008]

The reading differences work a treat. However when i try the same thing with spelling differences i also get different answers. I am using the column D and F to calculate H. which should tell me the answers in years and months. Thanks for you help so far.

[NBVC]

If you are using those 2 columns, then I think the results of the formula I gave copied over are correct...

Can you double-check manually what you should get and if the formula is still wrong please explain why?

[NBVC]

I looked at this again... and I see where I may have gone wrong...

... I am still not sure this is the best way... but this should get you closer: In G5,

=(INT(ABS((INT($D5)+MOD($D5,1)*10/12)-(INT(E5)+MOD(E5,1)*10/12)))&"."&ROUND((MOD(ABS((INT($D5)+MOD($D5,1)*10/12)-(INT(E5)+MOD(E5,1)*10/12)),1)*12),0))

copied down and over to next column...

There are still the 2nd and last for the Spelling that don't exactly match yours...