View original (French)

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

Solved
hich24 Posted messages 1686 Status Membre -  
hich24 Posted messages 1686 Status Membre -

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 réponses

Réponse 1 / 3
Raymond PENTIER Posted messages 58548 Registration date   Status Contributeur Last intervention   17 474
 

Hello.

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

Retirement is great! Especially in the Caribbean...
Raymond (INSA, AFPA)
2
Réponse 2 / 3
Raymond PENTIER Posted messages 58548 Registration date   Status Contributeur Last intervention   17 474
 

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
Réponse 3 / 3
hich24 Posted messages 1686 Status Membre 753
 

thank you
0