Im looking for a formula to give me the top 3 values in a a data column. I would prefer to do this under conditional formatting, any suggestions? I know how to get the max value, it is the 2nd and third values I am lost upon.
Im looking for a formula to give me the top 3 values in a a data column. I would prefer to do this under conditional formatting, any suggestions? I know how to get the max value, it is the 2nd and third values I am lost upon.
Try the following:
Using LARGE function:
=LARGE(A$1:A$20,ROW($A1)) - this is considering the data range is from A1:A20
drag this down the cells.
OR,
Using conditional formatting:
- Select the Data Range
- Conditional Formatting
- New Rule
- Format only Top or Bottom Ranked Values
- Top - 3
- Color it based on your requirement
See the image below:
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks