• MVP Logo
  • Recent Forum Posts

    AliGW

    Help with Data Validation

    Without FALSE or 0 at the end, VLOOKUP assumes (defaults to) TRUE or 1, which is NOT an exact match (it's an approximate match). It's always best to add...

    AliGW Today, 11:02 AM Go to last post
    p45cal

    Order to rows in the same way

    Copy row 2 to row 1?...

    p45cal Yesterday, 12:38 PM Go to last post
    alansidman

    Text formatting

    If your data looks like the following

    Data Range

    A
    B
    ...

    alansidman Yesterday, 09:39 AM Go to last post
    AliGW

    Text formatting

    Welcome to the forum.

    Select the whole range containing names (A and B) - Data | Sort A>Z.

    Even better: turn the range...

    AliGW Yesterday, 09:34 AM Go to last post
    Jake Middleton

    Text formatting

    Hello,
    If I have a list of names in column "A" and I want to put them in the alphabet order without changing their surnames in column...

    Jake Middleton Yesterday, 07:22 AM Go to last post