excel,函数,求在F,R,AD,AP,BB,BN,列中,最大值所在的列,请高手指教_百 ...答:假设数据从第一行开始,则公式如下,请向下复制:=IF(F1=MAX(F1,R1,AD1,AP1,BB1,BN1),"F",IF(R1=MAX(F1,R1,AD1,AP1,BB1,BN1),"R",IF(AD1=MAX(F1,R1,AD1,AP1,BB1,BN1),"AD",IF(AP1=MAX(F1,R1,AD1,AP1,BB1,BN1),"AP",IF(BB1=MAX(F1,R1,AD1,AP1,BB1,BN1),"BB"...