Programmer excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2905323%22%20slang%3D%22fr-FR%22%3EProgram%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2905323%22%20slang%3D%22fr-FR%22%3EI%20would%20like%20to%20know%20how%20to%20program%20Excel%20and%20save%20my%20own%20formulas%20in%20order%20to%20work%20quickly%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2905323%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2905350%22%20slang%3D%22en-US%22%3ERe%3A%20Programmer%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2905350%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1201188%22%20target%3D%22_blank%22%3E%40Toihir350%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Ffr-fr%2Foffice%2Fcr%25C3%25A9er-des-fonctions-personnalis%25C3%25A9es-dans-excel-2f06c10b-3622-40d6-a1b2-b6748ae8231f%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ECr%C3%A9er%20des%20fonctions%20personnalis%C3%A9es%20dans%20Excel%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor
J'aimerais savoir comment programmer Excel et enregistrer mes propres formules afin de travailler rapidement
2 Replies

@Toihir350 

The latest versions of Excel 365 (still in beta release) allow you to define your own functions using spreadsheet formulas within the new LAMBDA function.  Working with array formulas is the new 'normal' and there are helper functions that support iteration through the terms of an array.

LAMBDA function (microsoft.com)