onthegreen03
Board Regular
- Joined
- Jun 30, 2016
- Messages
- 148
- Office Version
- 365
- Platform
- Windows
Hi. I have a chart which returns the top 5 locations and a section for bottom 5 locations based on sales. For the bottom 5 I am using the MAX formula to return the 5 highest numbers in the list which is working great. I ran into a problem when a particular account does not have more than 5 locations. Is there a formula I can use that would tell the MAX formula to ignore the top 5 numbers (1 through 5)? So essentially it would only return a value when there are 6 or more locations, if 5 or less return blank. Thanks for the help!
EDIT: Sorry, I am using the LARGE formula to return highest 5 numbers (not MAX).
EDIT: Sorry, I am using the LARGE formula to return highest 5 numbers (not MAX).
Last edited by a moderator: