Q1.1 - IFERROR LARGE SUBSTITUTE
Q1.2 - IFERROR SMALL SUBSTITUTE
Q1.3 - IFERROR SMALL SUBSTITUTE TEXT
Q2 - IF IFERROR MID PRODUCT REPT ROW SUBSTITUTE SUM TEXT
Q3 - RIGHT MID ROUNDDOWN SUM
Q4 - REPT RIGHT ROUND ROUNDDOWN ROW SMALL SUBSTITUTE SUM TEXT VLOOKUP
:^(
:^(
Q5.1 - LEN SUBSTITUTE SUM
Q5.2 - LEN MID SUBSTITUTE SUM TEXT
Q5.3 - LARGE LEN SUBSTITUTE SUM
Q5.4 - IF IFERROR LARGE LEN MATCH MOD RIGHT ROUND ROW SMALL SUBSTITUTE