Closed Thread
Results 1 to 10 of 10

Date and data help

  1. #1
    Registered User
    Join Date
    03-05-2024
    Location
    Toronto, canada
    MS-Off Ver
    365
    Posts
    11

    Date and data help

    Hello

    I was wondering if you can help me with my formula. In sheet1, I would like to change the month and have only the data for that month showing.

    Thanks in advance,
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    10-19-2021
    Location
    Brazil
    MS-Off Ver
    Office 365 V2401 w/ Win10 Home 64 Bit
    Posts
    2,014

    Re: Date and data help

    Only the month data showing.

    Spill array formula.
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    03-05-2024
    Location
    Toronto, canada
    MS-Off Ver
    365
    Posts
    11

    Re: Date and data help

    Thank you,

    it works well when I choose Jan & Feb, but an error for the rest.

  4. #4
    Forum Expert
    Join Date
    10-19-2021
    Location
    Brazil
    MS-Off Ver
    Office 365 V2401 w/ Win10 Home 64 Bit
    Posts
    2,014

    Re: Date and data help

    Corrected.

    C2:AG2
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Also in C1
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    03-05-2024
    Location
    Toronto, canada
    MS-Off Ver
    365
    Posts
    11

    Re: Date and data help

    Thank you very much for all your help.

  6. #6
    Forum Expert
    Join Date
    10-19-2021
    Location
    Brazil
    MS-Off Ver
    Office 365 V2401 w/ Win10 Home 64 Bit
    Posts
    2,014

    Re: Date and data help

    Tks for the feedback, glad to help.

  7. #7
    Registered User
    Join Date
    03-05-2024
    Location
    Toronto, canada
    MS-Off Ver
    365
    Posts
    11

    Re: Date and data help

    Good day, I had a question to ask. Do you think it would be possible to have EXCEL populate a task list. If I have a list of task & Dates. Would excel be able to extract that info and put it into a spreadsheet and distrusted it to employees based on their skills.?

  8. #8
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,055

    Re: Date and data help

    Many things are possible... but it's hard to tell without SEEING what you want. Please start a new thread, as that is a DIFFERENT request.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  9. #9
    Registered User
    Join Date
    03-05-2024
    Location
    Toronto, canada
    MS-Off Ver
    365
    Posts
    11

    Re: Date and data help

    In my attachment. I wanted to see if excel can extract the requirements and populate them onto the MASTER.
    Attached Files Attached Files

  10. #10
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,055

    Re: Date and data help

    Please re-read Post 8. I asked you to start a NEW thread.

    Thread closed.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 12-29-2023, 01:32 PM
  2. Replies: 6
    Last Post: 12-04-2023, 07:40 AM
  3. [SOLVED] Vertical date, by date, to horizontal data by date - separate rows per month
    By UUilliam in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-16-2022, 07:36 AM
  4. [SOLVED] Retrieve data based on a data date falling in specified date range
    By marks9172 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-24-2015, 02:50 PM
  5. Counting if data falls on date between Start Date, End Date or Possible End Date
    By JessHasQuestions in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 07-26-2014, 08:01 AM
  6. Replies: 2
    Last Post: 06-26-2014, 08:59 AM
  7. Replies: 3
    Last Post: 02-14-2014, 12:23 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