+ Reply to Thread
Results 1 to 13 of 13

How do I locate the largest integer in an array?

Hybrid View

  1. 01-15-2009, 05:11 PM #1
    jasoncw
    jasoncw is offline
    Forum Expert
    Join Date
    12-29-2004
    Location
    Michigan, USA
    MS-Off Ver
    2013
    Posts
    2,208
    Whoops. Ignore my previous post. This was posted in the incorrect forum, so I thought it was a VBA array question.
    Reply With QuoteRegister To Reply
  2. 01-15-2009, 05:14 PM #2
    mewingkitty
    mewingkitty is offline
    Forum Contributor mewingkitty's Avatar
    Join Date
    09-29-2008
    Location
    Fort McMurray, Alberta, Canada
    MS-Off Ver
    Excel 2003
    Posts
    949

    hm

    That's odd, gimme a min.

    Was trying to cut out a step, and didn't double-check the effects.

    See attached.

    EDIT
    Ah, thanks Jason, I didn't realize I entered "1" there.
    Attached Files Attached Files
    Last edited by mewingkitty; 01-15-2009 at 05:21 PM.
    =IF(AND(OR(BLONDE,BRUNETTE,REDHEAD),OR(MY PLACE,HER PLACE),ME),BOW-CHICKA-BOW-WOW,ANOTHER NIGHT ON THE INTERNET)
    Reply With QuoteRegister To Reply
  3. 01-15-2009, 05:21 PM #3
    gannon_w
    gannon_w is offline
    Registered User
    Join Date
    11-13-2008
    Location
    Colorado
    Posts
    89
    Mewingkitty & Jason

    Attached is the file...

    The column is AI2:102

    The largest integer is -600 in AI102

    I put your formula in cell AP3 but I got an error.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1