Forum Discussion
Solved
fonction indirect dans le gestionnaire de nom
Bonjour, Peut on utiliser la fonction indirect dans le gestionnaire de nom ? Merci d'avance :-)
I think OFFSET is more relevant to your task.
It should also be possible to use the non-volatile INDEX to create the dynamic ranges you require
= INDEX(Range, 1, column_number) : INDEX(Range, final_row, column_number)
Hi Peter,
I've found a solution with the offset function.
I've already thrown out the function that I've tried to do but do you know if it's possible to use the indirect function in the box below ?
DECALER = OFFSET
ADRESSE=ADDRESS
EQUIV=MATCH
NBVAL=COUNTA
Gestionnaire_Nom
I think OFFSET is more relevant to your task.
It should also be possible to use the non-volatile INDEX to create the dynamic ranges you require
= INDEX(Range, 1, column_number) : INDEX(Range, final_row, column_number)
- Thanks a lot !
I'll try the next time :-)
Lamia