Advertisement
Guest User

Untitled

a guest
Jul 21st, 2017
58
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 14.27 KB | None | 0 0
  1. =CONCATENATE(
  2. IF(
  3. EXACT(
  4. E5,
  5. "✔"
  6. ),
  7. CONCATENATE(
  8. INDIRECT(
  9. ADDRESS(
  10. 3,
  11. COLUMN(
  12. E5
  13. )
  14. )
  15. ),
  16. ". ",
  17. VLOOKUP(
  18. INDIRECT(
  19. ADDRESS(
  20. 3,
  21. COLUMN(
  22. E5
  23. )
  24. )
  25. ),
  26. 採点表!$A$2:$E$22,
  27. 2,
  28. FALSE
  29. ),
  30. CHAR(
  31. 10
  32. )
  33. ),
  34. ""
  35. ),
  36. IF(
  37. EXACT(
  38. F5,
  39. "✔"
  40. ),
  41. CONCATENATE(
  42. INDIRECT(
  43. ADDRESS(
  44. 3,
  45. COLUMN(
  46. F5
  47. )
  48. )
  49. ),
  50. ". ",
  51. VLOOKUP(
  52. INDIRECT(
  53. ADDRESS(
  54. 3,
  55. COLUMN(
  56. F5
  57. )
  58. )
  59. ),
  60. 採点表!$A$2:$E$22,
  61. 2,
  62. FALSE
  63. ),
  64. CHAR(
  65. 10
  66. )
  67. ),
  68. ""
  69. ),
  70. IF(
  71. EXACT(
  72. G5,
  73. "✔"
  74. ),
  75. CONCATENATE(
  76. INDIRECT(
  77. ADDRESS(
  78. 3,
  79. COLUMN(
  80. G5
  81. )
  82. )
  83. ),
  84. ". ",
  85. VLOOKUP(
  86. INDIRECT(
  87. ADDRESS(
  88. 3,
  89. COLUMN(
  90. G5
  91. )
  92. )
  93. ),
  94. 採点表!$A$2:$E$22,
  95. 2,
  96. FALSE
  97. ),
  98. CHAR(
  99. 10
  100. )
  101. ),
  102. ""
  103. ),
  104. IF(
  105. EXACT(
  106. H5,
  107. "✔"
  108. ),
  109. CONCATENATE(
  110. INDIRECT(
  111. ADDRESS(
  112. 3,
  113. COLUMN(
  114. H5
  115. )
  116. )
  117. ),
  118. ". ",
  119. VLOOKUP(
  120. INDIRECT(
  121. ADDRESS(
  122. 3,
  123. COLUMN(
  124. H5
  125. )
  126. )
  127. ),
  128. 採点表!$A$2:$E$22,
  129. 2,
  130. FALSE
  131. ),
  132. CHAR(
  133. 10
  134. )
  135. ),
  136. ""
  137. ),
  138. IF(
  139. EXACT(
  140. I5,
  141. "✔"
  142. ),
  143. CONCATENATE(
  144. INDIRECT(
  145. ADDRESS(
  146. 3,
  147. COLUMN(
  148. I5
  149. )
  150. )
  151. ),
  152. ". ",
  153. VLOOKUP(
  154. INDIRECT(
  155. ADDRESS(
  156. 3,
  157. COLUMN(
  158. I5
  159. )
  160. )
  161. ),
  162. 採点表!$A$2:$E$22,
  163. 2,
  164. FALSE
  165. ),
  166. CHAR(
  167. 10
  168. )
  169. ),
  170. ""
  171. ),
  172. IF(
  173. EXACT(
  174. J5,
  175. "✔"
  176. ),
  177. CONCATENATE(
  178. INDIRECT(
  179. ADDRESS(
  180. 3,
  181. COLUMN(
  182. J5
  183. )
  184. )
  185. ),
  186. ". ",
  187. VLOOKUP(
  188. INDIRECT(
  189. ADDRESS(
  190. 3,
  191. COLUMN(
  192. J5
  193. )
  194. )
  195. ),
  196. 採点表!$A$2:$E$22,
  197. 2,
  198. FALSE
  199. ),
  200. CHAR(
  201. 10
  202. )
  203. ),
  204. ""
  205. ),
  206. IF(
  207. EXACT(
  208. K5,
  209. "✔"
  210. ),
  211. CONCATENATE(
  212. INDIRECT(
  213. ADDRESS(
  214. 3,
  215. COLUMN(
  216. K5
  217. )
  218. )
  219. ),
  220. ". ",
  221. VLOOKUP(
  222. INDIRECT(
  223. ADDRESS(
  224. 3,
  225. COLUMN(
  226. K5
  227. )
  228. )
  229. ),
  230. 採点表!$A$2:$E$22,
  231. 2,
  232. FALSE
  233. ),
  234. CHAR(
  235. 10
  236. )
  237. ),
  238. ""
  239. ),
  240. IF(
  241. EXACT(
  242. L5,
  243. "✔"
  244. ),
  245. CONCATENATE(
  246. INDIRECT(
  247. ADDRESS(
  248. 3,
  249. COLUMN(
  250. L5
  251. )
  252. )
  253. ),
  254. ". ",
  255. VLOOKUP(
  256. INDIRECT(
  257. ADDRESS(
  258. 3,
  259. COLUMN(
  260. L5
  261. )
  262. )
  263. ),
  264. 採点表!$A$2:$E$22,
  265. 2,
  266. FALSE
  267. ),
  268. CHAR(
  269. 10
  270. )
  271. ),
  272. ""
  273. ),
  274. IF(
  275. EXACT(
  276. M5,
  277. "✔"
  278. ),
  279. CONCATENATE(
  280. INDIRECT(
  281. ADDRESS(
  282. 3,
  283. COLUMN(
  284. M5
  285. )
  286. )
  287. ),
  288. ". ",
  289. VLOOKUP(
  290. INDIRECT(
  291. ADDRESS(
  292. 3,
  293. COLUMN(
  294. M5
  295. )
  296. )
  297. ),
  298. 採点表!$A$2:$E$22,
  299. 2,
  300. FALSE
  301. ),
  302. CHAR(
  303. 10
  304. )
  305. ),
  306. ""
  307. ),
  308. IF(
  309. EXACT(
  310. N5,
  311. "✔"
  312. ),
  313. CONCATENATE(
  314. INDIRECT(
  315. ADDRESS(
  316. 3,
  317. COLUMN(
  318. N5
  319. )
  320. )
  321. ),
  322. ". ",
  323. VLOOKUP(
  324. INDIRECT(
  325. ADDRESS(
  326. 3,
  327. COLUMN(
  328. N5
  329. )
  330. )
  331. ),
  332. 採点表!$A$2:$E$22,
  333. 2,
  334. FALSE
  335. ),
  336. CHAR(
  337. 10
  338. )
  339. ),
  340. ""
  341. ),
  342. IF(
  343. EXACT(
  344. O5,
  345. "✔"
  346. ),
  347. CONCATENATE(
  348. INDIRECT(
  349. ADDRESS(
  350. 3,
  351. COLUMN(
  352. O5
  353. )
  354. )
  355. ),
  356. ". ",
  357. VLOOKUP(
  358. INDIRECT(
  359. ADDRESS(
  360. 3,
  361. COLUMN(
  362. O5
  363. )
  364. )
  365. ),
  366. 採点表!$A$2:$E$22,
  367. 2,
  368. FALSE
  369. ),
  370. CHAR(
  371. 10
  372. )
  373. ),
  374. ""
  375. ),
  376. IF(
  377. EXACT(
  378. P5,
  379. "✔"
  380. ),
  381. CONCATENATE(
  382. INDIRECT(
  383. ADDRESS(
  384. 3,
  385. COLUMN(
  386. P5
  387. )
  388. )
  389. ),
  390. ". ",
  391. VLOOKUP(
  392. INDIRECT(
  393. ADDRESS(
  394. 3,
  395. COLUMN(
  396. P5
  397. )
  398. )
  399. ),
  400. 採点表!$A$2:$E$22,
  401. 2,
  402. FALSE
  403. ),
  404. CHAR(
  405. 10
  406. )
  407. ),
  408. ""
  409. ),
  410. IF(
  411. EXACT(
  412. Q5,
  413. "✔"
  414. ),
  415. CONCATENATE(
  416. INDIRECT(
  417. ADDRESS(
  418. 3,
  419. COLUMN(
  420. Q5
  421. )
  422. )
  423. ),
  424. ". ",
  425. VLOOKUP(
  426. INDIRECT(
  427. ADDRESS(
  428. 3,
  429. COLUMN(
  430. Q5
  431. )
  432. )
  433. ),
  434. 採点表!$A$2:$E$22,
  435. 2,
  436. FALSE
  437. ),
  438. CHAR(
  439. 10
  440. )
  441. ),
  442. ""
  443. ),
  444. IF(
  445. EXACT(
  446. R5,
  447. "✔"
  448. ),
  449. CONCATENATE(
  450. INDIRECT(
  451. ADDRESS(
  452. 3,
  453. COLUMN(
  454. R5
  455. )
  456. )
  457. ),
  458. ". ",
  459. VLOOKUP(
  460. INDIRECT(
  461. ADDRESS(
  462. 3,
  463. COLUMN(
  464. R5
  465. )
  466. )
  467. ),
  468. 採点表!$A$2:$E$22,
  469. 2,
  470. FALSE
  471. ),
  472. CHAR(
  473. 10
  474. )
  475. ),
  476. ""
  477. ),
  478. IF(
  479. EXACT(
  480. S5,
  481. "✔"
  482. ),
  483. CONCATENATE(
  484. INDIRECT(
  485. ADDRESS(
  486. 3,
  487. COLUMN(
  488. S5
  489. )
  490. )
  491. ),
  492. ". ",
  493. VLOOKUP(
  494. INDIRECT(
  495. ADDRESS(
  496. 3,
  497. COLUMN(
  498. S5
  499. )
  500. )
  501. ),
  502. 採点表!$A$2:$E$22,
  503. 2,
  504. FALSE
  505. ),
  506. CHAR(
  507. 10
  508. )
  509. ),
  510. ""
  511. ),
  512. IF(
  513. EXACT(
  514. T5,
  515. "✔"
  516. ),
  517. CONCATENATE(
  518. INDIRECT(
  519. ADDRESS(
  520. 3,
  521. COLUMN(
  522. T5
  523. )
  524. )
  525. ),
  526. ". ",
  527. VLOOKUP(
  528. INDIRECT(
  529. ADDRESS(
  530. 3,
  531. COLUMN(
  532. T5
  533. )
  534. )
  535. ),
  536. 採点表!$A$2:$E$22,
  537. 2,
  538. FALSE
  539. ),
  540. CHAR(
  541. 10
  542. )
  543. ),
  544. ""
  545. ),
  546. IF(
  547. EXACT(
  548. U5,
  549. "✔"
  550. ),
  551. CONCATENATE(
  552. INDIRECT(
  553. ADDRESS(
  554. 3,
  555. COLUMN(
  556. U5
  557. )
  558. )
  559. ),
  560. ". ",
  561. VLOOKUP(
  562. INDIRECT(
  563. ADDRESS(
  564. 3,
  565. COLUMN(
  566. U5
  567. )
  568. )
  569. ),
  570. 採点表!$A$2:$E$22,
  571. 2,
  572. FALSE
  573. ),
  574. CHAR(
  575. 10
  576. )
  577. ),
  578. ""
  579. ),
  580. IF(
  581. EXACT(
  582. V5,
  583. "✔"
  584. ),
  585. CONCATENATE(
  586. INDIRECT(
  587. ADDRESS(
  588. 3,
  589. COLUMN(
  590. V5
  591. )
  592. )
  593. ),
  594. ". ",
  595. VLOOKUP(
  596. INDIRECT(
  597. ADDRESS(
  598. 3,
  599. COLUMN(
  600. V5
  601. )
  602. )
  603. ),
  604. 採点表!$A$2:$E$22,
  605. 2,
  606. FALSE
  607. ),
  608. CHAR(
  609. 10
  610. )
  611. ),
  612. ""
  613. ),
  614. IF(
  615. EXACT(
  616. W5,
  617. "✔"
  618. ),
  619. CONCATENATE(
  620. INDIRECT(
  621. ADDRESS(
  622. 3,
  623. COLUMN(
  624. W5
  625. )
  626. )
  627. ),
  628. ". ",
  629. VLOOKUP(
  630. INDIRECT(
  631. ADDRESS(
  632. 3,
  633. COLUMN(
  634. W5
  635. )
  636. )
  637. ),
  638. 採点表!$A$2:$E$22,
  639. 2,
  640. FALSE
  641. ),
  642. CHAR(
  643. 10
  644. )
  645. ),
  646. ""
  647. ),
  648. IF(
  649. EXACT(
  650. X5,
  651. "✔"
  652. ),
  653. CONCATENATE(
  654. INDIRECT(
  655. ADDRESS(
  656. 3,
  657. COLUMN(
  658. X5
  659. )
  660. )
  661. ),
  662. ". ",
  663. VLOOKUP(
  664. INDIRECT(
  665. ADDRESS(
  666. 3,
  667. COLUMN(
  668. X5
  669. )
  670. )
  671. ),
  672. 採点表!$A$2:$E$22,
  673. 2,
  674. FALSE
  675. ),
  676. CHAR(
  677. 10
  678. )
  679. ),
  680. ""
  681. ),
  682. IF(
  683. EXACT(
  684. Y5,
  685. "✔"
  686. ),
  687. CONCATENATE(
  688. INDIRECT(
  689. ADDRESS(
  690. 3,
  691. COLUMN(
  692. Y5
  693. )
  694. )
  695. ),
  696. ". ",
  697. VLOOKUP(
  698. INDIRECT(
  699. ADDRESS(
  700. 3,
  701. COLUMN(
  702. Y5
  703. )
  704. )
  705. ),
  706. 採点表!$A$2:$E$22,
  707. 2,
  708. FALSE
  709. ),
  710. CHAR(
  711. 10
  712. )
  713. ),
  714. ""
  715. )
  716. )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement