CJW_14
10-30-2018, 06:11 PM
Hi All,
I was wondering if someone could help me write some vba code for an analysis I need to perform (if its even possible)
I need to identify which unit ID’s share the same “role” and“value” data based on the “order” for each “form type”.
https://i.postimg.cc/mrHxD9mk/image-1.jpg
I was thinking the output could look something like the below with the org units that share the same data displayed in a comma separated list.
https://i.postimg.cc/8zx3q5TS/image-2.jpg
But if there’s an easier way id be more than happy to change the output. Id probably be looking at performing this function for 15’000 rows of data max.
I have attached an example file with 2 sheets with the data and the output.
Any help would be much appreciated.
I was wondering if someone could help me write some vba code for an analysis I need to perform (if its even possible)
I need to identify which unit ID’s share the same “role” and“value” data based on the “order” for each “form type”.
https://i.postimg.cc/mrHxD9mk/image-1.jpg
I was thinking the output could look something like the below with the org units that share the same data displayed in a comma separated list.
https://i.postimg.cc/8zx3q5TS/image-2.jpg
But if there’s an easier way id be more than happy to change the output. Id probably be looking at performing this function for 15’000 rows of data max.
I have attached an example file with 2 sheets with the data and the output.
Any help would be much appreciated.