When I first heard of With function, I thought, “This is the LET function in Excel.” I love the LET function: it makes complex formulas easier to read & maintain; it can more efficient b/c it calculates the variable value once in the formula. I imagine the same would be true here? If our formula uses the same expression more than once in a formula (like, say, ListName.ColumnName.Value), then we can use With to calculate the value of that expression (once), store it in the variable, then feed the variable to the formula where that expression would be used. Good stuff! Thanks. Good explanation.
Hey Dave, thanks for the great video. I'm just watching that now, at the time that Excel is coming up with something very similar with the LET () function.
Thank you very much for the feedback David, much appreciated and it is great to know you found this useful. I wasn't aware of the Let function in Excel but will definitely check it out 👍🏆