Please clarify below queries.

1. Does the range

**N1:O10** have any relation to calculations? If yes, how exactly is it supposed to be used in formulas.

2. You have two different formulas in ranges

**B2:K11** and

**B15:K24** respectively. Do you need assistance with either one or both of them?

2. In column H we should have only

**USDMXN** as probably MXN has 0 (

**n**) assigned against it and therefore only one pair (

**n+1**). Is this the logic behind number of pairs to be shown?

3. In column H, why

**USDMXN** is the desired outcome? Why

**MXNAUD** or

**MXNCAD** are not desired outcomes? What rule does govern this calculation?

Having said this,

@Peter Bartholomew has already posted his logic. Have you checked it?