[已解决]不通过过度区域繁琐计算利用函数直接得出正确结果？

jjxuexizy

请教高手如何不通过过度区域繁琐计 不通过过度区域繁琐计算利用函数直接得出正确结果？.zip (8.71 KB, 下载次数: 13)

2015-4-26 15:41 上传

点击文件名下载附件 算利用函数直接得出正确结果？  详见附件  谢谢

最佳答案

月排行榜 / 总排行榜

as0810114

2015-4-26 16:01

=MAX((B5:I5-TRANSPOSE(B5:I5)))
=MIN(IF(B5:I5<>TRANSPOSE(B5:I5),ABS(B5:I5-TRANSPOSE(B5:I5))))
=SUM(IF(FREQUENCY(ABS(B5:I5-TRANSPOSE(B5:I5)),ABS(B5:I5-TRANSPOSE(B5:I5))),1))-1

跳转到最佳答案楼层

as0810114

=MAX((B5:I5-TRANSPOSE(B5:I5)))
=MIN(IF(B5:I5<>TRANSPOSE(B5:I5),ABS(B5:I5-TRANSPOSE(B5:I5))))
=SUM(IF(FREQUENCY(ABS(B5:I5-TRANSPOSE(B5:I5)),ABS(B5:I5-TRANSPOSE(B5:I5))),1))-1