View original (French)

How to use the =filter() function in Excel 2007

Solved
hich24 Posted messages 1686 Status Member -  
hich24 Posted messages 1686 Status Member -

Hello,

I would like to know if the FILTER function exists in Excel 2007, and if possible, a small example of how to use it.

Thank you for any initiative


3 answers

  1.
    Raymond PENTIER Posted messages 58213 Registration date   Status Contributor Last intervention   17 482
     

    Hello.

    You can see that she doesn't exist...

    Retirement is great! Especially in the Caribbean...
    Raymond (INSA, AFPA)

    2
  2. Raymond PENTIER Posted messages 58213 Registration date   Status Contributor Last intervention   17 482
     

    In the link
    https://fr.extendoffice.com/excel/functions/excel-filter-function.html#:~:text=Fonction%20FILTRE%20Excel%20La%20fonction%20FILTER%20filtre%20une,plus%20r%C3%A9centes%20d%27Excel%20et%20Excel%20pour%20le%20Web.
    you will be able to read
    "The FILTER function is only available in Excel for Microsoft 365, Excel 2021, or later versions of Excel and Excel for the Web.

    2
  3. hich24 Posted messages 1686 Status Member 753
     

    thank you

    0