Results 1 to 2 of 2

function for finding largest value from cell that are not in array

Threaded View

  1. #1
    Registered User
    Join Date
    03-29-2004
    Location
    vadodara, gujarat, india
    Posts
    80

    function for finding largest value from cell that are not in array

    function for finding largest value from cell that are not in array

    I have to find out the largest value from a line (single row and a single column where the values to be considered(each) are 4 cells apart. and the in between cells cant be included.
    I am using LARGE and SMALL function but that considers only array.

    + I want to extract data that is in the adjacent cell to that
    eg
    a1 100000
    b1 50000
    c1 50 (b1% of a1)
    d1 507

    e1 200000
    f1 50000
    g1 25 (f1% of e1)
    h1 500
    so answer should be
    i1 (larger of c1 and gi)
    j1 (smaller of d1 and h1)
    Last edited by DonkeyOte; 02-03-2011 at 07:32 AM. Reason: Mod: mail address removed

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