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 |
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 |
All times are GMT +1. The time now is 03:57 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com