Forum Discussion
Solved
Row Reference - Multiple Variables
Hello, I need to build a row reference based on two criteria. 1. Rows stating "New" 2. The #1, 2, 3, 4, 5 top invoices values, found in a second column. a. Note: I want the formula to b...
See the attached version.
Warning: you'll get incorrect results if there are ties among the top 5.
See the attached version.
Warning: you'll get incorrect results if there are ties among the top 5.
Thanks HansVogelaar !!
The first reference returns correctly, however, the first row position repeats on the following 4.
For note: I am building a dashboard in a separate sheet. That sheet holds this formula. Will that impact the approach?
Thanks again.
Ryan