+ Reply to Thread
Results 1 to 6 of 6

Display text from specific cell based on result from a COUNTIFS

  1. #1
    Registered User
    Join Date
    03-19-2019
    Location
    Europe
    MS-Off Ver
    Office 2016
    Posts
    14

    Display text from specific cell based on result from a COUNTIFS

    Dear,

    I need your support on one topic related to displaying, based on countifs, the text from specific cell from where counting was realized. for e.g. C12 shows 1, but I would like to see(2nd photo, sheet called Launch Planning ARO) the project title from linked sheet.
    Capture.PNG
    Capture1.PNG

    PS: English is not my mother language so please be kind with me if I was not so clear.
    Last edited by RookieExcele; 03-19-2019 at 05:56 AM.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Display text from specific cell based on result from a COUNTIFS

    To best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    03-19-2019
    Location
    Europe
    MS-Off Ver
    Office 2016
    Posts
    14

    Re: Display text from specific cell based on result from a COUNTIFS

    Thanks. I've attached the file.
    On sheet 2 I've added a column "show which projects M0/M1 etc" *M0 = Milestone 0, where I would like to see which are the projects counted.
    I'm not sure how you can help to display them, but it will be very useful to have them like each one on separate cell, or maybe you have other suggestions- which I'm more than opened to see it.
    In the end I want to display the results in a chart/dashboard. (e.g. in March-2019 there are 3 projects counted and name of them also, which they are in milestone 0, so on, so forth.)

    Thanks.
    Attached Files Attached Files

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

    Re: Display text from specific cell based on result from a COUNTIFS

    Hello RookieExcele and Welcome to Excel Forum.
    Perhaps the following will be helpful.
    The data is transformed to a table (Ctrl + t)
    The table is 'un pivoted' using Power Query (standard with Excel 2016)
    The Power Query table data is displayed using a pivot table.
    The grouping of dates is by month and year.
    A slicer allows the user to select the milestone.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  5. #5
    Registered User
    Join Date
    03-19-2019
    Location
    Europe
    MS-Off Ver
    Office 2016
    Posts
    14

    Re: Display text from specific cell based on result from a COUNTIFS

    Thanks JeteMc.
    Is not exactly what I've had on my mind, but it's a different approach, which honestly it's fits much better for my need.

    Regards. Best wishes.

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

    Re: Display text from specific cell based on result from a COUNTIFS

    You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.

+ 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. Count Specific Cell Value and Display Result
    By markusvirus in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-30-2015, 05:52 PM
  2. IF cell contains a certain item of text then display result
    By LMW1985 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 12-23-2013, 07:10 AM
  3. Check a webpage for specific text and highlight a cell based on result
    By ks100 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-12-2013, 09:56 AM
  4. Replies: 2
    Last Post: 08-05-2013, 07:32 PM
  5. Display a specific result based on Cell Values in a row (Ex Attached)
    By chadly72 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-06-2013, 03:15 PM
  6. Display numerical result of a cell with Text as well
    By davidcrawt in forum Excel General
    Replies: 3
    Last Post: 11-26-2012, 03:27 PM
  7. Display result based on another cell
    By queryplus in forum Excel General
    Replies: 3
    Last Post: 07-18-2012, 01:54 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