Spreadsheet: 745610d1630061671-how-to-get-a-value-in-excel-based-on-multiple-cells-and-excluding-duplicates-mock-up
Sheet: test for packages

Package type | Package No | Institution | ORDER No. | TOTAL VALUE | TOTAL PACKAGE PRICE ACCORDING TO RATE CARD | DISC.% |  | PROFILE | PG only? | Months | TOTAL PRICE ACC. TO RATECARD | DISC.% | BANNERS | Specify only if not HI | Imp. | TOTAL PRICE ACC. TO RATECARD | CPM | RATECARD CPM | DISC.% | ARTICLES | Incl. in newsletter? | No of Articles | TOTAL PRICE ACC. TO RATECARD | COST PER ARTICLE | RATECARD price per article | DISC.% | [NAME] | Contacts | RATECARD total price (incl. setup fee) | COST PER CONTACT | RATE CARD cost per contact | DISC.% | NEWSLETTER | No of Insertions | Rate card total price | DISC.%
PROFILE BANNERS ARTICLES | 1 | NS11224 HEC school of management - Paris | SO33230 |  |  |  |  | 2205.88 | YES | 12 |  |  | 8823.53 |  | 600000 |  |  | 31 |  | 0 |  | 1 |  |  | 1995
 | 2 | NS01113 Universidad [NAME] Madrid | SO34196 |  |  |  |  | 5147.06 |  | 12 |  |  | 735.29 |  | 150000 |  |  | 35 |  | 992.65 | YES | 1 |  |  | 1995
 | 3 | NS10343 The University of Amsterdam | SO34331 |  |  |  |  | 5147.06 |  | 12 |  |  | 2573.53 |  | 100000 |  |  | 35 |  | 1102.94 | YES | 1 |  |  | 1995
 | 4 | NS10310 Waseda University | SO34354 |  |  |  |  | 15608.12 |  | 36 |  |  | 12131.76 |  | 900000 |  |  | 31 |  | 0 | YES | 3 |  |  | 1600
 | 5 | NS00821 Emlyon Business School | SO34588 |  |  |  |  | 2205.88 | YES | 12 |  |  | 11926.47 | LB, MPU and HI | 980000 |  |  |  |  | 7500 | YES | 6 |  |  | 1400
 | 6 | NS13428 Universidad de Castilla – [NAME] (UCLM) | SO34669 |  |  |  |  | 4411.76 |  | 12 |  |  | 2205.88 |  | 100000 |  |  | 39 |  | 1213.24 |  | 1 |  |  | 1995
 | 7 | NS00226 EU Business School | SO34648 |  |  |  |  | 3529.41 |  | 12 |  |  | 845.59 |  | 100000 |  |  | 39 |  | 1227.94 |  | 2 |  |  | 1600
PROFILE BANNERS EMAIL | 1 | NS00429 Solvay Brussels School of Economics and Management (SBS-EM) | SO32262 |  |  |  |  | 4411.76 |  | 12 |  |  | 1838.24 | MPU | 100000 |  |  | 25 |  |  |  |  |  |  |  |  | 5545.59 | 15084
 | 2 | NS00626 [NAME] Erasmus University | SO33051 |  |  |  |  | 2205.88 | YES | 12 |  |  | 2025.74 |  | 150000 |  |  | 35 |  |  |  |  |  |  |  |  | 1470.59 | 4000
 | 3 | NS09617 Hong Kong Polytechnic University - School of Hotel & Tourism Management | SO34449 |  |  |  |  | 4192.57 |  | 12 |  |  | 2871.62 |  | 100000 |  |  | 39 |  |  |  |  |  |  |  |  | 689.19 | 3000
 | 4 | NS12609 University of Twente | SO34699 |  |  |  |  | 6617.65 |  | 12 |  |  | 0 |  | 100000 |  |  | 39 |  |  |  |  |  |  |  |  | 0 | 2000
 | 5 | NS02075 University of Dubai | SO34075 |  |  |  |  | 4054.06 |  | 12 |  |  | 1689.19 |  | 50000 |  |  | 39 |  |  |  |  |  |  |  |  | 2702.7 | 8000
 | 6 | NS06939 Católica Lisbon Business and Economics | SO34283 |  |  |  |  | 3676.47 |  | 12 |  |  | 3676.47 |  | 200000 |  |  | 35 |  |  |  |  |  |  |  |  | 3830.88 | 15000
 | 7 | NS12337 University of Derby | SO33945 |  |  |  |  | 5000 |  | 12 |  |  | 2850 |  | 250000 |  |  | 35 |  |  |  |  |  |  |  |  | 1800 | 3000
PROFILE BANNERS | 1 | NS12593 National University of Singapore - Office of Corporate Relations | SO32098 |  |  |  |  | 2027.03 |  | 6 |  |  | 20270.28 | MPU | 750000 |  |  | 20
 | 2 | NS11281 Swinburne University of Technology | SO32453 |  |  |  |  | 4560.81 |  | 12 |  |  | 4560.81 |  | 250000 |  |  | 35
 | 3 | NS10264 University of Technology Sydney | SO32540 |  |  |  |  | 3378.38 |  | 12 |  |  | 20270.28 | LB | 400000 |  |  | 16
 | 4 | NS11471 The University of Sydney | SO32594 |  |  |  |  | 6756.76 |  | 12 |  |  | 20270.28 |  | 1000000 |  |  | 31
 | 5 | NS11660 Universita Autònoma de Barcelona | SO32682 |  |  |  |  | 4411.76 |  | 12 |  |  | 6948.53 |  | 500000 |  |  | 31
 | 6 | NS10302 University of Kent | SO32724 |  |  |  |  | 5000 |  | 12 |  |  | 4200 |  | 300000 |  |  | 31
 | 7 | NS12955 11ten Group (for [NAME]) | SO32743 |  |  |  |  | 7200 |  | 12 |  |  | 0 |  | 100000 |  |  | 39
 | 8 | NS11470 The University of Queensland | SO32827 |  |  |  |  | 4054.06 |  | 12 |  |  | 9459.46 |  | 500000 |  |  | 31
 | 9 | NS10323 Radboud University Nijmegen | SO33403 |  |  |  |  | 4288.97 |  | 12 |  |  | 0 |  | 50000 |  |  | 39
 | 10 | NS10805 IED Istituto Europeo di Design | SO33564 |  |  |  |  | 4411.76 |  | 12 |  |  | 4288.97 |  | 200000 |  |  | 35
 | 11 | NS00457 University of Edinburgh Business School Scotland | SO33581 |  |  |  |  | 2970 | YES | 12 |  |  |  | HPU, LB | 375000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 900 | 1
 | 12 | NS03786 University of New South Wales UNSW | SO33792 |  |  |  |  | 6756.76 |  | 12 |  |  | 18581.09 |  | 500000 |  |  | 31
 | 13 | NS00874 The Chinese University of Hong Kong | SO33793 |  |  |  |  | 5945.95 |  | 12 |  |  | 6081.08 |  | 200000 |  |  | 35
 | 14 | NS11579 The University of Waikato | SO33806 |  |  |  |  | 6756.76 |  | 12 |  |  | 10135.14 | MPU | 500000 |  |  | 20
 | 15 | NS11767 Australian National University (ANU) | SO33841 |  |  |  |  | 3378.38 |  | 12 |  |  | 5067.57 |  | 250000 |  |  | 35
 | 16 | NS12392 Chalmers University of Technology | SO33886 |  |  |  |  | 7352.94 |  | 12 |  |  | 367.65 |  | 50000 |  |  | 39
 | 17 | NS06276 University of South Australia | SO33931 |  |  |  |  | 3378.38 |  | 12 |  |  | 5067.57 |  | 250000 |  |  | 35
 | 18 | NS02460 Korea University | SO33940 |  |  |  |  | 5202.71 |  | 12 |  |  | 14189.19 |  | 600000 |  |  | 31
 | 19 | NS10297 City University of London | SO34092 |  |  |  |  | 7200 |  | 12 |  |  | 11695.5 |  | 440000 |  |  | 31
 | 20 | [NAME] Jiaotong Liverpool University | SO34492 |  |  |  |  | 3378.38 |  | 12 |  |  | 5067.57 |  | 300000 |  |  | 31
 | 21 | NS03203 Concordia University | SO33536 |  |  |  |  | 4054.06 |  | 12 |  |  | 20270.28 |  | 1000000 |  |  | 31
PROFILE ARTICLES | 1 | NS00297 IE Business School (for IE University) | SO32038 |  |  |  |  | 2261.03 |  | 12 |  |  |  |  |  |  |  |  |  | 2306.25 | YES | 3 |  |  | 1600
 | 2 | NS00297 IE Business School | SO32039 |  |  |  |  | 2261.03 |  | 12 |  |  |  |  |  |  |  |  |  | 2306.25 | YES | 3 |  |  | 1600
 | 3 | NS11016 University of Central Lancashire | SO32152 |  |  |  |  | 7000 |  | 12 |  |  |  |  |  |  |  |  |  | 3400 | YES | 4 |  |  | 1400
 | 4 | NS06343 Royal College of Art | SO33188 |  |  |  |  | 5000 |  | 12 |  |  |  |  |  |  |  |  |  | 3000 |  | 2 |  |  | 1600
 | 5 | NS12485 University of Helsinki | SO33211 |  |  |  |  | 7720.59 |  | 12 |  |  |  |  |  |  |  |  |  | 2941.18 |  | 2 |  |  | 1600
 | 6 | NS10971 Macquarie University | [NAME] |  |  |  |  | 5405.41 |  | 12 |  |  |  |  |  |  |  |  |  | 5405.41 |  | 4 |  |  | 1400
 | 7 | NS12560 Università Vita Salute San Raffaele | SO34346 |  |  |  |  | 3308.82 |  | 12 |  |  |  |  |  |  |  |  |  | 1470.59 |  | 1 |  |  | 1995
PROFILE EMAIL | 1 | NS07571 Geneva Business School | SO32247 |  |  |  |  | 2757.35 |  | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 735.29 | 1000
 | 2 | NS08255 Leonard de Vinci Group | SO32503 |  |  |  |  | 5882.35 |  | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1499.41 | 2549
 | 3 | NS09290 Hong Kong Polytechnic University - Faculty of Business | SO32758 |  |  |  |  | 4375 |  | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3378.38 | 10000
 | 4 | NS11005 Linkoping University. | SO33192 |  |  |  |  | 5882.35 | YES | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 2000
 | 5 | NS10988 Nottingham Trent University - Nottingham Business School | SO33863 |  |  |  |  | 4500 |  | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3150 | 5000
 | 6 | NS11386 Birkbeck University | SO33879 |  |  |  |  | 6000 |  | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5000 | 10000
 | 7 | NS00339 Alliance Manchester Business School | SO33291 |  |  |  |  | 7000 |  | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 1200
BANNERS ARTICLES  EMAIL | 1 | NS08609 The Education University of Hong Kong | SO32526 |  |  |  |  |  |  |  |  |  | 4560.81 |  | 135000 |  |  | 39 |  | 1182.43 |  | 1 |  |  | 1995 |  | 1013.51 | 3000
 | 2 | NS05656 Concordia University - Irvine | SO34438 |  |  |  |  |  |  |  |  |  | 506.76 |  | 50000 |  |  | 39 |  | 506.76 |  | 1 |  |  | 1995 |  | 337.84 | 1200
 | 3 | NS12248 The Swedish Institute | SO34297 |  |  |  |  |  |  |  |  |  | 1562.5 |  | 100000 |  |  | 39 |  | 1562.5 | YES | 1 |  |  | 1995
BANNERS EMAIL | 1 | NS12197 Northern Arizona University | SO33795 |  |  |  |  |  |  |  |  |  | 3939.87 |  | 200000 |  |  | 35 |  |  |  |  |  |  |  |  | 3061.49 | 10000
 | 2 | NS00327 London Business School | SO33803 |  |  |  |  |  |  |  |  |  | 14759 |  | 468536 |  |  | 31 |  |  |  |  |  |  |  |  | 3616 | 6280
 | 3 | NS10065 Erasmus School of Economics | SO34298 |  |  |  |  |  |  |  |  |  | 5492.65 |  | 500000 |  |  | 31 |  |  |  |  |  |  |  |  | 4500 | 8000
 | 4 | NS10337 [NAME] | SO34364 |  |  |  |  |  |  |  |  |  | 3455.88 |  | 150000 |  |  | 35 |  |  |  |  |  |  |  |  | 2058.82 | 2000
 | 5 | NS10323 Radboud University Nijmegen | SO34465 |  |  |  |  |  |  |  |  |  | 1286.76 |  | 50000 |  |  | 39 |  |  |  |  |  |  |  |  | 1286.76 | 2000
 | 6 | NS10684 Monmouth University | SO34495 |  |  |  |  |  |  |  |  |  | 1621.62 |  | 80000 |  |  | 39 |  |  |  |  |  |  |  |  | 827.57 | 1531
 | 7 | NS00327 London Business School | SO33034 |  |  |  |  |  |  |  |  |  | 7329 |  | 232660 |  |  | 35 |  |  |  |  |  |  |  |  | 3616 | 6280
 | 8 | NS01113 Universidad [NAME] Madrid | SO32648 |  |  |  |  |  |  |  |  |  | 1544.12 |  | 70000 |  |  | 39 |  |  |  |  |  |  |  |  | 1371.88 | 3512
BANNERS ARTICLES | 1 | NS10988 Nottingham Trent University - Nottingham Business School | SO33863 |  |  |  |  |  |  |  |  |  | 4500 |  | 250000 |  |  | 35 |  | 1795 | YES | 1 |  |  | 1995
 | 2 | NS11016 University of Central Lancashire | SO33579 |  |  |  |  |  |  |  |  |  | 4200 |  | 200000 |  |  | 35 |  | 5600 |  | 4 |  |  | 1400
BANNERS NEWSLETTER INSERTION | 1 | NS02698 Sungkyunkwan University | SO33580 |  |  |  |  |  |  |  |  |  | 13513.52 |  | 500000 |  |  | 31 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 2
 | 2 | NS02384 Lingnan University | SO33411 |  |  |  |  |  |  |  |  |  | 5250 | [NAME] | 210000 |  |  | 25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1702.7 | 2
ARTICLES EMAIL | 1 | NS08595 WMG University of Warwick | SO33151 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6000 |  | 6 |  |  | 1400 |  | 3250 | 5000
 |  |  |  | no average as only 1 booking
MULTIPLE PROFILES | 1 | NS09730 Laureate International Universities (6 profiles) | SO32553 |  |  |  |  | 60810.24
 | 2 | NS09730 Laureate International Universities (6 profiles) | SO32753 |  |  |  |  | 60810.24
 |  |  |  | I don't know if this is relevant, maybe we should delete it