excel - Match last value in column with blanks on multiple criteria

Question

asked Feb 19, 2021 in Technique[技术] by 深蓝 (71.8m points)

I have a table (T_Data) that - for the sake of this post - is structured similar to the following:

StoreID	DateStamp	Inventory	Sold
0000001	2020-12-26	10000	500
0000002	2020-12-26		100
0000001	2020-12-27		400
0000002	2020-12-27	5000	200
0000001	2020-12-28		400
0000002	2020-12-28		200
0000001	2020-12-29		400
0000002	2020-12-29		200
0000001	2020-12-30		400
0000002	2020-12-30		200

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…

1 Answer

深蓝 · Answer 1 · 2021-02-19T04:08:31+0000

answered Feb 19, 2021 by 深蓝 (71.8m points)

Use LOOKUP:

=LOOKUP(2,1/((T_Data[Inventory]<>"")*(T_Data[StoreID]=F4)),T_Data[Inventory])

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…