Thank you for your suggestion. But how can I extract each category one by one e.g. A9-D11, A40-D42…, then identify the highest and the lowest. The row index of other categories in other excel sheet differ, so I cant assign robot to read the specific range.