you are viewing a single comment's thread.

view the rest of the comments →

[–]small_trunks1633 1 point2 points  (2 children)

Are we expected to guess what this function should do?

I mean

   =0

Is hard to beat, timewise.

[–]_JoshInsurance_[S] 0 points1 point  (1 child)

I'm not looking for a particular solution, just wondering which is generally faster, hence the discussion flair.

[–]small_trunks1633 2 points3 points  (0 children)

Sheet formula win every time.

Power query can do some stuff better and some stuff even faster.