compare and combine data

[brepsenkamp]

Hi all,

I am quite new here.
So sorry if my question is too simple.

I have the result of an exame in Sheet 1
Lets say:

Name Mark
John 6
Tom 5
Peter 4
Mary 7

In sheet 2 I have the result of a resit
Lets say:
Name Mark
John 8
Tom 3
Peter 6

Now I want to compare and combine these data in sheet 3, so that the best results will be displayed.

I will be appreciate your help

[Audiojoe]

Is everyone doing a re-sit? What I mean is, do you want to show two sets of results for each person in Sheet 3 and add them up, or simply show them next to each other so that you can compare them?

[Ivan F Moala]

Welkomstgroet voor naar de Raad

Assuming you have the Data set up in each sheet in the same locations eg John, Tom etc
are in the same locations then try

=MAX(Sheet1:Sheet2!B3)

[brepsenkamp]

No, the data is not exactly the same.
Not all students have to do the resit.

All the persons in sheet2 are also mentioned in sheet1, but not in the other way

[Aladin Akyurek]

On 2002-05-14 04:23, brepsenkamp wrote:
No, the data is not exactly the same.
Not all students have to do the resit.

All the persons in sheet2 are also mentioned in sheet1, but not in the other way

I suppose the third sheet has a complete list of canditates. If so, and you'd rather have the results in the third sheet, you'll need to look up in the first and in the second sheet to determine the desired result.

I'll assume, as example, that the data area in the first sheet is A2:B100 and in the second sheet A2:B40.

In B2 in the third sheet enter and copy down:

=MAX(IF(COUNTIF(Sheet1!A2:A100,A2),VLOOKUP(A2,Sheet1!A2:B100,2,0),0),IF(COUNTIF(Sheet2!A2:A40,A2),VLOOKUP(A2,Sheet1!A2:B 40,2,0),0))

A zero as result should mean that the candidate did not attend any exam.

Aladin