Returning a Value Label if Difference Between Numbers is >10

[Darko_Giac]

Hi all,

I'm not sure if this is the right forum to post this question in, but I'll give it a shot.

I'm working with a fairly small dataset, (student performance across 10 different topics/subjects), and am trying to find a way to return a value label of "yes" or "no" if the difference between any two scores is greater than 10.

I'm essentially looking find whether there is a notable or significant variation across scores.

I've attached a workbook that includes the desired result and further notes for clarification.

Any suggestions are greatly appreciated. Thanks in advance!

Darko

[bebo021999]

C2:

Please Login or Register  to view this content.

Copy to G2

[Darko_Giac]

C2:

Please Login or Register  to view this content.

Copy to G2

Thanks! Worked like a charm!