• MVP Logo
  • Recent Forum Posts

    RET

    ThatNewGuy question - updating sheets

    It should be range

    Dim xxxx as Range...

    RET Yesterday, 08:16 PM Go to last post
    Bob Phillips

    Please help!

    If you do want formulae., these do it

    J2: =COUNTA(A$2:A$22)
    J3: =COUNTA(B$2:B$22)
    etc.

    K2: =SUM(IF(A$2:A$22"",--SUBSTITUTE(MID(A$2:A$22,FIND("(",A$2:A$22)+1,99),")","")))...

    Bob Phillips Yesterday, 07:54 PM Go to last post
    Pecoflyer

    Please help!

    @cprop
    Hi
    in the future please a more descriptive thread title instead of " please help".
    Thanks...

    Pecoflyer Yesterday, 05:24 PM Go to last post
    p45cal

    Please help!

    Aagh. Beaten to it!
    Power Query solution at cell H10.
    Update the data in the table at cell A1 then right-click the result table and choose...

    p45cal Yesterday, 11:27 AM Go to last post
    alansidman

    Please help!

    A Power Query solution:

    Code:
    let
        Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
        #"Unpivoted Columns"
    ...

    alansidman Yesterday, 10:39 AM Go to last post