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.
Also, I noticed that when I CRTL+Shift+Enter on your sample, all values flash and refresh. When I do it on mine, only the cell that's being edited flashes.