Results 1 to 9 of 9

Reversing large-if array formula

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-10-2015
    Location
    the Dysfunctional Empire of Bulgaria
    MS-Off Ver
    2010
    Posts
    102

    Post Reversing large-if array formula

    In the thread below I populated a range in decreasing order, given that it meets two conditions.

    http://www.excelforum.com/excel-form...-function.html

    Now that I have performed some calculations on the range, I want to put back the new numbers in the original order.

    In the attached spreadsheet column C should be a formula which takes the values from the range L1:03, and "reverses" the instructions of the formula in the range G1:J3.



    Happy Thanksgiving Americans.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Alternative to using an array formula for {=LARGE(IF(... function
    By Rabiah in forum Excel Formulas & Functions
    Replies: 28
    Last Post: 05-30-2014, 05:52 AM
  2. Macro which replace large array formula
    By ALEZI in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-22-2014, 02:32 PM
  3. [SOLVED] ARRAY Formula matching LARGE, getting duplicated results
    By Ricardo Mass in forum Excel General
    Replies: 9
    Last Post: 03-10-2014, 09:04 AM
  4. Reversing Rank Function to retrieve Large to Small in Order
    By greykitten in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-22-2013, 02:35 PM
  5. [SOLVED] Sum Large values along with Count Condition - Array Formula
    By acsishere in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-28-2013, 05:45 PM
  6. Adding Array Large Formula To Cell Via VBA
    By realniceguy5000 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-29-2011, 02:45 PM
  7. MS Excel 2002 Array Formula =large
    By fortbibby in forum Excel General
    Replies: 2
    Last Post: 01-10-2011, 04:10 PM

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