Hey me again, on my sheet
People will enter a name and I want to be able to collate info for each name and give me the earliest date for each
I feel as if it’s going to be using IF but I can’t get it to work.
So on B2 I want to pull all the info from the main sheet IF it says lesley and give me the earliest date it shows on H2 of the main sheet. So the idea is it’s sort of an overview sheet of all the earliest dates for each person.
People will enter a name and I want to be able to collate info for each name and give me the earliest date for each
I feel as if it’s going to be using IF but I can’t get it to work.
So on B2 I want to pull all the info from the main sheet IF it says lesley and give me the earliest date it shows on H2 of the main sheet. So the idea is it’s sort of an overview sheet of all the earliest dates for each person.