Results 1 to 12 of 12

Shorten Array Results To Relevant Range

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-09-2009
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    380

    Shorten Array Results To Relevant Range

    I would like to shorten the results returned to the relevant red columns only. Obviously these will be different all over the place. Is it possible to do this with index, match. I know it is possible with offset but I cannot do this because of the processing overhead. Is what I'm after achievable? Great article on de-referencing results from index, match which I have to share for the hell of it.



    1.png
    Attached Files Attached Files
    If it's been helpful please mark as helpful

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Producing tool help (IF greater than x kg, give me relevant results)
    By HarryDS14 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-04-2020, 10:21 AM
  2. Replies: 11
    Last Post: 07-12-2019, 07:05 PM
  3. [SOLVED] How to shorten the array formula
    By sweetfriend9 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 07-12-2017, 10:13 AM
  4. Filter not returning all relevant results
    By hnhorner in forum Excel General
    Replies: 3
    Last Post: 07-11-2015, 05:34 AM
  5. Reporting results against the relevant company
    By snappytim in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-29-2013, 09:10 PM
  6. Run macro on many cells pull data from web paste results next to relevant cell
    By elpettey in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-08-2012, 01:44 PM
  7. Formula/Array to return results in a certain range
    By B_Riz in forum Excel General
    Replies: 7
    Last Post: 01-31-2011, 02:12 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