Results 1 to 13 of 13

Non Array Formula to Extract Values

Threaded View

bjnockle Non Array Formula to Extract... 03-31-2018, 12:08 AM
MarvinP Re: Non Array Formula to... 03-31-2018, 12:27 AM
bjnockle Re: Non Array Formula to... 03-31-2018, 12:30 AM
MarvinP Re: Non Array Formula to... 03-31-2018, 12:39 AM
bjnockle Re: Non Array Formula to... 03-31-2018, 12:48 AM
sandy666 Re: Non Array Formula to... 03-31-2018, 01:03 AM
bjnockle Re: Non Array Formula to... 03-31-2018, 01:09 AM
shukla.ankur281190 Re: Non Array Formula to... 03-31-2018, 01:34 AM
bjnockle Re: Non Array Formula to... 03-31-2018, 03:51 AM
sandy666 Re: Non Array Formula to... 03-31-2018, 01:37 AM
shukla.ankur281190 Re: Non Array Formula to... 03-31-2018, 04:05 AM
bjnockle Re: Non Array Formula to... 03-31-2018, 04:31 AM
shukla.ankur281190 Re: Non Array Formula to... 03-31-2018, 04:50 AM
  1. 03-31-2018, 12:08 AM #1
    bjnockle is offline
    Forum Contributor
    Join Date
    02-06-2013
    Location
    Maryland
    MS-Off Ver
    Excel 2010
    Posts
    1,012

    Non Array Formula to Extract Values

    Looking for non-array formula to extract sorted values into F2:G27 as A2:B27 is the rawdata then extract raw data C2:D27 into H2:H27 and I2:I27 corresponding to each each sorted value in F2:G27. See sample file. Desired outcome in F2:I27.

    Thanks
    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] Non Array Formula to Extract Values and Ignore Blanks
    By bjnockle in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 03-27-2018, 02:41 PM
  2. [SOLVED] Array Formula to extract all values (both duplicates and unique values in a range in Excel
    By bjnockle in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 10-27-2016, 07:33 PM
  3. extract unique values in an array
    By froggeja in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 06-24-2015, 03:58 AM
  4. [SOLVED] Extract values from array
    By TheCman81 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-30-2014, 11:13 AM
  5. [SOLVED] Array formula to extract and sort unique values from two worksheets
    By rshukla in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-07-2013, 06:11 AM
  6. Excel 2007 : Array formula to extract unique values from a range
    By Motox in forum Excel General
    Replies: 3
    Last Post: 11-24-2011, 06:11 AM
  7. Extract nonzero values from array
    By emricki in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-18-2011, 01:31 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1