Share via

Filter Data from Mastersheet to other sheets

Anonymous
2025-05-02T17:20:17+00:00

I am trying to filter data from one sheet(master) to another sheet based on the column that has a list of the months. I've tried using this formula but it is returns as value?

1.    =filter(mastersheet!k3:k500=A1, "no match")

  1. =filter(mastersheet!$A$!:$K:$500,mastersheet!$F$3:$F$500="January")
Microsoft 365 and Office | Excel | For business | Android

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2025-05-02T17:27:03+00:00

    If you have real dates in F:

    =FILTER(mastersheet!A:K,MONTH(mastersheet!F:F)=1)

    0 comments
  2. Ashish Mathur 99,580 Reputation points Volunteer Moderator
    2025-05-02T23:10:40+00:00

    Hi,

    Share some data to work with and show the expected result. Share data in a format that can be pasted in an MS Excel file.

    0 comments