Bonjour
comment créer une fonction pour afficher le minimum d'une serie sans tenir compte des valeurs nulles?
cordialement
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9 Function minimumquinze(st1 As Range, st2 As Range, st3 As Range, st4 As Range, st5 As Range, st6 As Range, st7 As Range, st8 As Range, st9 As Range, st10 As Range, st11 As Range, st12 As Range, st13 As Range, st14 As Range, st15 As Range) As Variant Application.Volatile minimum = Application.WorksheetFunction.Min(st1, st2, st3, st4, st5, st6, st7, st8, st9, st10, st11, st12, st13, st14, st15) minimumquinze = minimum End Function
Partager