How can I make a column of my data work properly


New Member
Aug 27, 2010
Hi Guys,

Within the document you will see three blue sections (classes) and then a multitude of other classes that are white.

This is the formula within Cell F4

=IF(NOT(ISNA(AA4)),AA4,INDEX(Termone!D$3:E$265, MATCH(D4, Termone!C$3:C$265, 0), MATCH(F$3, F$3:G$3, 0)))

There is a shadow sheet which is Term One results. Within this sheet are the students and classes where students have to resit classes when they get less than 40.

On the main sheet, the white area has the Term Three results and 'some' of the students have resat their exams.

If you play with the sheet you will see that when a new result is put in the term three column for that class, the term one cell is automatically updated and it turns white!

The problem is that I am only wanting students that have been mentioned on my shadow sheet to turn white when there is an update.. and instead I am getting students' cells turning white when they havent even attended term one..

I tried adding an (AND) statement to the formula to make sure they were on the shadow sheet too but it screwed up the whole formula.

SO I am turning to much more intelligent people for help :)

Thank you!

Forum statistics

Latest member

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...