+ Reply to Thread
Results 1 to 7 of 7

pass the range number in formula

Hybrid View

  1. 10-03-2020, 04:19 AM #1
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,099

    Re: pass the range number in formula

    Try
    Formula: copy to clipboard 
    =MAX(INDEX(J:J, A2):INDEX(J:J, B2))


    Note: A2 and B2 must both contain non-blank, non-zero, non-negative numeric values.
    Last edited by TMS; 10-03-2020 at 04:22 AM.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  2. 10-03-2020, 04:32 AM #2
    ELGendi
    ELGendi is offline
    Registered User
    Join Date
    10-03-2020
    Location
    Istanbul
    MS-Off Ver
    2016
    Posts
    19

    Re: pass the range number in formula

    PERFECT ,,, YOU ARE THE MAN

    Thanks a BILLION
    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)

Similar Threads

  1. [SOLVED] Formula that looks in range and returns Pass if all cells contain Ps
    By Jamidd1 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-19-2017, 08:44 AM
  2. How to pass cell Value as String in VBA Formula - Avoid them to become as range
    By lavi in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-28-2015, 09:13 AM
  3. Conditional Formating (Pass,Fail and Highlight) Cell Range witl rules for a range of cells
    By kpatel4 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-12-2015, 02:47 AM
  4. Move to next decimal in range and pass row number
    By beenbee in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-20-2014, 07:17 AM
  5. Use if statement for a range +4 and -4 and write PASS / NOT PASS
    By alexistkd in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-05-2013, 07:11 PM
  6. How concate the string with number in Excel to pass in Range
    By dhurva in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-04-2010, 11:17 AM
  7. How to pass a Named Range from a cell as an argument to a formula
    By Orson100 in forum Excel General
    Replies: 4
    Last Post: 10-20-2009, 10:00 AM

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