Hello everyone,

I am currently working on a project with the following formula:
=IFERROR(SUM(SUMIF ('DataArk + Noter'!$D$13:$D$1204;{"BSH";"MI";"OHJ";"RVM";"TZ"};'DataArk + Noter'!Y14:Y1204))/HVIS(SUM(COUNTIFS('DataArk + Noter'!$D$13:$D$1204;{"BSH";"MI";"OH";"OHJ";"RVM";"TZ"}))="";"";SUM(COUNTIFS('DataArk + Noter'!$D$13:$D$1204;{"BSH";"MI";"OH";"OHJ";"RVM";"TZ"})));"Ingen Data")

The formula returns the average leadtime on a project based on initials of people.


My question is:
How can i create a macro that inserts all the initials of the people from a list of names with the corresponding initials. I want to make the formula dynamic, so if changes/addings in the list of initials, the Macro will insert the new initials

Any help is appreciated.

Thanks!