Forum Discussion

MacJones10's avatar
MacJones10
Copper Contributor
Dec 28, 2022

Filter Function Data Linking

I am using the filter function below to take all jobs "Won" from my main data sheet. Columns (B-P) are a part of the Filter function, I want to keep track of the dates I send the invoice to the clients as you can see in column (R). However, every time a new row is added in the filtered portion of the sheet, The nonfiltered portion of this sheet columns R-V don't move with the updated filtered data. My question is there a way to link the data so the correct date moves with the correct invoice number and job

 

  • mdodds's avatar
    mdodds
    Copper Contributor

    I have found that this function works well and should solve your issue, however the one thing it doesn't do is make hyperlinked data remain as a hyperlink, that's something I'm trying to resolve. So your data would be in a tab that I'm calling Data[Employee ID2] the Data is the name of the tab while the Employee ID2 is the column label.

     

    =FILTER(Data,ISNUMBER(SEARCH($B$3,Data[Employee ID2]))=TRUE,"Not match found")

  • Lorenzo's avatar
    Lorenzo
    Silver Contributor

    MacJones10 

     

    > 60 views so far. This probably means nobody understand the issue. To helps us help you:

     

    #1 Could upload & share, i.e. with OneDrive or any other file sharing service, a sample representative workbook (remove sensitive data if any) that includes your formula(s)?

     

    #2 What version of Excel do you run & on which Operating System (Windows, MacOS...)?

    • MacJones10's avatar
      MacJones10
      Copper Contributor

      Hello Lorenzo Ill work on getting a copy of the spreadsheet. I am using the new version of Excel 365. THe function I am using is the new Filter function =Filter() to pull the specific data I need from the main page into the new sheet. 

Resources