• MVP Logo
  • Recent Forum Posts


    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 Yesterday, 11:02 AM Go to last post

    Order to rows in the same way

    Copy row 2 to row 1?...

    p45cal 2021-09-18, 12:38 PM Go to last post

    Text formatting

    If your data looks like the following

    Data Range


    alansidman 2021-09-18, 09:39 AM Go to last post

    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 2021-09-18, 09:34 AM Go to last post
    Jake Middleton

    Text formatting

    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 2021-09-18, 07:22 AM Go to last post