Spreadsheet: 852297d1702385923-my-index-and-match-formula-is-returning-duplicate-entries-sample
Sheet: Sheet1

Client Group | Client | Profit Center | Person | Department Super Department | Fiscal Year | Fee Billing | Fee Billing ToBill | Fee Billing Standard | Total Cost | Profit | Profit % | Costs Hours Billed | Fee Billing Hours | Hours write-off % | Discount % | Margin Cat | Hours write-off Cat | Discount Cat | Department
Client 1 | Client 1 | Corporate and Commercial Disputes - DNU | Jon | Commercial Litigation | 2020 | 4119 | 4119.5 | 8669.5 | 2378.3861 | 1740.6139 | 0.4225816703083273 | 0 | 13.59999999999999
Client 1 | Client 1 | Corporate and Commercial Disputes | [NAME] | Commercial Litigation | 2021 | 2782.2502 | 3308.6275 | 3308.6275 | 1113.9273 | 1668.3229 | 0.599628683156858 | 0 | 5.2
Client 1 | Client 1 | Marine International Trade (M.I.T) | [NAME] | Marine International Trade (M.I.T) | 2021 | 5947 | 6322 | 12526.5 | 3164.7285 | 2782.2715 | 0.4678445434672944 | 0 | 22.8
Client 1 | Client 1 | Marine International Trade (M.I.T) | [NAME] | Marine International Trade (M.I.T) | 2022 | 0 | 122 | 145.5 | 28.3216 | -28.3216 |  | 0.3 | 0.3
Client 1 | Client 1 | Marine International Trade (M.I.T) | [NAME] | Marine International Trade (M.I.T) | 2023 | 3118.5 | 3118.5 | 7381.5 | 2936.9721 | 181.5279 | 0.05821000481000481 | 9.3 | 9.3
Client 1 | Client 1 | Marine International Trade (M.I.T) | [NAME] | Marine International Trade (M.I.T) | 2022 | 5000 | 5211 | 8422.5 | 2407.5802 | 2592.4198 | 0.5184839600000001 | 18.6 | 18.6
Client 1 | Client 1 | Marine International Trade (M.I.T) | [NAME] | Marine International Trade (M.I.T) | 2023 | 13001 | 13178 | 32533 | 8916.964 | 4084.036 | 0.3141324513498961 | 39.1 | 38.5
Client 1 | Client 1 | Marine International Trade (M.I.T) | [NAME] | Marine International Trade (M.I.T) | 2024 | 11924.5 | 15807.5 | 39632 | 11207.8 | 716.7 | 0.06010314897899283 | 64.8 | 40.7
Client 1 | Client 1 | Marine International Trade (MIT) - HK | Aspen | M.I.T Hong Kong | 2022 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
Client 1 | Client 1 | Rail | George | Finance | 2021 | 2000 | 4093 | 7875 | 2109.1773 | -109.1773 | -0.05458865 | 0 | 12.3
Client 1 | Client 1 | Ship Finance | Mark | Finance | 2021 | 28065.5 | 40781.01 | 52592 | 13148.7836 | 14916.7164 | 0.5314965491439668 | 0 | 75.1
Client 1 | Client 1 | Ship Finance | Mark | Finance | 2022 | 24285 | 22484 | 26083.5 | 8229.994 | 16055.006 | 0.6611079267037265 | 41.1 | 41.1
Client 1 | Client 1 | Ship Finance | Mark | Finance | 2023 | 11644 | 11644 | 11644 | 3684.1408 | 7959.8592 | 0.6836017863277224 | 14.5 | 14.5
Client 1 | Client 1 | Ship Finance | Mark | Finance | 2024 | 8446 | 8868 | 8868 | 2147.7 | 6298.3 | 0.7457139474307365 | 11.3 | 11.3
Client 1 | Client 1 | Central management | Pauline | (Unknown) | 2020 | 0 | 0.32 | 262640 | 53273.5224 | -53273.5224 |  | 0 | 462
Client 1 | Client 1 | Employment | Sandra | Employment, Pensions and Private Wealth | 2021 | 5248 | 5502 | 7507.5 | 1995.9583 | 3252.0417 | 0.6196725800304879 | 0 | 11.1
Client 1 | Client 1 | Employment | Sandra | Employment, Pensions and Private Wealth | 2022 | 0 | 121 | 121 | 23.6523 | -23.6523 |  | 0.2 | 0
Client 1 | Client 1 | Employment | Sandra | Employment, Pensions and Private Wealth | 2023 | 32453.6 | 35123.6 | 49146 | 10840.1732 | 21613.4268 | 0.6659793304903001 | 96 | 90.22999999999999
Client 1 | Client 1 | Employment | Sandra | Employment, Pensions and Private Wealth | 2024 | 4475 | 4752 | 6754 | 1551.4817 | 2923.5183 | 0.6533001787709498 | 11 | 10.7
Client 1 | Client 1 | International Arbitration A | Ella | Commercial Litigation | 2020 | 31902.7848 | 51542.5247 | 60917.9005 | 18734.1377 | 13168.6471 | 0.4127741523547 | 0 | 92.30000000000001
Client 1 | Client 1 | Marine International Trade (M.I.T) | [NAME] | Marine International Trade (M.I.T) | 2020 | 1028985.32 | 1168806.04 | 2151078.75 | 474195.0813 | 554790.2387 | 0.5391624427644895 | 0 | 4198.099999999999
Client 1 | Client 1 | Marine International Trade (M.I.T) | [NAME] | Marine International Trade (M.I.T) | 2021 | 1096550.65 | 1229577.3 | 2250710.5 | 607380.2545 | 489170.3955 | 0.4460992212616972 | 0 | 4233.130000000002
Client 1 | Client 1 | Marine International Trade (M.I.T) | [NAME] | Marine International Trade (M.I.T) | 2022 | 621837.91 | 719179.95 | 1361876.75 | 360387.732 | 261450.178 | 0.4204474664394863 | 2974.35 | 2533.7
Client 1 | Client 1 | Marine International Trade (M.I.T) | [NAME] | Marine International Trade (M.I.T) | 2023 | 886342.36 | 914419.5 | 1904384 | 553905.6259 | 332436.7341 | 0.3750658313340682 | 3575.6 | 3404.6
Client 1 | Client 1 | Marine International Trade (M.I.T) | [NAME] | Marine International Trade (M.I.T) | 2024 | 652311.5 | 703203.5 | 1540689.5 | 494168 | 158143.5 | 0.2424355541792533 | 2848.4 | 2368.700000000001
Client 1 | Client 1 | Marine International Trade (M.I.T) | [NAME] | Marine International Trade (M.I.T) | 2020 | 392740.85 | 428956.73 | 894870 | 320228.2024 | 72512.6476 | 0.1846322982538664 | 0 | 1474.6
Client 1 | Client 1 | Marine International Trade (M.I.T) | [NAME] | Marine International Trade (M.I.T) | 2021 | 550441.2 | 597410.22 | 1244972.5 | 363849.0243 | 186592.1757 | 0.3389865724077341 | 0 | 1967.499999999999
Client 1 | Client 1 | Marine International Trade (M.I.T) | [NAME] | Marine International Trade (M.I.T) | 2022 | 663209.35 | 734706 | 1613566 | 364317.5829 | 298891.7671 | 0.4506748323033318 | 2523.300000000001 | 2496.699999999999
Client 1 | Client 1 | Marine International Trade (M.I.T) | [NAME] | Marine International Trade (M.I.T) | 2023 | 1068742.2 | 1179953 | 2617477 | 536300.1004 | 532442.0996 | 0.4981950741722372 | 4708.6 | 4642.600000000001
Client 1 | Client 1 | Marine International Trade (M.I.T) | [NAME] | Marine International Trade (M.I.T) | 2024 | 833343.45 | 910349.5 | 2207930.5 | 537587.9555 | 295755.4945 | 0.3549022806274858 | 2805.799999999999 | 3117.900000000003
Client 1 | Client 1 | Marine International Trade (M.I.T) | Allayna | Marine International Trade (M.I.T) | 2024 | 13184.5 | 19954 | 43456 | 9638.8 | 3545.7 | 0.26892942470325 | 63.6 | 43.10000000000001
Client 1 | Client 1 | Marine International Trade (M.I.T) | Savannah | Marine International Trade (M.I.T) | 2020 | 9306.327 | 9530.7919 | 14263.1819 | 3428.2529 | 5878.0741 | 0.6316210686704641 | 0 | 23.2
Client 1 | Client 1 | Marine International Trade (M.I.T) | anne | Marine International Trade (M.I.T) | 2023 | 184957.2 | 165858.2 | 404752 | 120831.7636 | 64125.4364 | 0.346704191023653 | 604.2 | 589.1999999999999
Client 1 | Client 1 | Marine International Trade (M.I.T) | anne | Marine International Trade (M.I.T) | 2024 | 286368.8 | 285846.2 | 541922 | 142666.5 | 143702.3 | 0.5018085070719994 | 761.6999999999999 | 761.7000000000002
Client 1 | Client 1 | Ship Finance | Mark | Finance | 2020 | 5000 | 6821.28 | 8025 | 2563.1212 | 2436.8788 | 0.48737576 | 0 | 12.8
Client 1 | Client 1 | Ship Finance | Mark | Finance | 2021 | 8264.55 | 9891 | 9891 | 3117.6629 | 5146.8871 | 0.6227660153716592 | 0 | 13.8
Client 1 | Client 1 | Ship Finance | Mark | Finance | 2024 | 11681 | 11681 | 24108 | 8163.1 | 3517.9 | 0.3011642838798048 | 24.3 | 24.3
Client 1 | Client 1 | Ship Finance | [NAME] | Finance | 2021 | 20374.8982 | 25672.1717 | 27470.0864 | 7270.0923 | 13104.8059 | 0.643183814399089 | 0 | 55.3
Client 1 | Client 1 | International Arbitration A | Ella | Commercial Litigation | 2021 | 3733.1051 | 4670.6192 | 5611.825 | 1648.8371 | 2084.268 | 0.5583194708969197 | 0 | 12.2
Client 1 | Client 1 | International Arbitration A | Ella | Commercial Litigation | 2022 | 18231.4038 | 17758.4881 | 23884.7899 | 6824.3277 | 11407.0761 | 0.625682604910975 | 48.7 | 53.1
Client 1 | Client 1 | International Arbitration A | Ella | Commercial Litigation | 2023 | 30050.8568 | 29898.3672 | 48552.0423 | 13029.8606 | 17020.9962 | 0.5664062925320607 | 71.6 | 71.6
Client 1 | Client 1 | International Arbitration A | Ella | Commercial Litigation | 2024 | 14010.8123 | 14128.5211 | 25581.6653 | 8872.4 | 5138.4123 | 0.3667460077283128 | 33.8 | 33.79999999999999
Client 1 | Client 1 | Marine International Trade (M.I.T) | [NAME] | Marine International Trade (M.I.T) | 2022 | 4921.5 | 4985.5 | 8439 | 2681.1778 | 2240.3222 | 0.4552112567306715 | 22.3 | 21.9
Client 1 | Client 1 | Marine International Trade (M.I.T) | [NAME] | Marine International Trade (M.I.T) | 2023 | 11604 | 13493.5 | 26301 | 7637.964 | 3966.036 | 0.3417817993795243 | 43 | 36.3
Client 1 | Client 1 | Marine International Trade (MIT) - HK | Aspen | M.I.T Hong Kong | 2024 | 1204.4549 | 3003.9048 | 3003.9048 | 1044.1 | 160.3549 | 0.1331342676386098 | 6.4 | 6.399999999999999
Client 1 | Client 1 | Ship Finance | Mark | Finance | 2022 | 63578.565 | 63236.3697 | 63236.3697 | 17065.7353 | 46512.8297 | 0.7315803060685385 | 104.3 | 104.3
Client 1 | Client 1 | Ship Finance | Mark | Finance | 2023 | 92168.0044 | 68081.8238 | 68199.5636 | 19800.9955 | 72367.0089 | 0.7851640596341399 | 108 | 108
Client 1 | Client 1 | Ship Finance | Mark | Finance | 2024 | 11629.6057 | 37410.9881 | 39094.9391 | 13170.9777 | -1541.372 | -0.1325385803995147 | 91.7 | 91.69999999999997
Client 1 | Client 1 | Corporate and Commercial Disputes | [NAME] | Commercial Litigation | 2023 | 1592.306 | 3665.3012 | 3665.3012 | 923.1294 | 669.1766 | 0.4202552266832464 | 6.5 | 6.5
Client 1 | Client 1 | Corporate and Commercial Disputes | [NAME] | Commercial Litigation | 2021 | 2651.5152 | 8731.6841 | 8731.6841 | 3193.6093 | -542.0941 | -0.2044465438691769 | 0 | 18
Client 1 | Client 1 | Corporate and Commercial Disputes | [NAME] | Commercial Litigation | 2022 | 21892.1788 | 50110.6696 | 66053.3155 | 18172.7474 | 3719.4314 | 0.1698977169016516 | 123 | 123
Client 1 | Client 1 | Corporate Finance | [NAME] | Corporate | 2022 | 16933.2079 | 12494.8577 | 12494.8577 | 10305.1721 | 6628.0358 | 0.3914222879182388 | 56.5 | 21.40000000000001
Client 1 | Client 1 | International Arbitration A | Ella | Commercial Litigation | 2020 | 6610.4056 | 12731.8429 | 15752.1696 | 4137.5371 | 2472.8685 | 0.3740870082188548 | 0 | 44.8
Client 1 | Client 1 | International Arbitration A | Ella | Commercial Litigation | 2024 | 3697.2528 | 6579.8655 | 10133.7954 | 3515.5 | 181.7528 | 0.049158782449706 | 20 | 20
Client 1 | Client 1 | Marine International Trade (MIT) - HK | Aspen | M.I.T Hong Kong | 2021 | 9769.7489 | 18107.997 | 21093.3696 | 6684.1546 | 3085.5943 | 0.3158314491158934 | 0 | 53.4
Client 1 | Client 1 | Marine International Trade (MIT) - HK | Aspen | M.I.T Hong Kong | 2022 | 7928.4676 | 11335.5972 | 14186.4705 | 4418.801 | 3509.6666 | 0.4426663151906988 | 35.4 | 36.3
Client 1 | Client 1 | Marine International Trade (MIT) - HK | Aspen | M.I.T Hong Kong | 2023 | 5329.0702 | 5352.812 | 7082.6848 | 2849.4356 | 2479.6346 | 0.4653025662966215 | 15.2 | 15.2
Client 1 | Client 1 | Private Wealth - HK - DNU | [NAME] | Corporate | 2022 | 0 | 15955.6058 | 15955.6058 |  | 0 |  |  | 34.1
Client 1 | Client 1 | Marine International Trade (M.I.T) | [NAME] | Marine International Trade (M.I.T) | 2024 | 102577 | 102140 | 226424 | 72176.1 | 30400.9 | 0.2963715062830849 | 341.9 | 343.1999999999999
Client 1 | Client 1 | Marine International Trade (M.I.T) | [NAME] | Marine International Trade (M.I.T) | 2024 | 3170.3503 | 1474.6314 | 3184.985 | 2190.4 | 979.9503 | 0.3090974841973782 | 11 | 5.000000000000001
Client 1 | Client 1 | Ship Finance | [NAME] | Finance | 2024 | 10000 | 12963.5 | 12576.5 | 3528.4 | 6471.6 | 0.6471600000000001 | 23.6 | 23.6
Client 1 | Client 1 | Corporate and Commercial Disputes - DNU | Jon | Commercial Litigation | 2021 | 3250 | 3484.5 | 7297.5 | 2006.2256 | 1243.7744 | 0.3826998153846154 | 0 | 11.1
Client 1 | Client 1 | Employment | Sandra | Employment, Pensions and Private Wealth | 2020 | 5000 | 7736 | 10229 | 2282.0534 | 2717.9466 | 0.54358932 | 0 | 16
Client 1 | Client 1 | Marine International Trade (M.I.T) | [NAME] | Marine International Trade (M.I.T) | 2020 | 33465 | 38225.5 | 88080 | 21017.2002 | 12447.7998 | 0.3719647333034514 | 0 | 124.3
Client 1 | Client 1 | Marine International Trade (M.I.T) | [NAME] | Marine International Trade (M.I.T) | 2021 | 13438 | 14748 | 36849 | 9317.8572 | 4120.1428 | 0.3066038696234558 | 0 | 49.7
Client 1 | Client 1 | Marine International Trade (M.I.T) | [NAME] | Marine International Trade (M.I.T) | 2022 | 11396 | 12922.5 | 29226.5 | 7696.3191 | 3699.6809 | 0.3246473236223236 | 47.1 | 42.69999999999998
Client 1 | Client 1 | Marine International Trade (M.I.T) | [NAME] | Marine International Trade (M.I.T) | 2023 | 1555 | 1463 | 4433 | 1074.7306 | 480.2694 | 0.3088549196141479 | 5.5 | 5.9
Client 1 | Client 1 | Ship Finance | Mark | Finance | 2021 | 26237.1546 | 7266.5985 | 7266.5985 | 2363.5654 | 23873.5892 | 0.9099151432548339 | 0 | 13.2
Client 1 | Client 1 | Ship Finance | Mark | Finance | 2022 | 0 | 8073.0698 | 8073.0698 | 1984.544 | -1984.544 |  | 24.5 | 24.5
Client 2 | Client 2 | Banking | [NAME] | Finance | 2022 | 5700 | 5713.5 | 9526 | 3139.0793 | 2560.9207 | 0.4492843333333333 | 14.1 | 14.1
Client 2 | Client 2 | Banking | [NAME] | Finance | 2023 | 0 | 982 | 1827.5 | 555.0749 | -555.0749 |  | 2.2 | 2.2
Client 2 | Client 2 | Construction Litigation | [NAME] | Commercial Litigation | 2020 | 53423 | 58132 | 102951.5 | 32336.9007 | 21086.0993 | 0.3947007712034143 | 0 | 163
Client 2 | Client 2 | Construction Litigation | [NAME] | Commercial Litigation | 2021 | 45796.5 | 62980.53 | 114597.5 | 28982.6595 | 16813.8405 | 0.3671424781369755 | 0 | 153.3
Client 2 | Client 2 | Construction Litigation | [NAME] | Commercial Litigation | 2022 | 56359 | 61932 | 107871 | 28312.5871 | 28046.4129 | 0.4976385830124736 | 195.8 | 169.3
Client 2 | Client 2 | Construction Litigation | [NAME] | Commercial Litigation | 2023 | 53642.1 | 65480.9 | 118825.5 | 34217.6028 | 19424.4972 | 0.362112915042476 | 175.3 | 142.5
Client 2 | Client 2 | Construction Litigation | [NAME] | Commercial Litigation | 2024 | 2159.7 | 2159.7 | 3573.5 | 1095.5 | 1064.2 | 0.4927536231884059 | 5.3 | 5.300000000000001
Client 2 | Client 2 | Intellectual Property B | Alexandra | Commercial Litigation | 2022 | 7682.5 | 9836 | 16905.5 | 5033.1978 | 2649.3022 | 0.3448489684347543 | 32.59999999999999 | 31.4
Client 2 | Client 2 | Intellectual Property B | Alexandra | Commercial Litigation | 2023 | 32049.2 | 37364.6 | 64026.5 | 21651.9836 | 10397.2164 | 0.3244142256280968 | 123 | 103.5
Client 2 | Client 2 | Intellectual Property B | Alexandra | Commercial Litigation | 2024 | 6978 | 7732.2 | 12763 | 4111.2 | 2866.8 | 0.4108340498710232 | 23.2 | 20.2
Client 2 | Client 2 | Private Wealth | Hugo | Employment, Pensions and Private Wealth | 2020 | 395 | 395 | 625 | 125.0602 | 269.9398 | 0.6833918987341772 | 0 | 1
Client 2 | Client 2 | Projects, energy & infrastructure | Graeme | Real Estate and Projects | 2024 | 18184.5 | 18184.5 | 42468 | 11922.9 | 6261.6 | 0.3443372102614864 | 44.9 | 44.89999999999999
Client 3 | Client 3 | Construction Litigation | [NAME] | Commercial Litigation | 2020 | 0 | 0 | 0 | 0 | 0 |  | 0 | -3.552713678800501e-15
Client 3 | Client 3 | Construction Litigation | Thwaite | Commercial Litigation | 2024 | 32599 | 32704.5 | 57242 | 16161.6 | 16437.4 | 0.5042301911101568 | 86.80000000000001 | 86.7999999999999
Client 3 | Client 3 | Rail | [NAME] | Finance | 2020 | 50077 | 41597 | 61810 | 19412.9386 | 30664.0614 | 0.6123382271302195 | 0 | 103.7
Client 3 | Client 3 | Rail | [NAME] | Finance | 2021 | 6449.5 | 6449.5 | 9755 | 2108.603 | 4340.897 | 0.6730594619737964 | 0 | 17.3
Client 3 | Client 3 | Rail | [NAME] | Finance | 2022 | 5218.5 | 5266 | 8554.5 | 646.4627 | 4572.0373 | 0.8761209734598064 | 3.6 | 13.3
Client 3 | Client 3 | Rail | [NAME] | Finance | 2020 | 138469.75 | 153911.01 | 267906 | 86905.2101 | 51564.5399 | 0.3723884543455553 | 0 | 405.0500000000001
Client 3 | Client 3 | Rail | [NAME] | Finance | 2022 | 440 | 440 | 695 | 124.2214 | 315.7786 | 0.7176786363636364 | 1 | 1
Client 3 | Client 3 | Rail | [NAME] | Finance | 2023 | 7456.85 | 7560.55 | 11861 | 2343.1008 | 5113.7492 | 0.685777820691283 | 19.63 | 19.6
Client 3 | Client 3 | Rail | [NAME] | Finance | 2024 | 13048.55 | 13069.1 | 22181.2 | 5433.91 | 7614.64 | 0.5835617110240517 | 31.2 | 31.15
Client 3 | Client 3 | Employment | Ptriam | Employment, Pensions and Private Wealth | 2022 | 6826.5 | 6286.5 | 10138.5 | 1850.825 | 4975.675 | 0.7288764374130228 | 16 | 16
Client 3 | Client 3 | Property Litigation | Myers | Commercial Litigation | 2022 | 600 | 1245 | 1245 | 421.8187 | 178.1813 | 0.2969688333333333 | 3.8 | 3.800000000000001