Dear Excel Guru's,
I once more seek your wisdom! I am having trouble finding the answer to my question on the excelguru forum, so I would like to apologize if there is already an answer to be found somewhere.
Please have a look at the attachment: it is a table with two columns: Name and Time. Name contains several similar names (Paul, John, etc..) and in the next column is the number of seconds they took to perform a task. What I want to have is for each name their best time filtered out and the other values hidden. Note that for each person are several times but not in an equal amount.
I hope my question is clear and I'm looking forward to your answer! Thanks for the help in advance
I once more seek your wisdom! I am having trouble finding the answer to my question on the excelguru forum, so I would like to apologize if there is already an answer to be found somewhere.
Please have a look at the attachment: it is a table with two columns: Name and Time. Name contains several similar names (Paul, John, etc..) and in the next column is the number of seconds they took to perform a task. What I want to have is for each name their best time filtered out and the other values hidden. Note that for each person are several times but not in an equal amount.
I hope my question is clear and I'm looking forward to your answer! Thanks for the help in advance