u/Sad-View3025

I'm trying to turn a google sheet in to an excel sheet and one of the functions the sheet uses is stumping me.

=sort(unique(trim(tocol(iferror(split(Log!J33:J,",")),1))))

This is the function that is used in the sheet to sort a column where each cell contains multiple things separated by a comma. It places each item separated by a comma into it's own cell and sorts them alphabetically. It ignores any spaces there might be and simply grabs the text between the commas.

I've tried simply looking it up to see if someone else had asked in the past but I would not know how to explain exactly what I'm trying to do. I barely use excel and seem to have 0 ability to understand how more complex functions like this even work.

I'm using office 2024

I have a template of a log that was made by someone else in google sheets. I however am bias to Microsoft software that isn't dependant on a wifi connection and would much prefer to have the same log in excel. I tried to simply export it but the function that were used in google sheets arent formatted the same in excel and everything simply errors.

I don't use excel so I have no idea how to translate the way that the functions are written in google sheets to how they should be written in excel.

Update: I did myself a favor and updated to excel 2024. As well as completely starting from scratch. I'm getting really stuck on a SUMIF function to specifically sum up the wordcount per month. In Sheets it's written as =sumif(ArrayFormula(month(Log!A:A)),1,Log!H:H)
to sum up January. The A column being the dates and the H column containing the word count.

What criteria do I use in excel for it to sum up one specific month?