Forum Discussion

JONLANE's avatar
JONLANE
Copper Contributor
May 04, 2022

Dynamic sub tables

Hi all, 

 

I am having a real issue making dynamic sub tables from a master table in excel. The formula is correctly picking up the correct number of rows from the master table into the sub table, but only the first line has the information. The remaining lines just have the NUM error. All help welcome. Thanks

excel
Excel on Mac
Formulas and Functions

1 Reply

  • mathetes's avatar
    mathetes
    Gold Contributor
    May 04, 2022
    A bit more information would help us help you. For example, what is the formula that delivers these results? What's the nature of the data in that "master table"? Those are some starter questions to get you going: a more complete picture of what you're dealing with would go a long way to enabling a diagnosis.

Resources