For billionaires with publicly traded fortunes, net worths were calculated using share prices and exchange rates from February 9, 2007. Source, Forbes.com.
Ingvar Kamprad & family Sweden 80 33 $bil Switzerland Self made, Ikea, Retailing 1. The macro is in sheet "ID view". 2. Cells B2, A11, A12, A13, A14, A15 and A16 are "formulas" using the "INDEX worksheet function". 3. The combo box is linked to sheet "DataList". 4. This file and the JPEGs must be saved in the same folder/directory. 5. The JPEGs file must be "renamed" to match the column A cells in "DataList" sheet.
04
: Name : Citizenship : Age : Net Worth ($bil) : Residence : Source/Industry
4 01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20
Name William Gates III Warren Buffett Carlos Slim Helu Ingvar Kamprad & family Lakshmi Mittal Sheldon Adelson Bernard Arnault Amancio Ortega Li Ka-shing David Thomson & family Lawrence Ellison Liliane Bettencourt Prince Alwaleed Bin Talal Alsaud Mukesh Ambani Karl Albrecht Roman Abramovich Stefan Persson Anil Ambani Paul Allen Theo Albrecht
Citizenship United States United States Mexico Sweden India United States France Spain Hong Kong Canada United States France Saudi Arabia India Germany Russia Sweden India United States Germany
Age Net Worth ($bil) 51 56 $bil 76 52 $bil 67 49 $bil 80 33 $bil 56 32 $bil 73 26.5 $bil 58 26 $bil 71 24 $bil 78 23 $bil 49 22 $bil 62 21.5 $bil 84 20.7 $bil 50 20.3 $bil 49 20.1 $bil 87 20 $bil 40 18.7 $bil 59 18.4 $bil 47 18.2 $bil 54 18 $bil 84 17.5 $bil
Residence United States United States Mexico Switzerland United Kingdom United States France Spain Hong Kong Canada United States France Saudi Arabia India Germany United Kingdom Sweden India United States Germany
Source/Industry Self made, Microsoft / Software Self made, Berkshire Hathaway, Investments Telecom Self made, Ikea, Retailing inherited and growing, Steel Manufacturing Self made, casinos, hotel / Gambling, leisure inherited and growing, LVMH / Diversified Self made, Zara / Apparel Diversified inheritance /Media Entertainment Oracle / Software L'Oreal / Manufacturing Investments inherited and growing, Manufacturing Self made / Retailing Self made / Oil Gas Hennes & Mauritz / Retailing Diversified Microsoft, Investments / Software Aldi, Trader Joe's / Retailing