Hi,
I am preparing for an excel test (which will be 15 mins long). I have managed to find an example test and and I am currently stuck on one of the questions where it is asking me to return the name of the youngest employee within the dataset.
On one tab I have the questions and on the other tab is the raw data which list the fictitious employees name (column A), dob (column B), salary (column C), city (column D) and age (column E). I have already done the formula to calculate there age to populate column E but I am stuck on the above question.
I have tried using a Min or Max function within a vlookup but I keep getting an NA value.
The formula I have tried to used goes like this: =VLOOKUP("MIN 'Raw Data'!C4:C78",'Raw Data'!e4:G78,1,0)
If anyone knows the answer plus any other tips for a 15 minute excel test then that would be great.
Thanks
I am preparing for an excel test (which will be 15 mins long). I have managed to find an example test and and I am currently stuck on one of the questions where it is asking me to return the name of the youngest employee within the dataset.
On one tab I have the questions and on the other tab is the raw data which list the fictitious employees name (column A), dob (column B), salary (column C), city (column D) and age (column E). I have already done the formula to calculate there age to populate column E but I am stuck on the above question.
I have tried using a Min or Max function within a vlookup but I keep getting an NA value.
The formula I have tried to used goes like this: =VLOOKUP("MIN 'Raw Data'!C4:C78",'Raw Data'!e4:G78,1,0)
If anyone knows the answer plus any other tips for a 15 minute excel test then that would be great.
Thanks