Hi Gary's Student,

Thanks for answering.

I've been thinking since I posted and what I need is to see if the values in
each column are exactly the same or if they are within 1 grade of each
other.. umm much more complicated but even more so because column B has some
split grades e.g D/E

I've got to repeat this through another 20 pair of columns so my temporary
fix of doing text to columns and using your formula to test both possible
values of ColB againt ColC is going to get tedious and looks very messy.

BTW who is Gary? MVP?

Thank you


--
TD


"Gary''s Student" wrote:

In D1 enter:

=IF(B1=C1,"they are the same","they are not the same") and copy down
--
Gary''s Student - gsnu200790


"TD" wrote:

Hi,

I would like to compare college grades but don't know how to start.

I have grades A-e in 2 columns B and C

Grades can be either e.g A or given as B/C.

Does anyone have any ideas how I could go about it

Many thanks
--
TD