Results 1 to 7 of 7

Large Function with Multiple Ranges

Threaded View

  1. #1
    Registered User
    Join Date
    12-30-2009
    Location
    Florida
    MS-Off Ver
    Excel 2007
    Posts
    43

    Large Function with Multiple Ranges

    I am trying to use the large function over two ranges. Even though incorrect I will include my original formula that doesn't work to help illustrate.

    if(large((L20:L500,W20:W500),1)=I20,$P$4,if((large((L20:L500,W20:W500),2)=I20,$P$5,0)))

    Does anybody know of an easy way around this?
    Last edited by TYork; 02-01-2010 at 02:55 PM.

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