演示数据(load sample data)
......
add F
(
Second_to_last_value_from_table_with_condition:
微软社区-逆向查找最近第二期的数字 Second to last value from table with condition - Microsoft Community Hub) (
背景background
)
copy from Excel(video)
f01 f02 f03 4 1 £12 1 1 £4 2 1 £55 3 1 £1 4 1 £90 1 1 £19 2 1 £6 3 1 £101 4 1 £201 1 2 £99 2 2 £67 3 2 £2 4 2 £108 1 2 £120 2 2 £220 3 2 £47 4 2 £28