Functions and Parameters

[@Luciano_mp]

Thank you.

[@mehdihammadi6145]

Thank you for sharing this was very informative

[@AccessAnalytic]

You're welcome Mehdi

[@mwaltercpa]

Very helpful, thank you

[@AccessAnalytic]

No problem

[@barttitulaerexcelbart9400]

Hello Wyn. Thank you. As somebody on Linked in said : this is still difficult. Hope Microsoft will add some kind of assistance using these parameters and functions. I made this Example in Power Query but with merging. It works as well. So there is actually no need to do use formulas in this example. After group by you have a table, you have to "convert" this to a list. That was the difficult part. But thanks for showing this video.

[@AccessAnalytic]

Hi Bart, yes it isn't intuitive yet. Glad you worked out a merge method, did you get that to work for excluding the multiple ingredients too?