Forum Discussion
I cant seem to figure out this formula
Im trying to get the average time between customer orders. I was thinking of using a combination of AVERAGE, DATEDIF and the next formula is where im struggling. I have tried XLOOKUP but this on...
You seem to be a person who likes to figure things out for yourself. So let me point you to
what are called the "dynamic array" functions. I think you'll find what you're looking for here. Start, maybe, with FILTER
By all means, though, come back here if you still come to a dead end. And perhaps post a copy of the worksheet you're using, so we don't have to re-create something ourselves.
i will check this out now, however I cant provide the actual worksheet as is has sesitive information on them.
Thanks for the info
Thanks for the info