Posts by Mike91

    Hello I need help with this please. If I have in column A:

    in cell A2: 77.123456789;88.12345678;122;100.1;MMMM
    in cell A3: 11.123456789;33.12345678;50;100.1;VVVV
    in cell A4: 70.123456789;89.12345678;251;100.1;HHHH
    in cell A5: 22.123456789;99.12345678;72;100.1;DDDD

    In cell B2 I want an average of these numbers from A2:A5 rows: 122, 50, 251, 72.

    I find this formula:

    =MID(SUBSTITUTE(A2,";"," "),31,3)

    But this formula can extract the number of only one row.