EXCEL: How to find 2nd largest value in a dataset; How to find nth largest value in excel.
EXCEL: How to find 2nd largest value in a dataset; How to find nth largest value in excel.
Data set: please refer below.
Country Population
#Afghanistan 38928346
#Albania 2877797
#Algeria 43851044
#AmericanSamoa 55191
#Andorra 77265
#Angola 32866272
#Anguilla 15003
#AntiguaandBarbuda 97929
#Argentina 45195774
#Armenia 2963243
#Aruba 106766
#Australia 25499884
#Austria 9006398
#Azerbaijan 10139177
#Bahamas 393244
#Bahrain 1701575
#Bangladesh 164689383
#Barbados 287375
#Belarus 9449323
#Belgium 11589623
#Belize 397628
#Benin 12123200
#Bermuda 62278
#Bhutan 771608
#Bolivia 11673021
#BosniaandHerzegovina 3280819
#Botswana 2351627
#Brazil 212559417
#BritishVirginIslands 30231
#Brunei 437479
#Bulgaria 6948445
#BurkinaFaso 20903273
#Burundi 11890784
#CaboVerde 555987
#Cambodia 16718965
#Cameroon 26545863
#Canada 37742154
#CaribbeanNetherlands 26223
#CaymanIslands 65722
#CentralAfricanRepublic 4829767
#Chad 16425864
#ChannelIslands 173863
#Chile 19116201
#China 1439323776
#Colombia 50882891
#Comoros 869601
#Congo 5518087
#CookIslands 17564
#CostaRica 5094118
#Côted'Ivoire 26378274
#Croatia 4105267
#Cuba 11326616
#Curaçao 164093
#Cyprus 1207359
#CzechRepublic(Czechia) 10708981
#Denmark 5792202
#Djibouti 988000
#Dominica 71986
#DominicanRepublic 10847910
#DRCongo 89561403
#Ecuador 17643054
#Egypt 102334404
#ElSalvador 6486205
#EquatorialGuinea 1402985
#Eritrea 3546421
#Estonia 1326535
#Eswatini 1160164
#Ethiopia 114963588
#FaeroeIslands 48863
#FalklandIslands 3480
#Fiji 896445
#Finland 5540720
#France 65273511
#FrenchGuiana 298682
#FrenchPolynesia 280908
#Gabon 2225734
#Gambia 2416668
#Georgia 3989167
#Germany 83783942
#Ghana 31072940
#Gibraltar 33691
#Greece 10423054
#Greenland 56770
#Grenada 112523
#Guadeloupe 400124
#Guam 168775
#Guatemala 17915568
#Guinea 13132795
#Guinea-Bissau 1968001
#Guyana 786552
#Haiti 11402528
#HolySee 801
#Honduras 9904607
#HongKong 7496981
#Hungary 9660351
#Iceland 341243
#India 1380004385
#Indonesia 273523615
#Iran 83992949
#Iraq 40222493
#Ireland 4937786
#IsleofMan 85033
#Israel 8655535
#Italy 60461826
#Jamaica 2961167
#Japan 126476461
#Jordan 10203134
#Kazakhstan 18776707
#Kenya 53771296
#Kiribati 119449
#Kuwait 4270571
#Kyrgyzstan 6524195
#Laos 7275560
#Latvia 1886198
#Lebanon 6825445
#Lesotho 2142249
#Liberia 5057681
#Libya 6871292
#Liechtenstein 38128
#Lithuania 2722289
#Luxembourg 625978
#Macao 649335
#Madagascar 27691018
#Malawi 19129952
#Malaysia 32365999
#Maldives 540544
#Mali 20250833
#Malta 441543
#MarshallIslands 59190
#Martinique 375265
#Mauritania 4649658
#Mauritius 1271768
#Mayotte 272815
#Mexico 128932753
#Micronesia 548914
#Moldova 4033963
#Monaco 39242
#Mongolia 3278290
#Montenegro 628066
#Montserrat 4992
#Morocco 36910560
#Mozambique 31255435
#Myanmar 54409800
#Namibia 2540905
#Nauru 10824
#Nepal 29136808
#Netherlands 17134872
#NewCaledonia 285498
#NewZealand 4822233
#Nicaragua 6624554
#Niger 24206644
#Nigeria 206139589
#Niue 1626
#NorthKorea 25778816
#NorthMacedonia 2083374
#NorthernMarianaIslands 57559
#Norway 5421241
#Oman 5106626
#Pakistan 220892340
#Palau 18094
#Panama 4314767
#PapuaNewGuinea 8947024
#Paraguay 7132538
#Peru 32971854
#Philippines 109581078
#Poland 37846611
#Portugal 10196709
#PuertoRico 2860853
#Qatar 2881053
#Réunion 895312
#Romania 19237691
#Russia 145934462
#Rwanda 12952218
#SaintBarthelemy 9877
#SaintHelena 6077
#SaintKitts&Nevis 53199
#SaintLucia 183627
#SaintMartin 38666
#SaintPierre&Miquelon 5794
#Samoa 198414
#SanMarino 33931
#SaoTome&Principe 219159
#SaudiArabia 34813871
#Senegal 16743927
#Serbia 8737371
#Seychelles 98347
#SierraLeone 7976983
#Singapore 5850342
#SintMaarten 42876
#Slovakia 5459642
#Slovenia 2078938
#SolomonIslands 686884
#Somalia 15893222
#SouthAfrica 59308690
#SouthKorea 51269185
#SouthSudan 11193725
#Spain 46754778
#SriLanka 21413249
#St.Vincent&Grenadines 110940
#StateofPalestine 5101414
#Sudan 43849260
#Suriname 586632
#Sweden 10099265
#Switzerland 8654622
#Syria 17500658
#Taiwan 23816775
#Tajikistan 9537645
#Tanzania 59734218
#Thailand 69799978
#Timor-Leste 1318445
#Togo 8278724
#Tokelau 1357
#Tonga 105695
#TrinidadandTobago 1399488
#Tunisia 11818619
#Turkey 84339067
#Turkmenistan 6031200
#TurksandCaicos 38717
#Tuvalu 11792
#U.S.VirginIslands 104425
#Uganda 45741007
#Ukraine 43733762
#UnitedArabEmirates 9890402
#UnitedKingdom 67886011
#UnitedStates 331002651
#Uruguay 3473730
#Uzbekistan 33469203
#Vanuatu 307145
#Venezuela 28435940
#Vietnam 97338579
#Wallis&Futuna 11239
#WesternSahara 597339
#Yemen 29825964
#Zambia 18383955
#Zimbabwe 14862924