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
    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.
  • 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