With the greatest respect, and trying my very best to not sound like an arrogant jerk, if you need to have Calc’s lacklustre FILTER function, which often just spits out Error 533 into cells and which can’t quite figure out if it wants to be an array formula, further explained then I dare posit that you may not be a heavy spreadsheet user and therefore spending a large amount of time explaining it does rather reverse the burden of proof. For goodness sake, try and do anything serious with FILTER is Calc and you’ll very, very quickly see what I mean.
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments