Forum Discussion

PBOBOP's avatar
PBOBOP
Icon for Helper I rankHelper I
2 years ago

Consecutive Test Dates with criteria

Hello,   I would like to create a table like the one below to showcase students' test dates and scores. However, I am having trouble incorporating certain criteria so that the correct date is refle...
Need Help
Tips and Tricks
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago
2. The latest test date and the second latest test date must be consecutive, the student should not have attempted any tests     between these dates.

What is your definition of "consecutive"?

 

Your sample data seems to indicate very different dates than your explanation?

  • PBOBOP's avatar
    PBOBOP
    Icon for Helper I rankHelper I
    2 years ago

    Hi Ibendlin, 

     

    My definition of consecutive means 2 tests in a row. I have added further explanation to my original post.