+ Reply to Thread
Results 1 to 1 of 1

Extracting information from a table and displaying information in a new table

  1. #1
    Registered User
    Join Date
    04-19-2020
    Location
    Adelaide, Australia
    MS-Off Ver
    2002
    Posts
    1

    Extracting information from a table and displaying information in a new table

    Hi I’d like to create a spreadsheet but am not very knowledgeable on the various functions excel has.
    I’ve tried to create an example of what I’d like to do.


    I’d like to automate the following:
    extract information from the following table. Eg pull all the ‘Apples’ information
    Input Table
    Input Table.png

    Then create a new table on ‘Apples’ and show the information in sequential order.
    Output Table 1.png

    And then in the row below, calculate the difference between the apple selected and the time the next sequential apple picked.
    Output Table 2.png
    And then in the bottom row, calculate the difference between the apple selected and its next substitute apple.

    Output Table 3.png

    I've done all this with individual formulas but really the data set could up to 1000 entries so figuring out how to automatically do the above would
    be great. I hope this is enough info but please let me know if I need to provide more.
    Attached Files Attached Files

+ 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. Replies: 1
    Last Post: 04-09-2020, 02:26 AM
  2. [SOLVED] Extracting information with conditional format to creat a smaller table
    By ARamos2 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-16-2016, 04:13 PM
  3. Table displaying less information
    By nexfoto in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-03-2014, 03:41 AM
  4. Extracting and comparing information from pivot table.
    By jonboy6257 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 01-14-2014, 06:14 PM
  5. Extracting Information From 8 Fields in excel and Placing it into a Powerpoint Table
    By Wesley0705 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-10-2013, 11:50 PM
  6. Replies: 9
    Last Post: 03-29-2012, 06:11 AM
  7. Extracting Information from A Pivot Table
    By Jim Patterson in forum Excel General
    Replies: 2
    Last Post: 06-16-2006, 08:00 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