Converting Consumer Reports rating symbols to numbers

  • Thread starter Thread starter LookingForCode
  • Start date Start date
L

LookingForCode

I have downloaded Consumer Reports ratings symbols (5 symbols from Excellent
to Poor) and I would like to convert symbols to numbers. Tried "if"
statements but this does not recognize the "symbol" in the cell. Is there a
way to do this in VBA?
 
In the absence of seeing your workbook as requested, have a look in the help
index for VLOOKUP
 
Hi,

I Googled for these symbols so i could try and find a solution but no joy
where do I get them, what are they?

Mike
 
I can't seem to paste the symbols here. I did send an email to Dan Guillett
who was looking into it also. I haven't heard back from him yet. I would be
happy to send an email to you with the symbols too. If you are will
interested (which I would appreciate), please let me know your email address.
 
Don,

I did send an email yesterday to (e-mail address removed) with a copy of the
file. Actually our email account is (e-mail address removed) but my wife name shows
up (Elayne Kremer). I will look into the vlookup approach.

Thanks.
 
Back
Top