I often am analyzing large chuncks of data that I need to not only find the min/max values but also need to look at the values before and after. The data often contains thousands of cells. Is there a way to have Excel show me the location of the min/max values? I know that I can conditionally format cells to highlight cells that are greater or less than a specific value, but with the amount of data in the worksheet, even with this highlighting, it can be quite cumbersome to locate the values I am looking for.
Any help would be appreciated.
Jon
Bookmarks