Create a column based on numbers

New Contributor

Image shows Column ID and N which summarized fifth column ID in my case i need to construct column E using the values presented in ID, N, is there a formula there?

Captura de excel.png




Thank you

4 Replies


You can try Power Query. In the attached file you can add ID and N in the blue dynamic table. Then you can click in any cell of the green table and right-click with the mouse and select refresh in order to update the green result table.

repeat ID.JPG

best response confirmed by saintlouis25 (New Contributor)

@saintlouis25  Option using dynamic sheet array functions:

Nice im gonna check it right now. Thank you so much
Thank you very nice attractive answer o couldnt imagine this solution. Let me see.