Spreadsheet: 108845d1305804043-sum-and-mark-largest-5-numbers-from-selected-range-within-column-top-5
Sheet: Sheet1

PF | SEC | L/S | LMV | SMV | ABS | LMV PF | SMV PF | GMV PF | NETMV PF | SUM OF TOP 5 LMV BY PF | SUM OF TOP 5 SMV BY PF | MARKER TO SHOW WHICH IS TOP 5 LMV BY PF | MARKER TO SHOW WHICH IS TOP 5 SMV BY PF
GART1 | CRH.L | L | 1000000 | 0 | 1000000 | 37933875 | -101575795 | 139509670 | -63641920
GART1 | GNC.L | L | 15000000 | 0 | 15000000 | 37933875 | -101575795 | 139509670 | -63641920
GART1 | RDSb.L | L | 8500000 | 0 | 8500000 | 37933875 | -101575795 | 139509670 | -63641920
GART1 | NG.L | S | 0 | -526000 | 526000 | 37933875 | -101575795 | 139509670 | -63641920
GART1 | RSL.L | S | 0 | -45218736 | 45218736 | 37933875 | -101575795 | 139509670 | -63641920
GART1 | KAZ.L | L | 6500 | 0 | 6500 | 37933875 | -101575795 | 139509670 | -63641920
GART1 | HIK.L | S | 0 | -4583218 | 4583218 | 37933875 | -101575795 | 139509670 | -63641920
GART1 | HSTN.L | L | 8900 | 0 | 8900 | 37933875 | -101575795 | 139509670 | -63641920
GART1 | COLT.L | S | 0 | -1235000 | 1235000 | 37933875 | -101575795 | 139509670 | -63641920
GART1 | SL.L | S | 0 | -11500000 | 11500000 | 37933875 | -101575795 | 139509670 | -63641920
GART1 | BKGH.L | S | 0 | -677265 | 677265 | 37933875 | -101575795 | 139509670 | -63641920
GART1 | COVE.L | L | 4585000 | 0 | 4585000 | 37933875 | -101575795 | 139509670 | -63641920
GART1 | HZNA.L | L | 1230000 | 0 | 1230000 | 37933875 | -101575795 | 139509670 | -63641920
GART1 | ABGL.L | L | 890050 | 0 | 890050 | 37933875 | -101575795 | 139509670 | -63641920
GART1 | CWP.L | S | 0 | -7859620 | 7859620 | 37933875 | -101575795 | 139509670 | -63641920
GART1 | [NAME] | L | 565000 | 0 | 565000 | 37933875 | -101575795 | 139509670 | -63641920
GART1 | ENQ.L | S | 0 | -882500 | 882500 | 37933875 | -101575795 | 139509670 | -63641920
GART1 | ESSR.L | S | 0 | -1658000 | 1658000 | 37933875 | -101575795 | 139509670 | -63641920
GART1 | CAPCC.L | S | 0 | -22654000 | 22654000 | 37933875 | -101575795 | 139509670 | -63641920
GART1 | PHNX.L | L | 4123000 | 0 | 4123000 | 37933875 | -101575795 | 139509670 | -63641920
GART1 | HWDN.L | L | 1115400 | 0 | 1115400 | 37933875 | -101575795 | 139509670 | -63641920
GART1 | ZHSTN_r.L | S | 0 | -4658000 | 4658000 | 37933875 | -101575795 | 139509670 | -63641920
GART1 | BP.L | L | 453154 | 0 | 453154 | 37933875 | -101575795 | 139509670 | -63641920
GART1 | BT.L | L | 456871 | 0 | 456871 | 37933875 | -101575795 | 139509670 | -63641920
GART1 | BLT.L | S | 0 | -123456 | 123456 | 37933875 | -101575795 | 139509670 | -63641920
GART2 | XGSG | L | 22500000 | 0 | 22500000 | 41780000 | -51018207 | 92798207 | -9238207
GART2 | XZDSGF | L | 1000000 | 0 | 1000000 | 41780000 | -51018207 | 92798207 | -9238207
GART2 | CDDRGE | S | 0 | -44500000 | 44500000 | 41780000 | -51018207 | 92798207 | -9238207
GART2 | GEEG | S | 0 | -250000 | 250000 | 41780000 | -51018207 | 92798207 | -9238207
GART2 | BGGD | L | 2564000 | 0 | 2564000 | 41780000 | -51018207 | 92798207 | -9238207
GART2 | NHGG | S | 0 | -656000 | 656000 | 41780000 | -51018207 | 92798207 | -9238207
GART2 | MJHSG | S | 0 | -4228000 | 4228000 | 41780000 | -51018207 | 92798207 | -9238207
GART2 | THHWG | S | 0 | -43652 | 43652 | 41780000 | -51018207 | 92798207 | -9238207
GART2 | GRHS | L | 5500500 | 0 | 5500500 | 41780000 | -51018207 | 92798207 | -9238207
GART2 | EFHHS | S | 0 | -785000 | 785000 | 41780000 | -51018207 | 92798207 | -9238207
GART2 | JKGSG | L | 3261000 | 0 | 3261000 | 41780000 | -51018207 | 92798207 | -9238207
GART2 | LASD | L | 4500 | 0 | 4500 | 41780000 | -51018207 | 92798207 | -9238207
GART2 | RTGG | S | 0 | -555555 | 555555 | 41780000 | -51018207 | 92798207 | -9238207
GART2 | YGHDF | L | 6950000 | 0 | 6950000 | 41780000 | -51018207 | 92798207 | -9238207