Results 1 to 12 of 12

Max function Based on previous entries criteria pattern till current row

Threaded View

  1. 04-15-2020, 02:23 AM #1
    dorabajji
    dorabajji is offline
    Forum Contributor
    Join Date
    07-10-2019
    Location
    england
    MS-Off Ver
    2013
    Posts
    486

    Max function Based on previous entries criteria pattern till current row

    Hi,
    I want to use max function for variable range.
    Starting row will be based on pattern in Col A and ending row will be current row..
    I have used max if with not correct result and also indirect function for row reference.. i am going wrong..
    want a macro or formula..
    attaching file yellow is the result needed
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« 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 for autocalculating difference based on current and previous day
    By Slightly in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-19-2019, 01:05 AM
  2. [SOLVED] Finding the most current and previous current date based on multiple criteria
    By tkbuc in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-27-2016, 06:06 PM
  3. SUM IF FORMULA BASED ON CURRENT/PREVIOUS/NEXT Month
    By AK123 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 03-21-2016, 01:10 PM
  4. Average of previous 6 entries with 2 criteria using date.
    By ayrmad in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-24-2013, 07:47 PM
  5. Average function to count till current month !!!
    By sonu1975 in forum Excel General
    Replies: 5
    Last Post: 05-11-2012, 07:44 AM
  6. Sum based on Current Week, Previous Weeks vs. Current Week Forward
    By cjsec9 in forum Excel General
    Replies: 4
    Last Post: 03-21-2011, 05:37 PM
  7. using data till till the current row
    By nilu8603 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-26-2010, 04:30 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