onthegreen03
Board Regular
- Joined
- Jun 30, 2016
- Messages
- 148
- Office Version
- 365
- Platform
- Windows
Hi. I posted earlier about this issue, thought I had it licked but alas did not. I pasted a picture below to help explain the issue I am having. I have a table with the top 5 and bottom 5 locations for a certain account. For the top 5 I am using a SMALL formula which looks at the specified range (using RANK formula) and returns 1 through 5, so no issues with that chart. The problem is the bottom 5 chart. When the parent account has more than 10 locations a LARGE formula will and does work. But when the total locations are between 6 and 9 some of the numbers repeat. In the example below I need to write a formula that looks at the range of numbers (in this case 1-8) and only return 6-8. If more information is needed to solve this let me know and I will include. This has stumped me all day. Thank you!