Question

还在吗 您回答的问题正好是相反的,我问反了,还承蒙您多多指教啊!

Answer 1

三列依次为：

=SUBSTITUTE(INDEX(A:A,2*(ROW()-1)+1,1),"盖","")

=MAX(($A$2:$A$100=$D2&"瓶")*$B$2:$B$100) 按CTRL+SHIFT+ENTER结束

=MAX(($A$2:$A$100=$D2&"盖")*$B$2:$B$100) 按CTRL+SHIFT+ENTER结束