How do you find a range and than the highest value in a range with excel?

To find a range in Excel, you simply select the cells you want to include. You can then use the MIN and MAX functions to identify the lowest and highest values within that range. For example, if your range is A1:A10, use =MIN(A1:A10) to find the lowest value and =MAX(A1:A10) to find the highest value. You can also use the SUBTOTAL function for ranges that might have filtered data.