+ Reply to Thread
Results 1 to 4 of 4

Lines move from table to anothre table with the function small

  1. #1
    Registered User
    Join Date
    11-16-2012
    Location
    the hague netherlands
    MS-Off Ver
    Excel 2010
    Posts
    10

    Lines move from table to anothre table with the function small

    Hi All,

    Who can help me out?

    In the enclosure is a sheet named "TOTAAL" with a table and data.

    There is a sheet named "POSTEN".

    I want to get from the sheet "TOTAAL" and table the header "POST" "A" into the sheet "POSTEN".

    For example I have copied the POST A into the sheet POSTEN.

    As you can see I have try to use the SMALL function but I get an ERROR.

    Thanks in advance for your help.
    Attached Files Attached Files

  2. #2
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Lines move from table to anothre table with the function small

    In A6, Drag Down as required.

    =IFERROR(INDEX(TOTAAL!A$2:A$7,SMALL(IF(TRIM($A$1)=Table1[POST],ROW(Table1[POST])),ROWS($A$6:$A6))-1),"")

    ...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

    Also double click on the Merged Cell that has value A, and press the delete key once and then hit enter..

    See the file attached.
    Attached Files Attached Files
    Cheers!
    Deep Dave

  3. #3
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,904

    Re: Lines move from table to anothre table with the function small

    Another way by using pivot table
    see the attached file
    Attached Files Attached Files
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  4. #4
    Registered User
    Join Date
    11-16-2012
    Location
    the hague netherlands
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: Lines move from table to anothre table with the function small

    Thanks for your help it is solved.
    Best regards Sportfan

+ 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. Pull all lines from a table if value matches identifier in another table
    By brizon in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-07-2015, 06:17 PM
  2. [SOLVED] Code to move data from an entry table to a historical table by date.
    By rlh in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-17-2014, 11:04 AM
  3. Help creating vba function to move data from table to table on if condtion
    By damaple in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-09-2013, 05:42 AM
  4. Small editing of vba - a table of contents since the second row
    By Remphan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-15-2013, 07:01 PM
  5. [SOLVED] Need to have a small table overlayed onto a chart.
    By dropanddrive03 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 02-15-2013, 06:28 AM
  6. content is small, table is tooo big
    By reedzhou in forum Excel General
    Replies: 2
    Last Post: 12-05-2010, 11:55 PM
  7. Searching Through Small Data Table
    By Matt Adams in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-07-2008, 04:36 AM

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