Forum Discussion
Mark_Pike
Jun 29, 2024Copper Contributor
Excel formula help
Hi all - I have a list of 180 offices across the Uk and I have a list of 85 tasks that need to be assigned to to each office for example Office Task Manchester Task ...
OliverScheurich
Jun 29, 2024Gold Contributor
An alternative could be Power Query. In the attached file you can add data to the blue dynamic tables. Then you can click in any cell of the green table and right-click with the mouse and select refresh to update the green result table.