Forum Discussion

Annette_W's avatar
Annette_W
Copper Contributor
Dec 30, 2019
Solved

Excel Help: Showing and repeating data from one sheet to another

HI,  I have been trying to find a smart way to take a list of numbers and put them together with a storenumber.,  I have a list with maybe 8 numbers, that should show up again and again until all s...
excel
  • SergeiBaklan's avatar
    SergeiBaklan
    Dec 30, 2019

    Annette_W 

    If in first table you add total as count of elements

    in resulting table it could be

    =INDEX(Table1[No],MOD(ROW()-ROW(Table3[[#Headers],[Butik]])-1,Table1[[#Totals],[No]])+1)

    in E1, and

    =INDEX(Table2[Butik],INT((ROW()-ROW(Table3[[#Headers],[Butik]])-1)/Table1[[#Totals],[No]])+1)

    in F1, drag both down.

Annette_W's avatar
Annette_W
Copper Contributor
Dec 30, 2019
I finally understand the setup. sorry.
And it works perfectly. Thank you. 🙂

Resources