Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Tracking textual Data changes beween 2 columns & highlight diff nu
Hi there
OK I am tracking Students BTEC grades and am going round on circles The Data Range is the same in both columns A&B. This is arrayed order below Dist* Dist Merit Pass Fail Column A is students Targeted grade and column B is Students current Progress I want to compare the 2 and in column C want to add in a value to express the difference between their targeted and current grades (therefore showing how much the students are passing or failing their BTEC course) Some examples are as follows If A1 = Dist and B1 = Merit Then C1 should show -1 A1=Merit B2 = Fail C1 should show -2 A1 = Pass B1 = Dist C1 should show 2 C range would therefore be from 4 to -4 After I have done this I then want to add conditional formatting to column c but I can do this Please, please help many thanks Rameses |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Tracking textual Data changes beween 2 columns & highlight diff nu
Is it possible for you to show Dist* as High Dist instead. If so, in column
D, add in the following: D1 - High Dist D2 - Dist D3 - Merit D4 - Pass D5 - Fail In column C paste this =MATCH(A1,$D$1:$D$5,0)-MATCH(B1,$D$1:$D$5,0) Drag this down. See if this works for you. "Rameses" wrote: Hi there OK I am tracking Students BTEC grades and am going round on circles The Data Range is the same in both columns A&B. This is arrayed order below Dist* Dist Merit Pass Fail Column A is students Targeted grade and column B is Students current Progress I want to compare the 2 and in column C want to add in a value to express the difference between their targeted and current grades (therefore showing how much the students are passing or failing their BTEC course) Some examples are as follows If A1 = Dist and B1 = Merit Then C1 should show -1 A1=Merit B2 = Fail C1 should show -2 A1 = Pass B1 = Dist C1 should show 2 C range would therefore be from 4 to -4 After I have done this I then want to add conditional formatting to column c but I can do this Please, please help many thanks Rameses |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Tracking textual Data changes beween 2 columns & highlight diff nu | Excel Discussion (Misc queries) | |||
LOOKUP between two columns of diff. size | Excel Worksheet Functions | |||
Specify columns to add for months MTD Diff | Excel Worksheet Functions | |||
Specify MTD Diff by month's columns | Excel Worksheet Functions | |||
How do I change the color of the tracking in Highlight Changes? | Excel Discussion (Misc queries) |