I’m trying to get the following formula to work so that it builds a list and removes the blanks:
(
LIST(
ANY(Select(Pricelist[…,
ANY(Select(Pricelist[…,
ANY(Select(Pricelist[…,
ANY(Select(Pricelist[…
)
-LIST("")
)
But i keep getting this kind of output:
I’ve tried using Unique(), -LIST(""), -LIST(" ") and changing the list item formula to be
IF(ISBLANK(ANY(Select(Pricelist[…),ANY(Select(Pricelist[…,"")
Nothing works, I always eand up with a leading comma. Which is a PITA because what I’m trying to do is generate a list of figures, order them low to high, then pick the first item. But this does not work because I always have a leading comma
Anyone any ideas?
User | Count |
---|---|
41 | |
31 | |
31 | |
16 | |
14 |