+ Reply to Thread
Results 1 to 2 of 2

Display selected text from an entire table

  1. #1
    Registered User
    Join Date
    07-25-2020
    Location
    Mumbai
    MS-Off Ver
    2019
    Posts
    1

    Display selected text from an entire table

    So recently our college has shared a common timetable for all the classes, however, I want a timetable to be displayed only for the subjects that I has applied for. Can anyone help me with this? I am ready to share the timetable as well.

    TIA!
    Attached Files Attached Files
    Last edited by SyKick; 07-27-2020 at 11:22 AM.

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,562

    Re: Display selected text from an entire table

    Hello SyKick and Welcome to Excel Forum.
    As you are using the 2019 version of Excel I would suggest using Get & Transform to unpivot the classes using the following Power Query advanced editor code:
    Please Login or Register  to view this content.
    Note that the code also produces a 'Subject' column without the A1, B2 ... designations.
    Once the row over row table is produced it may be referenced using a pivot table and the subjects for which you applied may be chosen using a slicer.
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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: 3
    Last Post: 10-01-2019, 01:21 AM
  2. Macro to find text and display entire row in message box
    By n00ne in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 07-10-2015, 01:34 AM
  3. [SOLVED] Display only selected rows in a separate table
    By 288enzo in forum Excel General
    Replies: 20
    Last Post: 07-29-2013, 01:28 AM
  4. VLOOKUP Function to display entire row of value selected via drop-down list
    By BamBamMoneyBags in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-08-2013, 03:00 AM
  5. Replies: 3
    Last Post: 08-24-2012, 12:24 PM
  6. Search Selected Data for a Text String and replace entire cell with new tex
    By maz003 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-06-2010, 02:26 PM
  7. How to display selected table entries from another worksheet?
    By Wheel in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-03-2005, 11:05 PM

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