How to use EXCEL statistics, there are 67 participants in 67 projects, and each project has 10 participants. What events does everyone participate in?

You put your name in a column first, starting with A2. Then copy and paste selectively and transpose it into a line, starting with B 1

You can define rows as evaluators and columns as evaluators. Write the location where the evaluation operation takes place as 1, and leave the rest blank. For example, if Li Si is evaluated by Zhang San, he will find Li Si in the column, Zhang San in the row, write 1 at the intersection of the two, and the rest will be written in the same way. I'm sure you will divide it regularly, so it shouldn't be too much trouble.

Then B69 input:

= b 1 & amp； "Evaluation"&; “，”& ampIF(B2= 1，$A2，" " & amp“，”& ampIF(B3= 1，$A3，" " & amp“，”& ampIF(B4= 1，$A4，" " & amp“，”& ampIF(B5= 1，$A5，" " & amp“， ”& ampIF(B6= 1，$A6，" " & amp“，”& ampIF(B7= 1，$A7，" " & amp“，”& ampIF(B8= 1，$A8，" " & amp“，”& ampIF(B9= 1，$A9，" " & amp“， ”& ampIF(B 10= 1，$A 10，" ")& amp“，”& ampIF(B 1 1= 1，$A 1 1，" ")& amp“， ”& ampIF(B 12= 1，$A 12，" ")& amp“，”& ampIF(B 13= 1，$A 13，" ")& amp“，”& ampIF(B 14= 1， $A 14，" ")& amp“，”& ampIF(B 15= 1，$A 15，" ")& amp“，”& ampIF(B 16= 1，$A 16，" ")& amp“， ”& ampIF(B 17= 1，$A 17，" ")& amp“，”& ampIF(B 18= 1，$A 18，" ")& amp“，”& ampIF(B 19= 1， $A 19，" ")& amp“，”& ampIF(B20= 1，$A20，" ")& amp“，”& ampIF(B2 1= 1，$A2 1，" " & amp“，”& ampIF(B22= 1，$A22， " " & amp“，”& ampIF(B23= 1，$A23，" " & amp“，”& ampIF(B24= 1，$A24，" " & amp“，”& ampIF(B25= 1，$A25，" " & amp“， ”& ampIF(B26= 1，$A26，" " & amp“，”& ampIF(B27= 1，$A27，" " & amp“，”& ampIF(B28= 1，$A28，" " & amp“，”& ampIF(B29= 1，$A29， " " & amp“，”& ampIF(B30= 1，$A30，" " & amp“，”& ampIF(B3 1= 1，$A3 1，" " & amp“，”& ampIF(B32= 1，$A32，" " & amp“， ”& ampIF(B33= 1，$A33，" " & amp“，”& ampIF(B34= 1，$A34，" " & amp“，”& ampIF(B35= 1，$A35，" " & amp“，”& ampIF(B36= 1，$A36， " " & amp“，”& ampIF(B37= 1，$A37，" " & amp“，”& ampIF(B38= 1，$A38，" " & amp“，”& ampIF(B39= 1，$A39，" " & amp“， ”& ampIF(B40= 1，$A40，" " & amp“，”& ampIF(B4 1= 1，$A4 1，" " & amp“，”& ampIF(B42= 1，$A42，" " & amp“， ”& ampIF(B43= 1，$A43，" " & amp“，”& ampIF(B44= 1，$A44，" " & amp“，”& ampIF(B45= 1，$A45，" " & amp“，”& ampIF(B46= 1，$A46， " " & amp“，”& ampIF(B47= 1，$A47，" " & amp“，”& ampIF(B48= 1，$A48，" " & amp“，”& ampIF(B49= 1，$A49，" " & amp“， ”& ampIF(B50= 1，$A50，" " & amp“，”& ampIF(B5 1= 1，$A5 1，" ")& amp“，”& ampIF(B52= 1，$A52，" " & amp“， ”& ampIF(B53= 1，$A53，" " & amp“，”& ampIF(B54= 1，$A54，" " & amp“，”& ampIF(B55= 1，$A55，" " & amp“，”& ampIF(B56= 1，$A56， " " & amp“，”& ampIF(B57= 1，$A67，" " & amp“，”& ampIF(B58= 1，$A58，" " & amp“，”& ampIF(B59= 1，$A59，" " & amp“， ”& ampIF(B60= 1，$A60，" " & amp“，”& ampIF(B6 1= 1，$A6 1，" ")& amp“，”& ampIF(B62= 1，$A62，" " & amp“， ”& ampIF(B63= 1，$A63，" " & amp“，”& ampIF(B64= 1，$A64，" " & amp“，”& ampIF(B65= 1，$A65，" " & amp“，”& ampIF(B66= 1，$A66， " " & amp“，”& ampIF(B67= 1，$A67，" " & amp“，”& ampIF(B68= 1，$A68，"")

Then fill it out backwards.

Then copy line 69, create a new table, selectively paste it into values, and transpose it.

Then there may be some extra commas. Ctrl+F replaces .. (two English commas) with spaces. The results of my attempt are as follows:

Mu Decheng commented on Sun Zhenyuan, Zhang, Wang Hao, Xiao Weimin, Wu Guangfa, Guo Biqing and Yao Maojun.

Sun Zhenyuan, Zhang, Wang Hao, Xiao Weimin,,, Wu Guangfa, Guo Biqing, Yao Maojun, Jia Bin,

Comments were made on Zhang, Wang Hao, Xiao Weimin, Wu Guangfa, Guo Biqing, Yao Maojun, Jia Bin and Bao Wenzhong.

Zhang commented on Wang Hao, Xiao Weimin, Zhang Jing, Xu Fei, Wu Guangfa, Guo Biqing, Yao Maojun, Jia Bin, Bao Wenzhong, Zhan Guowei,

Wang Hao commented on Xiao Weimin, Zhang Jing, Xu Fei, Wu Guangfa, Guo Biqing, Yao Maojun, Jia Bin, Bao Wenzhong, Zhan Guowei and Chang Zhixin.

Xiao Weimin evaluated Zhang Jing, Xu Fei, Wu Guangfa, Guo Biqing, Yao Maojun, Jia Bin, Bao Wenzhong, Zhan Guowei, Chang Zhixin, joy chen,

Comments were made on, Wu Guangfa, Guo Biqing, Yao Maojun, Jia Bin, Bao Wenzhong, Zhan Guowei, Chang Zhixin, and Ning.

Comments on Wu Guangfa, Guo Biqing, Yao Maojun, Jia Bin, Bao Wenzhong, Zhan Guowei, Chang Zhixin, Ning, Yao,

Wu Guangfa commented on Guo Biqing, Yao Maojun, Jia Bin, Bao Wenzhong, Zhan Guowei, Chang Zhixin, Ning, Yao and Kang Xiudong.

Guo Biqing commented on Yao Maojun, Jia Bin, Bao Wenzhong, Zhan Guowei, Chang Zhixin, Ning, Yao, Kang Xiudong, Wei,

Yao Maojun commented on Jia Bin, Bao Wenzhong, Zhan Guowei, Chang Zhixin, Ning, Yao, Kang Xiudong, Wei and Bao Bangjin.

Jia Bin commented on Bao Wenzhong, Zhan Guowei, Chang Zhixin, Ning, Yao, Kang Xiudong, Wei, Bao Bangjin, Liu,

Bao Wenzhong commented on Zhan Guowei, Chang Zhixin, Ning, Yao, Kang Xiudong, Wei, Bao Bangjin, Liu and Ouyang Xiaohui.

Zhan Guowei commented on Chang Zhixin, Ning, Yao, Kang Xiudong, Wei, Bao Bangjin, Liu, Ouyang Xiaohui,

Chang Zhixin commented on, Ning, Yao, Kang Xiudong, Wei, Bao Bangjin, Liu and Ouyang Xiaohui.

Evaluation of Ning, Yao, Kang Xiudong, Wei, Bao Bangjin, Liu, Ouyang Xiaohui,, Dou Zhanjie,

Ning evaluated Yao, Kang Xiudong, Wei, Bao Bangjin, Liu, Ouyang Xiaohui,,, Dou and Wu Shaohua.

Yao comments on Kang Xiudong, Wei, Bao Bangjin, Liu, Ouyang Xiaohui,,, Dou,, Li Xiangping,

Kang Xiudong commented on Wei, Bao Bangjin, Liu, Ouyang Xiaohui,,, Dou,, and Zuo Zhonghua.

Wei evaluated Bao Bangjin, Liu, Ouyang Xiaohui,,, Dou,,, Zuo Zhonghua, Xu Guiyong,

Bao Bangjin's Comments on Liu, Ouyang Xiaohui,,, Dou,, Zuo Zhonghua, Xu Guiyong and Chen Hongsheng.

Liu commented on Ouyang Xiaohui,,, Dou,, Zuo Zhonghua, Xu Guiyong, etc.

Ouyang Xiaohui commented on,, Dou,, Zuo Zhonghua, Xu Guiyong, and Deng Yundong.

Comments were made on, Dou, Zuo Zhonghua, Xu Guiyong, Deng Yundong and Zhang Ren.

Dou,,, Zuo Zhonghua, Xu Guiyong,,, Deng Yundong, Zhang Ren and Tang were evaluated.

Dou evaluated,, Zuo Zhonghua, Xu Guiyong,,, Deng Yundong, Zhang Ren, Tang,,

Wu Shaohua commented on Zuo Zhonghua, Xu Guiyong, Deng Yundong, Zhang Ren, Tang, Guo Wei.

Zuo Zhonghua, Xu Guiyong, Chen Hongsheng, Liu Yuanlong, Deng Yundong, Zhang Ren, Tang, Guo Wei,

Zuo Zhonghua commented on Xu Guiyong, Liu Yuanlong, Deng Yundong, Zhang Ren, Tang, Guo Wei.

Xu Guiyong commented on, Liu Yuanlong, Deng Yundong, Zhang Ren, Tang, Guo Wei.

Evaluated, Deng Yundong, Zhang Ren, Tang, Guo Wei,,, and Wang Bo.

Comments were made on Deng Yundong, Zhang Ren, Tang, Guo Wei,,,, and Zhu Liang Kai.

Deng Yundong commented on Zhang Ren, Tang, Guo Wei,,,,, Zhu and Lei Zhengqi.

Zhang Ren commented on Tang, Guo Wei,,,, Zhu,, Lei Zhengqi,

Tang Comments, Guo Wei,,,,, Zhu, Lei Zhengqi, Wang Rui, Zhang Yuqiang.

Chen Hao commented on Guo Wei, Wang Tong, Ren Li, Ye Liu, Wang Bo, Zhu, Lei Zhengqi, Wang Rui, Zhang Yuqiang and Sun Chao.

Guo Wei commented on,,,, Zhu, Lei Zhengqi,,, Sun Chao and Li Qianhuo.

Wang Tong evaluated Ren Li, Ye Liu, Wang Bo, Zhu, Lei Zhengqi, Wang Rui, Zhang Yuqiang, Sun Chao, Li Qianhuo, Liu Guixia,

Comments were made on,, Zhu, Lei Zhengqi,,, Li Qianhuo and Wang Shuanghong.

Evaluated, Zhu, Lei Zhengqi,,, Li Qianhuo,, Wang Shuanghong, Wai-Man Chan,

Zhu, Lei Zhengqi, Li Qianhuo, Wang Shuanghong and Wang Jin were evaluated.

Zhu evaluated Lei Zhengqi, Li Qianhuo, Wang Shuanghong, Wang, Yan,

Lei Zhengqi commented on,, Sun Chao, Li Qianhuo, Wang Shuanghong, Wang, Yan and Tan Jialin.

Comments,, Li Qianhuo,, Wang Shuanghong,,, Yan, Tan Jialin, Nie Wenbiao,

Zhang Yuqiang made comments on comrades Li Shaohuo, Wang Shuanghong, Wang, Yan, Tan Jialin, Nie Wenbiao and Qi Binghuan.

Evaluation of Li Shaohuo, Wang Shuanghong, Wang, Yan, Tan Jialin, Nie Wenbiao, Qi Binghuan, Chai,

, Wang Shuanghong, Wang, Yan, Tan Jialin, Nie Wenbiao, Qi Binghuan, Chai, Su Lingyan.

Evaluation of Wang Shuanghong, Wang, Yan, Tan Jialin, Nie Wenbiao, Qi Binghuan, Chai, Su Lingyan, Liu Fengyan,

Wang Shuanghong commented on Wang, Yan, Tan Jialin, Nie Wenbiao, Qi Binghuan, Chai and Su Lingyan.

Evaluation of Wang, Yan, Tan Jialin, Nie Wenbiao, Qi Binghuan, Chai, Su Lingyan,,,

Wang made comments on Yan, Tan Jialin, Nie Wenbiao, Qi Binghuan, Chai, Su Lingyan,,, and Zhang Jin.

Yan Comments Tan Jialin, Nie Wenbiao, Qi Binghuan, Chai, Su Lingyan,,,, Zhang,, Jing Bin,

Tan Jialin comments on Nie Wenbiao, Qi Binghuan, Chai, Su Lingyan,,, Zhang, Jing Bin and Gan.

Nie Wenbiao commented on Qi Binghuan, Chai, Su Lingyan,,,, Zhang, Jing Bin, Gan, Mu, etc.

Qi Binghuan evaluated Chai, Su Lingyan, Li, Zhang, Jing Bin, Gan, Mu and Liu Lijuan.

Evaluate Su Lingyan,,,, Zhang, Jing Bin, Gan, Mu, Liu Lijuan, Chai Shiting,

Su Lingyan commented on,,, Zhang, Jing Bin, Gan, Mu, Chai Shiting and Han Wenwen.

Mu Qin, Zhang, Jing Bin, Gan, Mu, Chai Shiting and Han Wenwen were evaluated.

Mu Decheng, Sun Zhenyuan, Zhang, Jing Bin, Gan, Mu, Chai and Han Wenwen were evaluated.

Zhang commented on Mu Decheng, Sun Zhenyuan, Zhang Jingbin, Gan, Mu, Chai and Han Wenwen.

Jing Bin evaluated Mu Decheng, Sun Zhenyuan, Zhang, Wang Haogan, Mu, Chai.

Gan evaluated Mu Decheng, Sun Zhenyuan, Zhang, Wang Hao, Xiao Weimin, Mu, Chai He.

Mu evaluated Mu Decheng, Sun Zhenyuan, Zhang, Wang Hao, Xiao Weimin,, Chai He.

Mu Decheng, Sun Zhenyuan, Zhang, Wang Hao, Xiao Weimin,, Chai He were evaluated.

Chai evaluated Mu Decheng, Sun Zhenyuan, Zhang, Wang Hao, Xiao Weimin,,, Wu Guangfa.

Han Wenwen evaluated Mu Decheng, Sun Zhenyuan, Li Fudong, Zhang, Wang Hao, Xiao Weimin,,, Wu Guangfa, Guo Biqing,

Date of birth and death of the founding general

How to change Taobao account name

What countries are there in the northern hemisphere?

Zhang Jinru's resume

How many generals are there in Baoding Military Academy?

How to get into Gaozhou Teachers College in junior high school?

Biography of Gao Zhenyong

"Carefree Future" Hidden Resume Setting Tutorial

School profile, a foreign language affiliated to Wuhan University.

Brief introduction of Jimmy Lin's life. thank you