Reverse HLookup

saiyamvora13

New Member
Joined
Apr 3, 2015
Messages
32
Hello, please help. I am guessing I can use index and match here, but for some reason I am not getting the right formula.
Here is my data
I need to find the Max number on the bottom row and once I have the max number on that row, I need the corresponding value of the cell that is in the top row and same column of that max number.

Please help

00.010.020.030.040.050.060.070.080.090.10.110.120.130.140.150.160.170.180.190.20.210.220.230.240.250.260.270.280.290.30.310.320.330.340.350.360.370.380.390.40.410.420.430.440.450.460.470.480.490.50.510.520.530.540.550.560.570.580.590.60.610.620.630.640.650.660.670.680.690.70.710.720.730.740.750.760.770.780.790.80.810.820.830.840.850.860.870.880.890.90.910.920.930.940.950.960.970.980.991
0.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.670.680.690.70.710.720.730.740.750.760.770.780.790.80.810.820.830.840.850.8600000000000000
0.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.80.810.820.830.840.850.860.870.880.890.90.910.920.930.940.950.960.970.980.991
0.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.390.40.410.420.430.440.450.460.470.480.490.50.510.520.530.540.550.560.570.580.5900000000000000000000000000000000000000000
0.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.860.870.880.890.90.91000000000
0.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.750.760.770.780.790.80.810.820.830.840.85000000000000000
0.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.60.610.620.630.640.650.660.670.680.690.7000000000000000000000000000000
0.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.660.670.680.690.70.710.720.730.740.750.760.770.780.790.80.810.820.830.840.850.860.870.88000000000000
0.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.50.510.520.530.540.550.560.570.580.590.60.610.620.630.640.650.660.670.680.690.70.710.720.730.740.750.760.770.780.790.80.810.820.830.840.850.860.870.88000000000000
0.680.680.680.680.680.680.680.680.680.680.680.680.680.680.680.680.680.680.680.680.680.680.680.680.680.680.680.680.680.680.680.680.680.680.680.680.680.680.680.680.680.680.680.680.680.680.680.680.680.680.680.680.680.680.680.680.680.680.680.680.680.680.680.680.680.680.680.680.680.690.70.710.720.730.740.750.760.770.780.790.80.810.820.830.840.850.860.870.880.890.90.910.920.930.94000000
0.160.160.160.160.160.160.160.160.160.160.160.160.160.160.160.160.160.170.180.190.20.210.22000000000000000000000000000000000000000000000000000000000000000000000000000000
0.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.470.480.490.50.510.520.530.540.550.560.570.580.590.60.610.620.630.640.650.660.670.680.690.70.710.720.730.740.750.760.7700000000000000000000000
0.310.310.310.310.310.310.310.310.310.310.310.310.310.310.310.310.310.310.310.310.310.310.310.310.310.310.310.310.310.310.310.310.320.330.340.350.360.370.380.390.40.410.420.430.440.450.46000000000000000000000000000000000000000000000000000000
0.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.820.830.840.850.860.870000000000000
0.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.550.560.570.580.590.60.610.620.630.640.650.660.670.680.690.70.710.720.730.740.750.760.770.780.790.80.810.820.830.840.850.860.870.880.890.90.910.920.930.940.950.960000
0.580.580.580.580.580.580.580.580.580.580.580.580.580.580.580.580.580.580.580.580.580.580.580.580.580.580.580.580.580.580.580.580.580.580.580.580.580.580.580.580.580.580.580.580.580.580.580.580.580.580.580.580.580.580.580.580.580.580.580.590.60.610.620.630.640.650.660.670.680.690.70.710.720.730.740.750.760.770.780.790.80.810.820.830.840.850.860.870.880.8900000000000
0.760.760.760.760.760.760.760.760.760.760.760.760.760.760.760.760.760.760.760.760.760.760.760.760.760.760.760.760.760.760.760.760.760.760.760.760.760.760.760.760.760.760.760.760.760.760.760.760.760.760.760.760.760.760.760.760.760.760.760.760.760.760.760.760.760.760.760.760.760.760.760.760.760.760.760.760.760.770.780.790.80.810.820.830.840.850.860.870.880.890.90.910.920.930.94000000
0.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.530.540.550.560.570000000000000000000000000000000000000000000
0.290.290.290.290.290.290.290.290.290.290.290.290.290.290.290.290.290.290.290.290.290.290.290.290.290.290.290.290.290.290.30.310.320.330.340.350.360.370.380.390.40.410.420.430.440.450.460.470.480.490.50.510.520.530.540.550.560.570.580.590.60.610.620.630.640.650.660.670.6800000000000000000000000000000000
0.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.470.480.490.50.510.520.530.540.550.560.570.580.590.60.610.620.630.640.650.660.670.680.690.70.710.720000000000000000000000000000
0.620.620.620.620.620.620.620.620.620.620.620.620.620.620.620.620.620.620.620.620.620.620.620.620.620.620.620.620.620.620.620.620.620.620.620.620.620.620.620.620.620.620.620.620.620.620.620.620.620.620.620.620.620.620.620.620.620.620.620.620.620.620.620.630.640.650.660.670.680.690.70.710.720.730.740.750.760.770.780.790.80.810.820.830.840.850.860.870.880.890.90000000000
0.120.120.120.120.120.120.120.120.120.120.120.120.120.130.140.150.160.170.180.190.20.210.220.230.240.250.260.270.280.290.30.310.320.330.340.350.360.370.380.390.40.410.420000000000000000000000000000000000000000000000000000000000
0.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.620.630.640.650.660.670.680.690.70.710.720.730.740.750.760.770.780.79000000000000000000000
0.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.740.750.760.770.780.790.80.810.820.830.840.850.860.870.880.890.90.910.920.930.940.950.960000
0.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.880.890.90.910.920.930.940.950.960000
0.770.770.770.770.770.770.770.770.770.770.770.770.770.770.770.770.770.770.770.770.770.770.770.770.770.770.770.770.770.770.770.770.770.770.770.770.770.770.770.770.770.770.770.770.770.770.770.770.770.770.770.770.770.770.770.770.770.770.770.770.770.770.770.770.770.770.770.770.770.770.770.770.770.770.770.770.770.770.780.790.80.810.820.830.840.850.8600000000000000
0.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.730.740.750.760.770.780.790.80.810.820.830.840.850.860.870.880.890.90.910.920.930.940.950.960000
0.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.940.9500000
0.280.280.280.280.280.280.280.280.280.280.280.280.280.280.280.280.280.280.280.280.280.280.280.280.280.280.280.280.280.290.30.310.320.330.340.350.360.370.380.390.40.410.420.430.440.450.460.470.480.490.50.510.520.530.540.550.560.570.580.590.60.610.620.630.640.650.660.670.680.690.70.710.720.730.740.750.760.770.780.790.80.810.820.830.840.850.860.870.880.890.90.910.920.930.940.950.960.97000
0.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.470.480.490.50.510.520.530.540.550.560.570.580.590.60.610.620.630.640.650.660.670.680.690.70.710.720.730.740.750.760.770.780.790.80.810.820.830.840.85000000000000000
0.450.450.450.450.450.450.450.450.450.450.450.450.450.450.450.450.450.450.450.450.450.450.450.450.450.450.450.450.450.450.450.450.450.450.450.450.450.450.450.450.450.450.450.450.450.450.460.470.480.490.50.510.520.530.540.550.560.570000000000000000000000000000000000000000000
0.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.85000000000000000
0.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.550.560.570.580.590.60.610.620.630.640.650.660000000000000000000000000000000000
0.70.70.70.70.70.70.70.70.70.70.70.70.70.70.70.70.70.70.70.70.70.70.70.70.70.70.70.70.70.70.70.70.70.70.70.70.70.70.70.70.70.70.70.70.70.70.70.70.70.70.70.70.70.70.70.70.70.70.70.70.70.70.70.70.70.70.70.70.70.70.70.710.720.730.740.750.760.770.780.790.80.810.820.830.840.850.860.870.880.890.90.910.9200000000
0.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.850.860.870.880.890.90.910.920.930.940.950.960000
0.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.470.480.490.50.510.520.530.540.550.560.570.580.590.60.610.620.630.640.650.660.670.680.690.70.710.720.730.740.750.760.770.780.790.80.810.820.830.840.850.860.870.880.890.90.910.920.930000000
0.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.540.550.560.570.580.590.60.610.620.630.640.650.660.670.680.690.70.710.720.730.740.750000000000000000000000000
0.20.20.20.20.20.20.20.20.20.20.20.20.20.20.20.20.20.20.20.20.20.210.220.230.240.250.260.270.280.290.30.310.320.330.340.3500000000000000000000000000000000000000000000000000000000000000000
0.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.590.60.610.620.630.640.650.660.670.680.690.70.710.720.730.740.750.760.770.780.790.80.810.820.830.840.850.860.870.88000000000000
0.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.890.90.910.920.930.940.950.960.97000
0.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.840.850.8600000000000000
0.420.420.420.420.420.420.420.420.420.420.420.420.420.420.420.420.420.420.420.420.420.420.420.420.420.420.420.420.420.420.420.420.420.420.420.420.420.420.420.420.420.420.420.430.440.450.460.470.480.490.50.510.520.530.540.550.560.570000000000000000000000000000000000000000000
0.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.850.860.870.880.890.90.910.920.930.94000000
0.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.390.40.410.420.430.440.450.460.470.480.490.50.510.520.530.540.550.560.570.580.590.60.610.6200000000000000000000000000000000000000
0.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.720000000000000000000000000000
0.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.550.560.570.580.590.60.610.620.630.640.650.660.670.680.690.70.710.720.730.740.750.760.770.780.790.80.810.820.830.840000000000000000
0.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.390.40.410.420.430.440.450.460.470.480.490.50.510.520.530.540.550.560.570.580.590.60.610.620.630.640.650.660.670.680.690.70.710.720.730.740.750.760.770.780.790.80.810.820.830.840.850.860.870000000000000
0.630.630.630.630.630.630.630.630.630.630.630.630.630.630.630.630.630.630.630.630.630.630.630.630.630.630.630.630.630.630.630.630.630.630.630.630.630.630.630.630.630.630.630.630.630.630.630.630.630.630.630.630.630.630.630.630.630.630.630.630.630.630.630.630.640.650.660.670.680.690.70.710.720.730.740.750.760.770.780.790.80.810.820.830.840000000000000000
0.450.450.450.450.450.450.450.450.450.450.450.450.450.450.450.450.450.450.450.450.450.450.450.450.450.450.450.450.450.450.450.450.450.450.450.450.450.450.450.450.450.450.450.450.450.450.460.470.480.490.50.510.520.530.540.550.560.570.580.590.60.610.620.630.640.650.660.67000000000000000000000000000000000
0.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.820.830.840.850.860.870.880.890.90000000000
0.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.730.740.750.760.770.780.790.80.810.820.830.840.850.860.870.880.890.90.910.920.930.940.950.960.970.980.990
0.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.850.860.870.880.890.90.910.920.930.940.950.960.970.980.990
0.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.520.530.540.550.560.570.580.590.60.610.620.630.640.650.660.670.680.690.70.710.720.730.740.750.760.770.780.790.80.810.820.830.840.850.860.870000000000000
0.350.350.350.350.350.350.350.350.350.350.350.350.350.350.350.350.350.350.350.350.350.350.350.350.350.350.350.350.350.350.350.350.350.350.350.350.360.370.380.390.40.410.420.430.440.450.460.470.480.490.50.510.520.530.540.550.560.570.580.590.60.610.620.630.640.650.660.670.6800000000000000000000000000000000
0.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.470.480.490.50.510.520.530.540.550.560.570.580.590.60.610.620.630.640.650.660.670.680.690000000000000000000000000000000
0.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.940.9500000
0.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.730.740.750.760.770.780.790.80.810.820.830.840.850.860.870.880.890.90.910.920.930.94000000
0.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.620.630.640.650.660.670.680.690.70.710.720.730.740.750.760.770.780.790.80.810.820.830.840.850.860.870000000000000
0.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.620.630.640.650.660.670.680.690.70.710.720.730.740.750.760.770.780.790.80.810.820.830.840.850.8600000000000000
0.570.570.570.570.570.570.570.570.570.570.570.570.570.570.570.570.570.570.570.570.570.570.570.570.570.570.570.570.570.570.570.570.570.570.570.570.570.570.570.570.570.570.570.570.570.570.570.570.570.570.570.570.570.570.570.570.570.570.580.590.60.610.620.630.640.650.660.67000000000000000000000000000000000
0.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.61000000000000000000000000000000000000000
0.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.760.7700000000000000000000000
0.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.950.960.97000
0.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.460.470.480.490.50.510.520.530.540.550.560.570.580.590.60.610.620.630.640.650.660.670.680.690.70.710.720.730.740.750.760.770.780.790.80.810.820.830.840.850.860.870.880.890.90.910.920.930.940.9500000
0.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.670.680.690.70.710.720.730.740.750.760.770.780.790.80.810.820.830.840.850.860.870.880.890.90.910.920.930.940.950.960.97000
0.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.820.830.840.850.860.870.880.890.90000000000
0.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.750.760.770.780.790.80.810.820.830.840.850.860.870.88000000000000
0.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.750.760.770.780.790.80.810.820.830.840.850.860.870.880.890.90.91000000000
0.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930.930000000
0.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.660.670.680.690.70.710.720.730.740.750000000000000000000000000
0.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.620.630.640.650.660.67000000000000000000000000000000000
0.50.50.50.50.50.50.50.50.50.50.50.50.50.50.50.50.50.50.50.50.50.50.50.50.50.50.50.50.50.50.50.50.50.50.50.50.50.50.50.50.50.50.50.50.50.50.50.50.50.50.50.510.520.530.540.550.560.570.580.590.60.610.620.630.640.650.660.670.6800000000000000000000000000000000
0.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.530.540.550.5600000000000000000000000000000000000000000000
0.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.840.850.860.870.880.890.90.910.920.930.940.950.960.970.9800
0.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.520.530.540.550.560.570.580.590.60.610.620.630.640.650.660.670.680.690.70.710.720.730.740.750.760.770.780.790.80.810.820.830.840.850.860.870.88000000000000
0.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.830.840.850.860.870.880.8900000000000
0.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.810.820.830.840.850.860.870.880.8900000000000
0.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.530.540.550.560.570.580.590.60.610.620.630.640.650.660.670.680.690.70.710.720.730.7400000000000000000000000000
0.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.660.670.680.690.70.710.720.730.740.750000000000000000000000000
0.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.790.80.810.820.830.840.850.860.870.880.8900000000000
0.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.720.730.740.750.760.770.780.790.80.810.820.830.840.850.860.870.880.890.90.91000000000
0.310.310.310.310.310.310.310.310.310.310.310.310.310.310.310.310.310.310.310.310.310.310.310.310.310.310.310.310.310.310.310.310.320.330.340.350.360.370.380.390000000000000000000000000000000000000000000000000000000000000
0.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.550.560.570.580.590.60.610.620.630.640.650.660.670.680.690.70.710.720.730.740.750.760.770.780.790.80.810.820.830.840.850.860.870.880.890.90.910.9200000000
0.440.440.440.440.440.440.440.440.440.440.440.440.440.440.440.440.440.440.440.440.440.440.440.440.440.440.440.440.440.440.440.440.440.440.440.440.440.440.440.440.440.440.440.440.440.450.460.470.480.490.50.510.520.530.540.550.5600000000000000000000000000000000000000000000
0.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.520.530.540.550.560.570.580.590.60.610.620.630.640.650.660.670.680.690.70.710.720.730.740.750.760.770.780.790.80.810.820.830.840.850.860.870.880.890.90.910.920.930.940.950.960000
0.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.560.570.580.590.60.610.620.630.64000000000000000000000000000000000000
0.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.650.660.670.680.690.70.710.720.730.740.750.760.770.780000000000000000000000
0.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.650.660.670.680.690.70.710.720.730.740.750.760.770.780.79000000000000000000000
0.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.740.750.760.770.780000000000000000000000
0.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.550.560.570.580.590.60.610.620.630.640.650.660.670.680.690.70.710.720.730.740.750.760.770.780.790.800000000000000000000
0.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.620.630.640.650.660.670.680.690.70.710.720.730.740.750.760.770.780.790.80.810.820.830.840.850.860.870.880.890.90.910.9200000000
0.560.560.560.560.560.560.560.560.560.560.560.560.560.560.560.560.560.560.560.560.560.560.560.560.560.560.560.560.560.560.560.560.560.560.560.560.560.560.560.560.560.560.560.560.560.560.560.560.560.560.560.560.560.560.560.560.560.570.580.590.60.610.620.630.640.650.660.670.680.690.70.710.720.730.740.750.760.770.780.790.80.810.820.830.840.850.860.870.880.890.90.910.920.930.940.950.960000
0.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.640.650.660.670.680.690.70.710.720.730.740.750.760.770.780.790.80.810.820.830.840.850.860.870.88000000000000
0.60.60.60.60.60.60.60.60.60.60.60.60.60.60.60.60.60.60.60.60.60.60.60.60.60.60.60.60.60.60.60.60.60.60.60.60.60.60.60.60.60.60.60.60.60.60.60.60.60.60.60.60.60.60.60.60.60.60.60.60.60.610.620.630.640.650.660.670.6800000000000000000000000000000000
0.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.710.720.730.740.750.760.770.780.790.80.810.820.830.840.850.860.870.880.890.90000000000
0.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.780.790.80.810.820.830.840.850.860.870.880.890.90000000000
0.420.420.420.420.420.420.420.420.420.420.420.420.420.420.420.420.420.420.420.420.420.420.420.420.420.420.420.420.420.420.420.420.420.420.420.420.420.420.420.420.420.420.420.430.440.450.460.470.480.490.50.510.520.530.540.550.560.570.580.590.60.610.620.630.640.650.660.670.680.690.70.710.720000000000000000000000000000
0.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.510.520.530.540.55000000000000000000000000000000000000000000000
0.430.430.430.430.430.430.430.430.430.430.430.430.430.430.430.430.430.430.430.430.430.430.430.430.430.430.430.430.430.430.430.430.430.430.430.430.430.430.430.430.430.430.430.430.4400000000000000000000000000000000000000000000000000000000
0.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.540.550.560.570.580.590.60.610.620.630.640.650.660.670.680.690.70.710.720.730.740.750.760.770.780.790.80.810.820.830.840.850.860.870000000000000
0.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.490.50.510.520.530.540.550.560.570.580.590.60.61000000000000000000000000000000000000000
61.0861.0861.0861.0861.0861.0861.0861.0861.0861.0861.0861.0861.0861.0961.161.1161.1261.1461.1661.1861.261.2361.2661.0661.0861.161.1261.1461.1661.1961.2361.2761.3361.3961.4561.5161.2261.2861.3461.4361.1261.261.2860.9561.0560.7160.8360.5460.7160.8861.0761.2761.561.7662.0462.3762.1661.3759.9760.2960.0360.3759.5359.2959.6859.4459.8759.6658.0755.7455.4355.1155.5253.7654.1853.8852.0652.551.3950.2649.0948.749.1549.650.0748.8846.843.839.8434.931.6527.4124.9122.3520.6917.114.47.763.922.971

<colgroup><col width="72" span="101" style="width:54pt"> </colgroup><tbody>
</tbody>
 

Some videos you may like

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
46,918
Office Version
  1. 365
Platform
  1. Windows
.. and if that maximum number happens to occur twice (or three or ten times etc) on the bottom row what do you want to happen?
 

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,201
In A100 control+shift+enter and copy down:
Rich (BB code):
=IFERROR(INDEX($A$1:$CW$1,SMALL(IF($A$2:$CW$101=MAX($A$2:$CW$101),
    COLUMN($A$2:$CW$101)-COLUMN($A$2)+1),ROWS($A$110:A110))),"")

Total row (i.e. row 102) is excluded.
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
46,918
Office Version
  1. 365
Platform
  1. Windows
To return all headings, my reading of it would be, for total row being row 102 and formula in A110 and copied down (also confirmed with Ctrl+Shift+Enter

=IFERROR(INDEX(A$1:CW$1,SMALL(IF(A$102:CW$102=MAX(A$102:CW$102),COLUMN(A$1:CW$1)-COLUMN(A$1)+1),ROWS(A$110:A110))),"")


If it is not possible with your data to have multiples of the MAX value in the bottom row, or you were happy to have the top value from the first of multiple occurrences, then this standard entry formula should suffice.

=INDEX(A1:CW1,MATCH(MAX(A102:CW102),A102:CW102,0))
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,114,652
Messages
5,549,210
Members
410,905
Latest member
Extjel
Top