On Jan 13, 9:03*pm, The IC Teacher
wrote:
I have one of four chars displayed in any cell "f", "p", "m", "d", i wish to
convert "f" to 0 "p" to 1 "m" to 2 and "d" to 3 then compare to a second set
of cells.
The second set of cells value can also be "f", "p", "m", "d" which i need to
convert to the same set of numbers.
i will then use autoformat in a third cell to determine if the second set of
cells is higher in value than the first or lower in value

The Teacher

Hi Teacher,

I have small confusion on your question...

You mentioned that you are having one of four characters in in any
cell:

That means you will be having any character in each cell, Is tat
right.

Then you want to change those letter to values to compare the cell
values, is tat right..

I hope you doubt will this:

You want check both cell as having same result or not is tat correct,
if so:

Use match formula:

=MATCH(a1,b1,0)
If both having a same alphabet means answer will be 1, if not #N/A
Use the fill series and drag to next cells..

Thanks and Regards,

S. Praburam