I have a list containing 'Name', 'ID' and 'Status' columns. In 'Status' column, I have three values "Pass","Fail","NA".
Now my requirement is, I want the 'Name' of students in a drop-down whose 'ID' lies between 15 to 20 and 'Status' is not "NA".
Any help will be much appreciated.