They want me to locate the 8-digit Pserial number for the oldest current smoker in the poll using my Excel database. If cigst is 4, the person smokes. Column 3 has the serial numbers, while column N lists the smokers. Column for age
This is the database, but the database also contains additional information:
I think the functions to use are INDEX, MAX and IF, but not sure on what order to use.