How can I do a matching based on a plus or minus 1
(or whatever the number we chose to be)?
So something like "+/-1%"

Afraid I'm not quite sure what your'e after here.


Again thanks for the reply and help!

What I guess I was getting at is, say we had students whom we are
trying to match... we have matched their Sex, Age, Class, etc, but also
need to match their Average grade within a plus or minus X% range. How
can one write a formula to do so?

Here is an example:


.. Student ..... Age ...... Class ...... Sex ..... Average Mark%
==================================================
Bill Clinton ..... 26 ..... MATH101 .... M ......... 78.3%
Will Smith ...... 24 .... MATH101 .... M ......... 63.8%
Susan Lang .... 25 .... MATH101 .... F ......... 79.8%
John Lenon .... 26 .... MATH101 .... M ......... 77.9%

In this example, we'd have a match between "Clinton" and "Lenon" since
their categories ALL match... even though their "Average Mark%" isn't
an exact match, we could consider them 'statistically' close since
their marks are +/-1% of one another.

Many thanks in advance for considering this question.

Kindest regards,
Sab.


--
Sabotage1945
------------------------------------------------------------------------
Sabotage1945's Profile: http://www.excelforum.com/member.php...o&userid=14769
View this thread: http://www.excelforum.com/showthread...hreadid=536034