Typically I want to extract the latest balance (the last figure) from a table of summed data which is sorted in ascending date order. Up to now, I have used the Index function, as in
INDEX(Table16[Column5],COUNTA(Table16[Column5])
but I always find Index unintuitive, so thought of the new...