• MVP Logo
  • Recent Forum Posts

    Hercules1946

    Delete Specific Text from Column of Cells

    It would appear that your data is uniform in layout, but might you have a line with 2 characters to remove (e.g. RM), and also a ZZ+number to remain?...

    Hercules1946 Yesterday, 11:38 PM Go to last post
    jcsc83ph

    Rename the pictures using excel

    Hi Guys,

    I need your help. I'm using mac. I try to figured out for this code for change the old names of picture to new name.

    ...

    jcsc83ph Yesterday, 09:53 PM Go to last post
    thk12205

    Setting Up Names in a Table as Row Label

    Excel Version: Microsoft Office Professional Plus 2013

    I'm trying to count the number of times a name is assigned to a group/role from a...

    thk12205 Yesterday, 09:46 PM Go to last post
    p45cal

    data anlysis

    In row 2, say column W, this formula array-entered (that's Shift+Ctrl+Enter, not just Enter):
    =DATEDIF(INDEX($A2:$K2,MAX(($L2:$U2="LARC")*(COLUMN(L2:U2)))-10),V2,"M")...

    p45cal Yesterday, 08:34 PM Go to last post
    NoS

    Help with Sorting Data Please

    Code:
    Sub FishCount()
        With Sheets("catch-return")
            For r = 2 To .Range("A1").End(xlDown).Row
    ...

    NoS Yesterday, 07:51 PM Go to last post