Forum Discussion

PerMorris's avatar
PerMorris
Copper Contributor
Jul 08, 2019

SOLVED! Find certain table within data sheet and the find last row in that table

Hi, I have a problem that I can't find the solution to. I have (as you can see in the picture bellow a data sheet with different tables. Each table is divided by 2 empty rows as you can see. There ar...
excel
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jul 08, 2019

PerMorris 

With INDEX/MATCH that could be

in H5

=INDEX($E:$E,MATCH(1,INDEX(--ISBLANK(INDEX($B:$B,MATCH($G5,$B:$B,0)):$B1000000),0),0)+MATCH($G5,$B:$B,0)-2)
  • PerMorris's avatar
    PerMorris
    Copper Contributor
    Jul 09, 2019
    Absolutely brilliant, you saved my day! Thanks a lot.

    /Per

Resources