| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comparing two columns of text values
I want to compare a current working grade against a target and show if it is
below, on, or above target. I have a vlookup table for the current grade but i need to compare this against the target grade and then show the progress. I would like to give the target grade a value but i am unsure if this is possible? Score 1 Score 2 Score 3 Total CURRENT TARGET Progress 7 8 10 8.3333 B A Below Any help would be greatly appreciated !!! -- REGARDS, A. MYATT |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Comparing two columns of text values
Hi,
Try this =IF(CODE(UPPER(E1))CODE(UPPER(F1)),"Below",IF(COD E(UPPER(E1))=CODE(UPPER(F1)),"On Target","Above")) Mike "MYATT" wrote: I want to compare a current working grade against a target and show if it is below, on, or above target. I have a vlookup table for the current grade but i need to compare this against the target grade and then show the progress. I would like to give the target grade a value but i am unsure if this is possible? Score 1 Score 2 Score 3 Total CURRENT TARGET Progress 7 8 10 8.3333 B A Below Any help would be greatly appreciated !!! -- REGARDS, A. MYATT |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Comparing two columns of text values
Actually, letters are treated the same as numbers. simply enter
=IF(F2<E2,"Below",if(F2E2,"Above","On")) "Mike H" wrote: Hi, Try this =IF(CODE(UPPER(E1))CODE(UPPER(F1)),"Below",IF(COD E(UPPER(E1))=CODE(UPPER(F1)),"On Target","Above")) Mike "MYATT" wrote: I want to compare a current working grade against a target and show if it is below, on, or above target. I have a vlookup table for the current grade but i need to compare this against the target grade and then show the progress. I would like to give the target grade a value but i am unsure if this is possible? Score 1 Score 2 Score 3 Total CURRENT TARGET Progress 7 8 10 8.3333 B A Below Any help would be greatly appreciated !!! -- REGARDS, A. MYATT |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| comparing text values in two columns | Excel Discussion (Misc queries) | |||
| Comparing values in two columns | Excel Discussion (Misc queries) | |||
| Comparing values in columns | Excel Worksheet Functions | |||
| comparing two columns of data to find common values | Excel Discussion (Misc queries) | |||
| Comparing values between columns only when there are values in bot | Excel Worksheet Functions | |||
Hybrid Mode
