+ Reply to Thread
Results 1 to 2 of 2

MoreFunc - Vsort

  1. #1
    Registered User
    Join Date
    02-12-2010
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    38

    MoreFunc - Vsort

    Hi all

    I'm playing around with the vsort function from Morefunc and wondering if/where do I add in a concatenate to add in the surname.

    See attached file. I've vsorted the first names, but now I need to add in the surname to the same cell once sorted.

    Thanks in advance.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    02-12-2010
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    38

    Re: MoreFunc - Vsort

    Never mind. Solved it myself.

    {=CONCATENATE(VSORT($A$3:$A$13,,1)," ",VLOOKUP(VSORT($A$3:$A$13,,1),$A$3:$B$13,2,FALSE))}

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] MOREFUNC
    By nemadrias in forum Excel General
    Replies: 2
    Last Post: 06-26-2006, 12:00 PM
  2. Morefunc VSort with array of long output
    By RB Smissaert in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-12-2006, 12:10 PM
  3. [SOLVED] Morefunc
    By Becks in forum Excel General
    Replies: 3
    Last Post: 04-25-2006, 10:25 AM
  4. Morefunc
    By Dave 2005 in forum Excel General
    Replies: 1
    Last Post: 11-08-2005, 07:20 PM
  5. [SOLVED] Syntax Laurent Longre's Morefunc VSORT with arrays?
    By RB Smissaert in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-10-2005, 04:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1