Tracking textual Data changes beween 2 columns & highlight diff nu
in [General]
|
Prev: Tracking textual Data changes beween 2 columns & highlight diff nu
Next: Compile error in hidden module Excel 2007
From: Rameses on 3 Mar 2010 19:51 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
From: :) on 3 Mar 2010 20:27
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 > > |