+ Reply to Thread
Results 1 to 3 of 3

Some handy Personal Macros: Text version of the Large Function

  1. #1
    Forum Expert GeneralDisarray's Avatar
    Join Date
    09-15-2011
    Location
    Pittsburgh, PA, USA
    MS-Off Ver
    Windows Excel 2007/2010/2013
    Posts
    1,416

    Some handy Personal Macros: Text version of the Large Function

    These are just some neat tricks which come in handy sometimes. I keep these as personal macros for use when needed.

    1) TextLarge - This acts just like the large() worksheet function, but on text values. Helpful for unsorted list sometimes (in truth made it for someone at the forum, don't use it much myself).

    For example (figure1) if you have an unsorted list of names you can call on TextLarge(TextValuesRange,Rank) to return the first ranked name, second ranked name, etc. (as in figure)

    Name:  fig1_textLargeExample.GIF
Views: 97
Size:  11.6 KB

    Macro for textLarge:

    Please Login or Register  to view this content.
    Remember, saying thanks only takes a second or two. Click the star icon(*) below the post you liked, to give some Rep if you think an answer deserves it.

    Please,mark your thread [SOLVED] if you received your answer.

  2. #2
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,643

    Re: Some handy Personal Macros: Text version of the Large Function

    or
    Please Login or Register  to view this content.



  3. #3
    Forum Expert GeneralDisarray's Avatar
    Join Date
    09-15-2011
    Location
    Pittsburgh, PA, USA
    MS-Off Ver
    Windows Excel 2007/2010/2013
    Posts
    1,416

    Re: Some handy Personal Macros: Text version of the Large Function

    very neat, short, and sweet

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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