a) city b) population
Cities are listed in column a multiple times.
I'm trying to get the Max in column B, if A equals Hollywood.
I would like "Hollywood) to be one of several constants shown at the bottom of the table.
I want, if a1:a5 = c11, then max b1:b5.
I'm obviously lost as can be.
Thanks in advance!
Cities are listed in column a multiple times.
I'm trying to get the Max in column B, if A equals Hollywood.
I would like "Hollywood) to be one of several constants shown at the bottom of the table.
I want, if a1:a5 = c11, then max b1:b5.
I'm obviously lost as can be.
Thanks in advance!