Results 1 to 6 of 6

Make Cells Appear Based off Matching Text

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-19-2019
    Location
    Michigan
    MS-Off Ver
    Office 365
    Posts
    547

    Make Cells Appear Based off Matching Text

    Just reaching out to see if anyone has a good solution. Each month I will be pulling in data and calling the tab names January, February, March, etc.. In the Summary Tab I will use the drop down to sect the month I am working in which will be cell A5. Once I select the month (A5), I would like some sort of formula which would list all dates from the tab that the month is selected. So in the case of November I would like to list all these dates in column A8:A16. Then In column B i would like to list the corresponding values. Is this possible? and did I do a good job explaining this? Please see attached file


    Place in column A: Place in column B:
    2020-11-02 Total 24.26
    2020-11-09 Total 26.04
    2020-11-16 Total 27.97
    2020-11-20 Total 2.11
    2020-11-21 Total 0.00
    2020-11-23 Total 24.13
    2020-11-30 Total 23.62



    Thank you.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Cond Format needed to highlight 2 matching cells based on specific cell text
    By excelteam777 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-14-2020, 09:47 AM
  2. [SOLVED] Conditional Format Needed to highlight based on matching text in certain cells
    By excelteam777 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-13-2020, 09:17 PM
  3. [SOLVED] How to sum a range of cells based on partly matching text string
    By ruddochk in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-22-2018, 04:02 PM
  4. [SOLVED] How to make multiple cells change color based on one cell's text.
    By Ducky405 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-07-2017, 03:49 AM
  5. Replies: 4
    Last Post: 02-16-2013, 09:34 AM
  6. [SOLVED] Search text in cells, find matching text based on list, remove all but one entry
    By adam_mc in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-30-2013, 12:50 PM
  7. Replies: 3
    Last Post: 11-04-2010, 10:00 PM

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