|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
d33=IF(IF(D$1="杀码",MOD(OFFSET(INDIRECT(D$7&"!A1"),MATCH($C33,INDIRECT(D$7&"!A1:A3000"),)-1,MATCH(D$9,INDIRECT(D$7&"!A1:cz1"),)-1)+IF(D$10="",,OFFSET(INDIRECT(D$7&"!A1"),MATCH($C33,INDIRECT(D$7&"!A1:A3000"),)-1,MATCH(D$10,INDIRECT(D$7&"!A1:cz1"),)-1)+IF(D$11="",,OFFSET(INDIRECT(D$7&"!A1"),MATCH($C33,INDIRECT(D$7&"!A1:A3000"),)-1,MATCH(D$11,INDIRECT(D$7&"!A1:cz1"),)-1)+IF(D$12="",,OFFSET(INDIRECT(D$7&"!A1"),MATCH($C33,INDIRECT(D$7&"!A1:A3000"),)-1,MATCH(D$12,INDIRECT(D$7&"!A1:cz1"),)-1)+IF(D$13="",,OFFSET(INDIRECT(D$7&"!A1"),MATCH($C33,INDIRECT(D$7&"!A1:A3000"),)-1,MATCH(D$13,INDIRECT(D$7&"!A1:cz1"),)-1)+IF(D$14="",,OFFSET(INDIRECT(D$7&"!A1"),MATCH($C33,INDIRECT(D$7&"!A1:A3000"),)-1,MATCH(D$14,INDIRECT(D$7&"!A1:cz1"),)-1)+IF(D$15="",,OFFSET(INDIRECT(D$7&"!A1"),MATCH($C33,INDIRECT(D$7&"!A1:A3000"),)-1,MATCH(D$15,INDIRECT(D$7&"!A1:cz1"),)-1)+IF(D$16="",,OFFSET(INDIRECT(D$7&"!A1"),MATCH($C33,INDIRECT(D$7&"!A1:A3000"),)-1,MATCH(D$16,INDIRECT(D$7&"!A1:cz1"),)-1)+IF(D$17="",,OFFSET(INDIRECT(D$7&"!A1"),MATCH($C33,INDIRECT(D$7&"!A1:A3000"),)-1,MATCH(D$17,INDIRECT(D$7&"!A1:cz1"),)-1)+IF(D$18="",,OFFSET(INDIRECT(D$7&"!A1"),MATCH($C33,INDIRECT(D$7&"!A1:A3000"),)-1,MATCH(D$18,INDIRECT(D$7&"!A1:cz1"),)-1)+IF(D$19="",,OFFSET(INDIRECT(D$7&"!A1"),MATCH($C33,INDIRECT(D$7&"!A1:A3000"),)-1,MATCH(D$19,INDIRECT(D$7&"!A1:cz1"),)-1)+IF(D$20="",,OFFSET(INDIRECT(D$7&"!A1"),MATCH($C33,INDIRECT(D$7&"!A1:A3000"),)-1,MATCH(D$20,INDIRECT(D$7&"!A1:cz1"),)-1)+IF(D$21="",,OFFSET(INDIRECT(D$7&"!A1"),MATCH($C33,INDIRECT(D$7&"!A1:A3000"),)-1,MATCH(D$21,INDIRECT(D$7&"!A1:cz1"),)-1)+IF(D$22="",,OFFSET(INDIRECT(D$7&"!A1"),MATCH($C33,INDIRECT(D$7&"!A1:A3000"),)-1,MATCH(D$22,INDIRECT(D$7&"!A1:cz1"),)-1)+IF(D$23="",,OFFSET(INDIRECT(D$7&"!A1"),MATCH($C33,INDIRECT(D$7&"!A1:A3000"),)-1,MATCH(D$23,INDIRECT(D$7&"!A1:cz1"),)-1)))))))))))))))+E$8,49),MOD(OFFSET(INDIRECT(D$7&"!A1"),MATCH($C33,INDIRECT(D$7&"!A1:A3000"),)-1,MATCH(D$9,INDIRECT(D$7&"!A1:cz1"),)-1)+IF(D$10="",,OFFSET(INDIRECT(D$7&"!A1"),MATCH($C33,INDIRECT(D$7&"!A1:A3000"),)-1,MATCH(D$10,INDIRECT(D$7&"!A1:cz1"),)-1)+IF(D$11="",,OFFSET(INDIRECT(D$7&"!A1"),MATCH($C33,INDIRECT(D$7&"!A1:A3000"),)-1,MATCH(D$11,INDIRECT(D$7&"!A1:cz1"),)-1)+IF(D$12="",,OFFSET(INDIRECT(D$7&"!A1"),MATCH($C33,INDIRECT(D$7&"!A1:A3000"),)-1,MATCH(D$12,INDIRECT(D$7&"!A1:cz1"),)-1)+IF(D$13="",,OFFSET(INDIRECT(D$7&"!A1"),MATCH($C33,INDIRECT(D$7&"!A1:A3000"),)-1,MATCH(D$13,INDIRECT(D$7&"!A1:cz1"),)-1)+IF(D$14="",,OFFSET(INDIRECT(D$7&"!A1"),MATCH($C33,INDIRECT(D$7&"!A1:A3000"),)-1,MATCH(D$14,INDIRECT(D$7&"!A1:cz1"),)-1)+IF(D$15="",,OFFSET(INDIRECT(D$7&"!A1"),MATCH($C33,INDIRECT(D$7&"!A1:A3000"),)-1,MATCH(D$15,INDIRECT(D$7&"!A1:cz1"),)-1)+IF(D$16="",,OFFSET(INDIRECT(D$7&"!A1"),MATCH($C33,INDIRECT(D$7&"!A1:A3000"),)-1,MATCH(D$16,INDIRECT(D$7&"!A1:cz1"),)-1)+IF(D$17="",,OFFSET(INDIRECT(D$7&"!A1"),MATCH($C33,INDIRECT(D$7&"!A1:A3000"),)-1,MATCH(D$17,INDIRECT(D$7&"!A1:cz1"),)-1)+IF(D$18="",,OFFSET(INDIRECT(D$7&"!A1"),MATCH($C33,INDIRECT(D$7&"!A1:A3000"),)-1,MATCH(D$18,INDIRECT(D$7&"!A1:cz1"),)-1)+IF(D$19="",,OFFSET(INDIRECT(D$7&"!A1"),MATCH($C33,INDIRECT(D$7&"!A1:A3000"),)-1,MATCH(D$19,INDIRECT(D$7&"!A1:cz1"),)-1)+IF(D$20="",,OFFSET(INDIRECT(D$7&"!A1"),MATCH($C33,INDIRECT(D$7&"!A1:A3000"),)-1,MATCH(D$20,INDIRECT(D$7&"!A1:cz1"),)-1)+IF(D$21="",,OFFSET(INDIRECT(D$7&"!A1"),MATCH($C33,INDIRECT(D$7&"!A1:A3000"),)-1,MATCH(D$21,INDIRECT(D$7&"!A1:cz1"),)-1)+IF(D$22="",,OFFSET(INDIRECT(D$7&"!A1"),MATCH($C33,INDIRECT(D$7&"!A1:A3000"),)-1,MATCH(D$22,INDIRECT(D$7&"!A1:cz1"),)-1)+IF(D$23="",,OFFSET(INDIRECT(D$7&"!A1"),MATCH($C33,INDIRECT(D$7&"!A1:A3000"),)-1,MATCH(D$23,INDIRECT(D$7&"!A1:cz1"),)-1)))))))))))))))+E$8,12))=0,"49",IF(D$1="杀码",MOD(OFFSET(INDIRECT(D$7&"!A1"),MATCH($C33,INDIRECT(D$7&"!A1:A3000"),)-1,MATCH(D$9,INDIRECT(D$7&"!A1:cz1"),)-1)+IF(D$10="",,OFFSET(INDIRECT(D$7&"!A1"),MATCH($C33,INDIRECT(D$7&"!A1:A3000"),)-1,MATCH(D$10,INDIRECT(D$7&"!A1:cz1"),)-1)+IF(D$11="",,OFFSET(INDIRECT(D$7&"!A1"),MATCH($C33,INDIRECT(D$7&"!A1:A3000"),)-1,MATCH(D$11,INDIRECT(D$7&"!A1:cz1"),)-1)+IF(D$12="",,OFFSET(INDIRECT(D$7&"!A1"),MATCH($C33,INDIRECT(D$7&"!A1:A3000"),)-1,MATCH(D$12,INDIRECT(D$7&"!A1:cz1"),)-1)+IF(D$13="",,OFFSET(INDIRECT(D$7&"!A1"),MATCH($C33,INDIRECT(D$7&"!A1:A3000"),)-1,MATCH(D$13,INDIRECT(D$7&"!A1:cz1"),)-1)+IF(D$14="",,OFFSET(INDIRECT(D$7&"!A1"),MATCH($C33,INDIRECT(D$7&"!A1:A3000"),)-1,MATCH(D$14,INDIRECT(D$7&"!A1:cz1"),)-1)+IF(D$15="",,OFFSET(INDIRECT(D$7&"!A1"),MATCH($C33,INDIRECT(D$7&"!A1:A3000"),)-1,MATCH(D$15,INDIRECT(D$7&"!A1:cz1"),)-1)+IF(D$16="",,OFFSET(INDIRECT(D$7&"!A1"),MATCH($C33,INDIRECT(D$7&"!A1:A3000"),)-1,MATCH(D$16,INDIRECT(D$7&"!A1:cz1"),)-1)+IF(D$17="",,OFFSET(INDIRECT(D$7&"!A1"),MATCH($C33,INDIRECT(D$7&"!A1:A3000"),)-1,MATCH(D$17,INDIRECT(D$7&"!A1:cz1"),)-1)+IF(D$18="",,OFFSET(INDIRECT(D$7&"!A1"),MATCH($C33,INDIRECT(D$7&"!A1:A3000"),)-1,MATCH(D$18,INDIRECT(D$7&"!A1:cz1"),)-1)+IF(D$19="",,OFFSET(INDIRECT(D$7&"!A1"),MATCH($C33,INDIRECT(D$7&"!A1:A3000"),)-1,MATCH(D$19,INDIRECT(D$7&"!A1:cz1"),)-1)+IF(D$20="",,OFFSET(INDIRECT(D$7&"!A1"),MATCH($C33,INDIRECT(D$7&"!A1:A3000"),)-1,MATCH(D$20,INDIRECT(D$7&"!A1:cz1"),)-1)+IF(D$21="",,OFFSET(INDIRECT(D$7&"!A1"),MATCH($C33,INDIRECT(D$7&"!A1:A3000"),)-1,MATCH(D$21,INDIRECT(D$7&"!A1:cz1"),)-1)+IF(D$22="",,OFFSET(INDIRECT(D$7&"!A1"),MATCH($C33,INDIRECT(D$7&"!A1:A3000"),)-1,MATCH(D$22,INDIRECT(D$7&"!A1:cz1"),)-1)+IF(D$23="",,OFFSET(INDIRECT(D$7&"!A1"),MATCH($C33,INDIRECT(D$7&"!A1:A3000"),)-1,MATCH(D$23,INDIRECT(D$7&"!A1:cz1"),)-1)))))))))))))))+E$8,49),MOD(OFFSET(INDIRECT(D$7&"!A1"),MATCH($C33,INDIRECT(D$7&"!A1:A3000"),)-1,MATCH(D$9,INDIRECT(D$7&"!A1:cz1"),)-1)+IF(D$10="",,OFFSET(INDIRECT(D$7&"!A1"),MATCH($C33,INDIRECT(D$7&"!A1:A3000"),)-1,MATCH(D$10,INDIRECT(D$7&"!A1:cz1"),)-1)+IF(D$11="",,OFFSET(INDIRECT(D$7&"!A1"),MATCH($C33,INDIRECT(D$7&"!A1:A3000"),)-1,MATCH(D$11,INDIRECT(D$7&"!A1:cz1"),)-1)+IF(D$12="",,OFFSET(INDIRECT(D$7&"!A1"),MATCH($C33,INDIRECT(D$7&"!A1:A3000"),)-1,MATCH(D$12,INDIRECT(D$7&"!A1:cz1"),)-1)+IF(D$13="",,OFFSET(INDIRECT(D$7&"!A1"),MATCH($C33,INDIRECT(D$7&"!A1:A3000"),)-1,MATCH(D$13,INDIRECT(D$7&"!A1:cz1"),)-1)+IF(D$14="",,OFFSET(INDIRECT(D$7&"!A1"),MATCH($C33,INDIRECT(D$7&"!A1:A3000"),)-1,MATCH(D$14,INDIRECT(D$7&"!A1:cz1"),)-1)+IF(D$15="",,OFFSET(INDIRECT(D$7&"!A1"),MATCH($C33,INDIRECT(D$7&"!A1:A3000"),)-1,MATCH(D$15,INDIRECT(D$7&"!A1:cz1"),)-1)+IF(D$16="",,OFFSET(INDIRECT(D$7&"!A1"),MATCH($C33,INDIRECT(D$7&"!A1:A3000"),)-1,MATCH(D$16,INDIRECT(D$7&"!A1:cz1"),)-1)+IF(D$17="",,OFFSET(INDIRECT(D$7&"!A1"),MATCH($C33,INDIRECT(D$7&"!A1:A3000"),)-1,MATCH(D$17,INDIRECT(D$7&"!A1:cz1"),)-1)+IF(D$18="",,OFFSET(INDIRECT(D$7&"!A1"),MATCH($C33,INDIRECT(D$7&"!A1:A3000"),)-1,MATCH(D$18,INDIRECT(D$7&"!A1:cz1"),)-1)+IF(D$19="",,OFFSET(INDIRECT(D$7&"!A1"),MATCH($C33,INDIRECT(D$7&"!A1:A3000"),)-1,MATCH(D$19,INDIRECT(D$7&"!A1:cz1"),)-1)+IF(D$20="",,OFFSET(INDIRECT(D$7&"!A1"),MATCH($C33,INDIRECT(D$7&"!A1:A3000"),)-1,MATCH(D$20,INDIRECT(D$7&"!A1:cz1"),)-1)+IF(D$21="",,OFFSET(INDIRECT(D$7&"!A1"),MATCH($C33,INDIRECT(D$7&"!A1:A3000"),)-1,MATCH(D$21,INDIRECT(D$7&"!A1:cz1"),)-1)+IF(D$22="",,OFFSET(INDIRECT(D$7&"!A1"),MATCH($C33,INDIRECT(D$7&"!A1:A3000"),)-1,MATCH(D$22,INDIRECT(D$7&"!A1:cz1"),)-1)+IF(D$23="",,OFFSET(INDIRECT(D$7&"!A1"),MATCH($C33,INDIRECT(D$7&"!A1:A3000"),)-1,MATCH(D$23,INDIRECT(D$7&"!A1:cz1"),)-1)))))))))))))))+E$8,12)))
[ 本帖最后由 xw8858 于 2010-8-12 10:40 编辑 ] |
|