我用EXCEL制作了一个统计教师成绩的表格，如何能让大家分享呢？让大家更快，更有效地访问使用我的表格呢？
答案:2 悬赏:60 手机版
解决时间 2021-02-07 21:02
- 提问者网友：呐年旧曙光
- 2021-02-07 09:34
上传至网络，我也知道，可是上传到哪一个网络比较好呢？
最佳答案
- 五星知识达人网友：酒醒三更
- 2021-02-07 10:41
把文件上传到网络上。当然得支持上传附件提供下载的网站
全部回答
- 1楼网友：春色三分
- 2021-02-07 11:18
看了你的求助，一是想不出好的方法。但你提示“急”，先介绍一个笨方法：
c4单元格公式:
=a4&if(a3=a4,"",a3)&if(a2=a4,"",if(a2=a3,"",a2))&if(a1=a4,"",if(a1=a3,"",if(a1=a2,"",a1)))
c5单元格公式:
=left(a5&if(a4=a5,"",a4)&if(a3=a5,"",if(a3=a4,"",a3))&if(a2=a5,"",if(a2=a4,"",if(a2=a3,"",a2)))&if(a1=a5,"",if(a1=a4,"",if(a1=a3,"",if(a1=a2,"",a1)))),4)
c6单元格公式:
=left(a6&if(a5=a6,"",a5)&if(a4=a6,"",if(a4=a5,"",a4))&if(a3=a6,"",if(a3=a5,"",if(a3=a4,"",a3)))&if(a2=a6,"",if(a2=a5,"",if(a2=a4,"",if(a2=a3,"",a2))))&if(a1=a6,"",if(a1=a5,"",if(a1=a4,"",if(a1=a3,"",if(a1=a1,"",a1))))),4)
将c6单元格公式拖下去，效果如图：
我要举报
如以上问答信息为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！
大家都在看
推荐资讯