+ Reply to Thread
Results 1 to 9 of 9

pull a value from a range

Hybrid View

  1. #1
    Forum Expert
    Join Date
    08-27-2008
    Location
    England
    MS-Off Ver
    2010
    Posts
    2,561
    um, I think you need =large(array, k) and possibly =small(array, k) where k is the rank.
    i.e.
    large(array,1) = max(array)
    large(array,2) = second largest of array

    HTH

  2. #2
    Forum Contributor EdMac's Avatar
    Join Date
    01-23-2006
    Location
    Exeter, UK
    MS-Off Ver
    2003
    Posts
    1,264
    I'd go with Charlie there.

    dates are just numbers so you can use large and small and then specify the position you want.
    Ed
    _____________________________
    Always learning, but never enough!
    _____________________________

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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