Spreadsheet: 795399d1662657873-numbering-of-rows-columns-depending-on-multiple-variables-2022-09-08-oeldere2-vicr1-file
Sheet: Data

Level | Name | Counterparty | Amount | EC | Amount | TC |  |  | Conditions | # CAD | # USD | Level | Entity | Counterparty | Amount | Currency
Level 1 | Name 1 | Name x | 18908.33 | COP | 18908.33 | COP
Level 1 | In column K i would need to do a numbering (1,2,3 and so on) for the rows which (i) have on column Q CAD and (ii) on column J YES. | Name x | 752140.14 | CAD | 752140.14 | CAD
Level 1 | Name 1 | Name 2 | -172830.35 | CAD | -172830.35 | CAD
Level 1 | Name 1 | Name 3 | 2663 | CAD | 2663 | CAD
Level 1 | Name 1 | Name x | 6718 | CAD | 6718 | CAD
Level 1 | Name 2 | Name 1 | 172830.35 | COP | 172830.35 | COP
Level 1 | Name 2 | Name x | 534750.54 | CAD | 534750.54 | CAD
Level 1 | Name 2 | Name x | 1251.91 | USD | 1251.91 | USD
Level 1 | Name 2 | Name x | 375226 | CAD | 375226 | CAD
Level 1 | Name 2 | Name x | 30725.8 | CAD | 30725.8 | CAD
Level 1 | Name 2 | Name x | 93086.72 | CAD | 93086.72 | CAD
Level 1 | Name 2 | Name x | 1842.05 | CAD | 1842.05 | CAD
Level 1 | Name 2 | Name x | 31686.65 | CAD | 31686.65 | CAD
Level 1 | Name 2 | Name x | 177600 | USD | 177600 | USD
Level 1 | Name 2 | Name x | 110400 | USD | 110400 | USD
Level 1 | Name 2 | Name x | 328450.05 | USD | 328450.05 | USD
Level 3 | Name 2 |  | -15136348.89 | CAD
Level 3 | Name 2 |  | 635344.94 | USD
Level 1 | Name 3 | Name 1 | -2663 | CAD | -2663 | CAD
Level 1 | Name 3 | Name 2 | 825383.38 | CAD | 825383.38 | CAD
Level 1 | Name 3 | Name x | 51671.92 | CAD | 51671.92 | CAD
Level 1 | Name 3 | Name 4 | -15259.94 | CAD | -15259.94 | CAD
Level 1 | Name 3 | Name x | 17053.17 | CAD | 17053.17 | CAD
Level 1 | Name 3 | Name x | -1157 | CAD | -1157 | CAD
Level 3 | Name 3 |  | 875028.53 | CAD
Level 1 | Name 4 | Name x | 18667.67 | CAD | 18667.67 | CAD
Level 1 | Name 4 | Name x | 10063.25 | CAD | 10063.25 | CAD
Level 1 | Name 4 | Name x | 167364.86 | GBP | 167364.86 | GBP
Level 1 | Name 4 | Name x | -415253.9 | GBP | -415253.9 | GBP
Level 1 | Name 4 | Name x | 4800 | GBP | 4800 | GBP
Level 1 | Name 4 | Name x | 218414.8 | CAD | 218414.8 | CAD
Level 1 | Name 4 | Name x | 151957.14 | CAD | 151957.14 | CAD
Level 1 | Name 4 | Name x | -11669.07 | CAD | -11669.07 | CAD
Level 1 | Name 4 | Name x | 293769.06 | GBP | 293769.06 | GBP
Level 1 | Name 4 | Name x | 84718.99 | CAD | 84718.99 | CAD
Level 1 | Name 4 | Name x | -30002.26 | CAD | -30002.26 | CAD
Level 1 | Name 4 | Name x | 80360.81 | CAD | 80360.81 | CAD
Level 1 | Name 4 | Name x | 30159.64 | CAD | 30159.64 | CAD
Level 1 | Name 4 | Name x | 53468.87 | CAD | 53468.87 | CAD
Level 1 | Name 4 | Name x | -111288 | USD | -111288 | USD
Level 1 | Name 4 | Name x | 8018.64 | USD | 8018.64 | USD
Level 1 | Name 4 | Name x | 2071.14 | USD | 2071.14 | USD
Level 1 | Name 4 | Name x | 1706.14 | USD | 1706.14 | USD
Level 1 | Name 4 | Name x | 51053.78 | USD | 51053.78 | USD
Level 1 | Name 4 | Name x | 326399.84 | USD | 326399.84 | USD
Level 3 | Name 4 |  | 1227461.39 | CAD
Level 3 | Name 4 |  | -243089.04 | COP
Level 3 | Name 4 |  | 293769.06 | GBP
Level 3 | Name 4 |  | 444504.99 | USD
Level 1 | Name 5 | Name x | -16254.91 | USD | -16254.91 | USD
Level 3 | Name 5 |  | -16254.91 | USD
Level 1 | Name 6 | Name y | -640200 | COP | -640200 | COP
Level 1 | Name 6 | Name 6 | -73835 | GBP | -73835 | GBP
Level 1 | Name 6 | Name y | 20475 | GBP | 20475 | GBP
Level 1 | Name 6 | Name y | -183480.37 | USD | -183480.37 | USD
Level 1 | Name 6 | Name y | 2494.78 | CAD | 2494.78 | CAD