Forum Discussion

LandscapeDataNut's avatar
LandscapeDataNut
Copper Contributor
May 19, 2021
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...
excel
Formulas and Functions
LandscapeDataNut's avatar
LandscapeDataNut
Copper Contributor
May 19, 2021

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

LandscapeDataNut's avatar
LandscapeDataNut
Copper Contributor
May 19, 2021
Answering my own questions here. I had to expand the ROW() piece to include all the in-scope rows, and then grab all 5 formula cells and CTRL+Shift+Enter at once... This did it.

Also, I placed it into an INDEX() formula and works beautifully.

Thanks again!!

Resources