Consult everybody a great god, and how to implement the work of installation team name in the table menu number automatic averaging, and write in the "quarter ranking" in the corresponding cell, the data is, to the name of the
Record every month will change, how to automatically with the person's name?
Take a chestnut:
R T
The menu for installation team name
18 old ice
20 old ice
30 Zhu Zisheng
15 Zhu Zisheng
25 old ice
24 old ice

CodePudding user response:

Two haven't quarterly ranking in the table corresponding cell?
Suggested that the.xls files uploaded to the baidu network backup, and then sharing, to send the Shared address to here;

CodePudding user response:

Looking like using vlookup function can solve the problem, it is not necessary to use VBA

https://mp.weixin.qq.com/s/VU4051sBywmAXz3pi8lY5w