excel引用问题（提高效率）

cupidloveq

如图，单元格E3所用公式=OFFSET('SSA Level Data'!C$3,2,0,1,1)/OFFSET('SSA Level Data'!C$3,1,0,1,1)单元格E5 =OFFSET('SSA Level Data'!C$36,2,0,1,1)/OFFSET('SSA Level Data'!C$36,1,0,1,1)单元格E7 =OFFSET('SSA Level Data'!C$69,2,0,1,1)/OFFSET('SSA Level Data'!C$69,1,0,1,1)引用的单元格之间是有规律的，即C$(3+n*33) n=0,1,2,3,4,5,……问题：如何设置公式，可以一劳永逸的直接复制E3到E5，E7, E9……达到效果。不然得手动改，引用值，一共是有七八百号人的数据，所以太累， 有没有好的方法  求大神。

cupidloveq

file:///C:/Users/zhigangq/Desktop/1499756608(1).jpg

cupidloveq

file:///C:/Users/zhigangq/Desktop/1499756608(1).jpg

cupidloveq

MD 怎么上传不了图片

cupidloveq

	Colo  Team Trending Report			E	F	G	H	I
	Team	Assoicate	中文名	2017 Week 19	2017 Week 20	2017 Week 21	2017 Week 22	2017 Week 23
3	Chen,Shuo	caihongg	郭彩虹	1.09%	2.78%	1.06%	1.28%	0.00%
4		Goal		1.95%	3.07%	1.72%	5.68%	6.50%
5		chaoganz	赵朝刚	1.15%	1.83%	1.15%	1.53%	1.77%
6		Goal		2.01%	2.19%	1.52%	1.10%	1.42%
7		diwn	王帝	0.93%	1.37%	0.43%	0.77%	5.61%
8		Goal		0.81%	1.08%	1.02%	1.38%	5.22%
9		hangs	苏杭	0.00%	0.61%	1.53%	1.41%	2.11%
0		Goal		1.61%	1.06%	1.68%	1.34%	5.12%
		honzhan	张泓	0.70%	0.00%	0.00%	4.76%	1.71%
		Goal		1.07%	1.21%	1.09%	5.21%	2.13%
		jinyushi	石金玉	0.00%	0.00%	1.27%	14.29%	#DIV/0!
		Goal		1.40%	0.87%	1.15%	6.57%	#DIV/0!
		naguo	郭娜	0.64%	0.00%	0.52%	2.08%	0.92%
		Goal		1.06%	1.05%	1.23%	1.30%	2.00%
		xaoya	李晓阳	3.57%	2.41%	0.95%	4.60%	7.83%
		Goal		2.76%	1.83%	1.29%	4.00%	5.86%

梦幻小丑

E3所用公式=OFFSET('SSA Level Data'!C$3,2+int(row(a1)/2)*33,0,1,1)/OFFSET('SSA Level Data'!C$3,1int(row(a1)/2)*33,0,1,1)

cupidloveq

梦幻小丑 发表于 2017-7-12 11:24
E3所用公式=OFFSET('SSA Level Data'!C$3,2+int(row(a1)/2)*33,0,1,1)/OFFSET('SSA Level Data'!C$3,1int(r ...

谢谢大神 太厉害了