| 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 |
| 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 | |||
Threaded Mode
