Click the Merge & Heart selection as identified from the image above to merge cells A1 to D1 and Centre the title across these cells. =MAX(B2:C11) – Similarly, it finds the maximum range between column B from B2 and column C from C2 to row 11 in both of those https://excelnays.com/