+ Reply to Thread
Results 1 to 2 of 2

Extracting Data from a List

  1. #1
    Registered User
    Join Date
    12-18-2018
    Location
    Phuket, Thailand
    MS-Off Ver
    Windows 11 - MS Office 365
    Posts
    88

    Post Extracting Data from a List

    Hello Excelsiors!

    I'd really appreicate some help with an array formula.

    I have a table, columns A through J, and I wish to extract the data that ONLY has a price more than zero (I want all items that have 0 value to be removed from the table). The item values are listed in column F.

    For example, cell F16 (Remoulade) is ot required in the new table.

    I would like the array formula to be listed on Sheet 2. I know I am able to search for '0', select the rows and delete that way, but I wish to use the array formula for many pieces of data.

    Thank you so much!

    Danny
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    09-25-2015
    Location
    Milan Italy
    MS-Off Ver
    office 365
    Posts
    1,775

    Re: Extracting Data from a List

    Sheet2

    A2=IF(Sheet2!A$1<>"",IFERROR(INDEX(Sheet1!A$2:A$1000,AGGREGATE(15,6,ROW(Sheet1!A$2:A$1000)-ROW(Sheet1!A$2)+1/(Sheet1!$F$2:$F$1000>0),ROWS(Sheet1!$A$2:Sheet1!A2))),""),"")


    Copy across and down

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Extracting list of data
    By archimaitreya in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-16-2016, 12:15 PM
  2. Extracting data from a list and creating new list
    By doublea17 in forum Excel General
    Replies: 1
    Last Post: 03-21-2014, 06:03 PM
  3. Excel 2007 : Extracting data from a parts list?
    By Mattylad in forum Excel General
    Replies: 15
    Last Post: 02-10-2012, 07:01 PM
  4. Extracting data from a long list
    By TRH in forum Excel - New Users/Basics
    Replies: 7
    Last Post: 03-26-2009, 04:27 AM
  5. Extracting desired data from a list when the Unwanted list is provided
    By all4excel in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-11-2008, 10:33 AM
  6. Extracting Data for a Formula from a List
    By Zaraf in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-12-2006, 04:16 PM
  7. Extracting Data from a list
    By andrewc in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-13-2005, 11:31 AM

Tags for this Thread

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