Hi all,

I'll try to give a clear explanation of what I'm trying to do, and then will copy my code.

I have a data set with multiple rows per item. I want to end with one row per item, in addition to some new columns which are essentially countifs of some of the original columns.

My data starts on a tab called "Data Set 1 Hidden" and I've copied this to sheet "Data Set 1" where I remove duplicates, after creating a strong unique identifier. Ultimately, I want to append the entries in my dictionary to my "Data Set 1" tab, so I end with one row per unique item, with additional columns at the end.

Formula: copy to clipboard 
Please Login or Register  to view this content.


I'm failing on the last bit where I update the New_Column for each item in the dictionary.

If anyone can see what I've done wrong, I'd really appreciate that!

Thanks