Aşağıdaki formülü makroyla nasıl yapılır.
=EÃER($C$9="";"";EÃER(VE($AE$8="İ";AD9>=$D$9;AD9<$E$9);("İ");EÃER(VE($AE$8="İ";AD9>=$D$10;AD9<$E$10);("İ");EÃER(VE($AE$8="İ";AD9>=$D$11;AD9<$E$11);("İ");EÃER(VE($AE$8="İ";AD9>=$D$12;AD9<$E$12);("İ");EÃER(VE($AE$8="İ";AD9>=$D$13;AD9<$E$13);("İ");EÃER(VE($AE$8="İ";AD9>=$D$14;AD9<$E$14);("İ");"")))))))&EÃER(VE($AE$8="İ";AD9>=$D$15;AD9<$E$15);("İ");EÃER(VE($AE$8="İ";AD9>=$D$16;AD9<$E$16);("İ");EÃER(VE($AE$8="İ";AD9>=$D$17;AD9<$E$17);("İ");EÃER(VE($AE$8="İ";AD9>=$D$18;AD9<$E$18);("İ");EÃER(VE($AE$8="İ";AD9>=$D$19;AD9<$E$19);("İ");EÃER(VE($AE$8="İ";AD9>=$D$20;AD9<$E$20);("İ");EÃER(VE($AE$8="İ";AD9>=$D$21;AD9<$E$21);("İ");"")))))))&EÃER(VE($AE$8="İ";AD9>=$D$22;AD9<$E$22);("İ");EÃER(VE($AE$8="İ";AD9>=$D$23;AD9<$E$23);("İ");EÃER(VE($AE$8="İ";AD9>=$D$24;AD9<$E$24);("İ");EÃER(VE($AE$8="İ";AD9>=$D$25;AD9<$E$25);("İ");EÃER(VE($AE$8="İ";AD9>=$D$26;AD9<$E$26);("İ");EÃER(VE($AE$8="İ";AD9>=$D$27;AD9<$E$27);("İ");("")))))))
=EÃER($C$9="";"";EÃER(VE($AE$8="İ";AD9>=$D$9;AD9<$E$9);("İ");EÃER(VE($AE$8="İ";AD9>=$D$10;AD9<$E$10);("İ");EÃER(VE($AE$8="İ";AD9>=$D$11;AD9<$E$11);("İ");EÃER(VE($AE$8="İ";AD9>=$D$12;AD9<$E$12);("İ");EÃER(VE($AE$8="İ";AD9>=$D$13;AD9<$E$13);("İ");EÃER(VE($AE$8="İ";AD9>=$D$14;AD9<$E$14);("İ");"")))))))&EÃER(VE($AE$8="İ";AD9>=$D$15;AD9<$E$15);("İ");EÃER(VE($AE$8="İ";AD9>=$D$16;AD9<$E$16);("İ");EÃER(VE($AE$8="İ";AD9>=$D$17;AD9<$E$17);("İ");EÃER(VE($AE$8="İ";AD9>=$D$18;AD9<$E$18);("İ");EÃER(VE($AE$8="İ";AD9>=$D$19;AD9<$E$19);("İ");EÃER(VE($AE$8="İ";AD9>=$D$20;AD9<$E$20);("İ");EÃER(VE($AE$8="İ";AD9>=$D$21;AD9<$E$21);("İ");"")))))))&EÃER(VE($AE$8="İ";AD9>=$D$22;AD9<$E$22);("İ");EÃER(VE($AE$8="İ";AD9>=$D$23;AD9<$E$23);("İ");EÃER(VE($AE$8="İ";AD9>=$D$24;AD9<$E$24);("İ");EÃER(VE($AE$8="İ";AD9>=$D$25;AD9<$E$25);("İ");EÃER(VE($AE$8="İ";AD9>=$D$26;AD9<$E$26);("İ");EÃER(VE($AE$8="İ";AD9>=$D$27;AD9<$E$27);("İ");("")))))))