I need Excel to do a MAX function, but only on a specified number of cells.
ie. I need it to MAX the cells adjoining cells that are sorted into groups
A,B,C or 1,2,3 seperately. This is what I have so far.
=IF(Q:Q=1,MAX(Y:Y),"") What am I doing wrong?