Split() is a function that doesn’t get talked about a great deal, or at all as far as I am aware, however it can be extremely useful. In this video we’re going to look at how to user Split and Contatenate to drive a dropdown. Apols – I had intended to use distinct but I got out of the vid too quick. If you’d like to use that you would need to use the following formula.
source TDG/Data Spinners
Subscribe to Rory’s channel