+ Reply to Thread
Results 1 to 21 of 21

In a table, how can I select to display only certain columns and not others.

Hybrid View

  1. 03-09-2022, 04:24 AM #1
    wk9128
    wk9128 is offline
    Forum Expert wk9128's Avatar
    Join Date
    08-15-2020
    Location
    China Shanghai
    MS-Off Ver
    365 V2503 and WPS V2024(12.1.0.18543)
    Posts
    4,009

    Re: In a table, how can I select to display only certain columns and not others.

    Try N2 formula

    Formula: copy to clipboard 
    =FILTER(Table1,(Table1[#Headers]=TRANSPOSE(A11:A16))*(TRANSPOSE(B11:B16)="Yes"))


    with header
    Formula: copy to clipboard 
    =FILTER(Table1[#All],(Table1[#Headers]=TRANSPOSE(A11:A16))*(TRANSPOSE(B11:B16)="Yes"))
    Last edited by wk9128; 03-09-2022 at 05:08 AM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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. Using a pivot table to display all the columns from the original table for the selected ro
    By Vaderalan in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 07-28-2020, 10:30 AM
  2. Dropdown to select table then rows display infor from selected
    By Hooty in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-15-2018, 02:37 PM
  3. Looking to be able to select specific rows and columns and display only those selections
    By cjo12 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-29-2014, 10:38 AM
  4. select numbers in columns and display them in other lines
    By kuzna26 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 12-31-2013, 04:58 PM
  5. Need to select particular value from table and display message
    By irfanparbatani in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-08-2013, 09:02 PM
  6. [SOLVED] Select & Display editable table via dropdown box
    By -AJ- in forum Excel General
    Replies: 2
    Last Post: 06-16-2013, 02:30 PM
  7. Excel 2010 Dashboard of Table - Display Subset of Table Columns
    By tbhenry in forum Excel General
    Replies: 0
    Last Post: 09-10-2012, 09:19 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1