Forum Discussion

Mark_Pike's avatar
Mark_Pike
Copper Contributor
Jun 29, 2024

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 1

Manchester            Task 2

 

And so on

 

Is there a formula that can do this to save me having to copy and paste the tasks 185 times next to the tasks

Resources