finding the highest number in a grid is easy using the MAX() statement but how do you find the 2nd and 3rd highest? This tutorial will show you how to use a little known function in Excel to return the 2nd and 3rd largest number.
If these goes on to show how to highlight these values quickly in a large grid of data (in the demo we are looking at 24 months of data from 30 products)
|
