Forum Discussion

dreiness's avatar
dreiness
Copper Contributor
Mar 05, 2020

Help rewriting formula to increase by 10 cells

Hello,   I'd like help rewriting this formula so it will increase the reference cells by ten rather than one when I drag down.   =IFERROR(LOOKUP(2,1/(ISNUMBER('PATIENT TRACKING'!I4:I13)),'PATIENT...
excel
Formulas and Functions
office 365
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Mar 05, 2020

dreiness 

As variant

=IFERROR(
   LOOKUP(
      2,
      1/ISNUMBER(
         INDEX('PATIENT TRACKING'!$I:$I,4+10*(ROW()-ROW($A$1))):
         INDEX('PATIENT TRACKING'!$I:$I,13+10*(ROW()-ROW($A$1)))
        ),
      INDEX('PATIENT TRACKING'!$I:$I,4+10*(ROW()-ROW($A$1))):
      INDEX('PATIENT TRACKING'!$I:$I,13+10*(ROW()-ROW($A$1)))
   ),
"NO SCORE")

if start from row #1

  • dreiness's avatar
    dreiness
    Copper Contributor
    Mar 06, 2020
    Unfortunately this did not work, but it seemed close. It referenced the wrong data.

Resources