excel 公式请高手解答一下,在线等.谢谢~~~!!!!!!!

你这个条件有点多了，如果只用公式有点麻烦，可以考虑用vba来实现！！ Sub test() a = Cells(2, 1) b1 = Cells(2, 2) b2 = Cells(3, 2) b3 = Cells(4, 2) col = Cells(2, 256).End(xlToLeft).Column k = 0 For i = 3 To col If Cells(1, i) = a Or Cells(2, i) = "" Then Cells(3, i