I have just recently learnt from this forum how to do a MAXIF function. But I have a twisted variation I would like to do. I will make up different data than what I am working on so it will be more interesting. So suppose I have the following-
Bob Smith 47
Mary Smith 32
Doug Smith 59
Mary Sullivan 19
Mike Jones 26
Katie Jones 22
John Doe 12
Jay Doe 16
Johnny Doe 8
Jill Doe 11
I want to determine the max age per family. So I know you can do MAX(IF(A2:A100="Bob Smith",B2:B100)) or the same except substiute a cell number (ex. E1 with the text Bob Smith), but is it possible to do MAX with a wildcard like MAX(IF(A2:A100="*Smith",B2:B100). When I try that and use CSE it returns zero.
Are there any Geniuses out there that can answer than one?
Thanks
Bob Smith 47
Mary Smith 32
Doug Smith 59
Mary Sullivan 19
Mike Jones 26
Katie Jones 22
John Doe 12
Jay Doe 16
Johnny Doe 8
Jill Doe 11
I want to determine the max age per family. So I know you can do MAX(IF(A2:A100="Bob Smith",B2:B100)) or the same except substiute a cell number (ex. E1 with the text Bob Smith), but is it possible to do MAX with a wildcard like MAX(IF(A2:A100="*Smith",B2:B100). When I try that and use CSE it returns zero.
Are there any Geniuses out there that can answer than one?
Thanks