答案1
答案2
对于 Excel 365:
以下是使用的一种方式FILTER()
:
=XLOOKUP(FILTER(B:B,LEN(B:B)), {"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"}, {1,2,3,4,5,6,7,8,9,10,11,12})
笔记:
如果列中的数据乙是“溢出”的结果B2,那么你可以使用:
=XLOOKUP(B2#, {"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"}, {1,2,3,4,5,6,7,8,9,10,11,12})