palaeontology
Active Member
- Joined
- May 12, 2017
- Messages
- 444
- Office Version
- 2016
- Platform
- Windows
In the range D6:D300 I have a list of 5-digit student id numbers ... some cells in the range might be empty
In the range E6:E300 I have a list of student id numbers that have submitted a survey response ... some cells in the range might be empty
In the range F6:F300 I would like to return a list of those student id numbers that appear in D6:D300, but not in E6:E300 ... there won't be many id numbers returned in this list, so most of the cells should come back as looking empty
I have seen a few videos showing how to do this using the 'FILTER' function, but I don't seem to have that function (Excel 2016)
Is there a different way to achieve this ... I need the solution to be a formula .. I can't have it as a manual series of steps.
Kind regards,
Chris
In the range E6:E300 I have a list of student id numbers that have submitted a survey response ... some cells in the range might be empty
In the range F6:F300 I would like to return a list of those student id numbers that appear in D6:D300, but not in E6:E300 ... there won't be many id numbers returned in this list, so most of the cells should come back as looking empty
I have seen a few videos showing how to do this using the 'FILTER' function, but I don't seem to have that function (Excel 2016)
Is there a different way to achieve this ... I need the solution to be a formula .. I can't have it as a manual series of steps.
Kind regards,
Chris