Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- =CONCATENATE(
- IF(
- EXACT(
- E5,
- "✔"
- ),
- CONCATENATE(
- INDIRECT(
- ADDRESS(
- 3,
- COLUMN(
- E5
- )
- )
- ),
- ". ",
- VLOOKUP(
- INDIRECT(
- ADDRESS(
- 3,
- COLUMN(
- E5
- )
- )
- ),
- 採点表!$A$2:$E$22,
- 2,
- FALSE
- ),
- CHAR(
- 10
- )
- ),
- ""
- ),
- IF(
- EXACT(
- F5,
- "✔"
- ),
- CONCATENATE(
- INDIRECT(
- ADDRESS(
- 3,
- COLUMN(
- F5
- )
- )
- ),
- ". ",
- VLOOKUP(
- INDIRECT(
- ADDRESS(
- 3,
- COLUMN(
- F5
- )
- )
- ),
- 採点表!$A$2:$E$22,
- 2,
- FALSE
- ),
- CHAR(
- 10
- )
- ),
- ""
- ),
- IF(
- EXACT(
- G5,
- "✔"
- ),
- CONCATENATE(
- INDIRECT(
- ADDRESS(
- 3,
- COLUMN(
- G5
- )
- )
- ),
- ". ",
- VLOOKUP(
- INDIRECT(
- ADDRESS(
- 3,
- COLUMN(
- G5
- )
- )
- ),
- 採点表!$A$2:$E$22,
- 2,
- FALSE
- ),
- CHAR(
- 10
- )
- ),
- ""
- ),
- IF(
- EXACT(
- H5,
- "✔"
- ),
- CONCATENATE(
- INDIRECT(
- ADDRESS(
- 3,
- COLUMN(
- H5
- )
- )
- ),
- ". ",
- VLOOKUP(
- INDIRECT(
- ADDRESS(
- 3,
- COLUMN(
- H5
- )
- )
- ),
- 採点表!$A$2:$E$22,
- 2,
- FALSE
- ),
- CHAR(
- 10
- )
- ),
- ""
- ),
- IF(
- EXACT(
- I5,
- "✔"
- ),
- CONCATENATE(
- INDIRECT(
- ADDRESS(
- 3,
- COLUMN(
- I5
- )
- )
- ),
- ". ",
- VLOOKUP(
- INDIRECT(
- ADDRESS(
- 3,
- COLUMN(
- I5
- )
- )
- ),
- 採点表!$A$2:$E$22,
- 2,
- FALSE
- ),
- CHAR(
- 10
- )
- ),
- ""
- ),
- IF(
- EXACT(
- J5,
- "✔"
- ),
- CONCATENATE(
- INDIRECT(
- ADDRESS(
- 3,
- COLUMN(
- J5
- )
- )
- ),
- ". ",
- VLOOKUP(
- INDIRECT(
- ADDRESS(
- 3,
- COLUMN(
- J5
- )
- )
- ),
- 採点表!$A$2:$E$22,
- 2,
- FALSE
- ),
- CHAR(
- 10
- )
- ),
- ""
- ),
- IF(
- EXACT(
- K5,
- "✔"
- ),
- CONCATENATE(
- INDIRECT(
- ADDRESS(
- 3,
- COLUMN(
- K5
- )
- )
- ),
- ". ",
- VLOOKUP(
- INDIRECT(
- ADDRESS(
- 3,
- COLUMN(
- K5
- )
- )
- ),
- 採点表!$A$2:$E$22,
- 2,
- FALSE
- ),
- CHAR(
- 10
- )
- ),
- ""
- ),
- IF(
- EXACT(
- L5,
- "✔"
- ),
- CONCATENATE(
- INDIRECT(
- ADDRESS(
- 3,
- COLUMN(
- L5
- )
- )
- ),
- ". ",
- VLOOKUP(
- INDIRECT(
- ADDRESS(
- 3,
- COLUMN(
- L5
- )
- )
- ),
- 採点表!$A$2:$E$22,
- 2,
- FALSE
- ),
- CHAR(
- 10
- )
- ),
- ""
- ),
- IF(
- EXACT(
- M5,
- "✔"
- ),
- CONCATENATE(
- INDIRECT(
- ADDRESS(
- 3,
- COLUMN(
- M5
- )
- )
- ),
- ". ",
- VLOOKUP(
- INDIRECT(
- ADDRESS(
- 3,
- COLUMN(
- M5
- )
- )
- ),
- 採点表!$A$2:$E$22,
- 2,
- FALSE
- ),
- CHAR(
- 10
- )
- ),
- ""
- ),
- IF(
- EXACT(
- N5,
- "✔"
- ),
- CONCATENATE(
- INDIRECT(
- ADDRESS(
- 3,
- COLUMN(
- N5
- )
- )
- ),
- ". ",
- VLOOKUP(
- INDIRECT(
- ADDRESS(
- 3,
- COLUMN(
- N5
- )
- )
- ),
- 採点表!$A$2:$E$22,
- 2,
- FALSE
- ),
- CHAR(
- 10
- )
- ),
- ""
- ),
- IF(
- EXACT(
- O5,
- "✔"
- ),
- CONCATENATE(
- INDIRECT(
- ADDRESS(
- 3,
- COLUMN(
- O5
- )
- )
- ),
- ". ",
- VLOOKUP(
- INDIRECT(
- ADDRESS(
- 3,
- COLUMN(
- O5
- )
- )
- ),
- 採点表!$A$2:$E$22,
- 2,
- FALSE
- ),
- CHAR(
- 10
- )
- ),
- ""
- ),
- IF(
- EXACT(
- P5,
- "✔"
- ),
- CONCATENATE(
- INDIRECT(
- ADDRESS(
- 3,
- COLUMN(
- P5
- )
- )
- ),
- ". ",
- VLOOKUP(
- INDIRECT(
- ADDRESS(
- 3,
- COLUMN(
- P5
- )
- )
- ),
- 採点表!$A$2:$E$22,
- 2,
- FALSE
- ),
- CHAR(
- 10
- )
- ),
- ""
- ),
- IF(
- EXACT(
- Q5,
- "✔"
- ),
- CONCATENATE(
- INDIRECT(
- ADDRESS(
- 3,
- COLUMN(
- Q5
- )
- )
- ),
- ". ",
- VLOOKUP(
- INDIRECT(
- ADDRESS(
- 3,
- COLUMN(
- Q5
- )
- )
- ),
- 採点表!$A$2:$E$22,
- 2,
- FALSE
- ),
- CHAR(
- 10
- )
- ),
- ""
- ),
- IF(
- EXACT(
- R5,
- "✔"
- ),
- CONCATENATE(
- INDIRECT(
- ADDRESS(
- 3,
- COLUMN(
- R5
- )
- )
- ),
- ". ",
- VLOOKUP(
- INDIRECT(
- ADDRESS(
- 3,
- COLUMN(
- R5
- )
- )
- ),
- 採点表!$A$2:$E$22,
- 2,
- FALSE
- ),
- CHAR(
- 10
- )
- ),
- ""
- ),
- IF(
- EXACT(
- S5,
- "✔"
- ),
- CONCATENATE(
- INDIRECT(
- ADDRESS(
- 3,
- COLUMN(
- S5
- )
- )
- ),
- ". ",
- VLOOKUP(
- INDIRECT(
- ADDRESS(
- 3,
- COLUMN(
- S5
- )
- )
- ),
- 採点表!$A$2:$E$22,
- 2,
- FALSE
- ),
- CHAR(
- 10
- )
- ),
- ""
- ),
- IF(
- EXACT(
- T5,
- "✔"
- ),
- CONCATENATE(
- INDIRECT(
- ADDRESS(
- 3,
- COLUMN(
- T5
- )
- )
- ),
- ". ",
- VLOOKUP(
- INDIRECT(
- ADDRESS(
- 3,
- COLUMN(
- T5
- )
- )
- ),
- 採点表!$A$2:$E$22,
- 2,
- FALSE
- ),
- CHAR(
- 10
- )
- ),
- ""
- ),
- IF(
- EXACT(
- U5,
- "✔"
- ),
- CONCATENATE(
- INDIRECT(
- ADDRESS(
- 3,
- COLUMN(
- U5
- )
- )
- ),
- ". ",
- VLOOKUP(
- INDIRECT(
- ADDRESS(
- 3,
- COLUMN(
- U5
- )
- )
- ),
- 採点表!$A$2:$E$22,
- 2,
- FALSE
- ),
- CHAR(
- 10
- )
- ),
- ""
- ),
- IF(
- EXACT(
- V5,
- "✔"
- ),
- CONCATENATE(
- INDIRECT(
- ADDRESS(
- 3,
- COLUMN(
- V5
- )
- )
- ),
- ". ",
- VLOOKUP(
- INDIRECT(
- ADDRESS(
- 3,
- COLUMN(
- V5
- )
- )
- ),
- 採点表!$A$2:$E$22,
- 2,
- FALSE
- ),
- CHAR(
- 10
- )
- ),
- ""
- ),
- IF(
- EXACT(
- W5,
- "✔"
- ),
- CONCATENATE(
- INDIRECT(
- ADDRESS(
- 3,
- COLUMN(
- W5
- )
- )
- ),
- ". ",
- VLOOKUP(
- INDIRECT(
- ADDRESS(
- 3,
- COLUMN(
- W5
- )
- )
- ),
- 採点表!$A$2:$E$22,
- 2,
- FALSE
- ),
- CHAR(
- 10
- )
- ),
- ""
- ),
- IF(
- EXACT(
- X5,
- "✔"
- ),
- CONCATENATE(
- INDIRECT(
- ADDRESS(
- 3,
- COLUMN(
- X5
- )
- )
- ),
- ". ",
- VLOOKUP(
- INDIRECT(
- ADDRESS(
- 3,
- COLUMN(
- X5
- )
- )
- ),
- 採点表!$A$2:$E$22,
- 2,
- FALSE
- ),
- CHAR(
- 10
- )
- ),
- ""
- ),
- IF(
- EXACT(
- Y5,
- "✔"
- ),
- CONCATENATE(
- INDIRECT(
- ADDRESS(
- 3,
- COLUMN(
- Y5
- )
- )
- ),
- ". ",
- VLOOKUP(
- INDIRECT(
- ADDRESS(
- 3,
- COLUMN(
- Y5
- )
- )
- ),
- 採点表!$A$2:$E$22,
- 2,
- FALSE
- ),
- CHAR(
- 10
- )
- ),
- ""
- )
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement