Microsoft 365 Find out the index of the 1st occurrence

[nvj1]

Hello,

I would like to find the number of the column for which I have the first data, no matter what it is written, but I don't know how to do it.
I have attached an example of my Excel file and put in yellow what I would like to get.

Thank you in advance for your help,
NVJ1

 

[_Thierry]

Hi @nvj1, Le Forum

This is a french Excel Forum, but anyhow you can try this VBA solution...
Best regards
@+Thierry

 

[patricktoulon]

hello
you have to use a double index formula with "true"
I start in column "B" because the "A" contains something and so I add +1 for column "A" which I dont use in formula
put in "N2" this formula and change "vrai" to "true" in office us version "

= EQUIV (VRAI; INDEX (B2: M2> 0; 0); 0) +1

and extend the formula down!!!!

salut thierry 😉

 

[nvj1]

Oups, je ne sais pas pourquoi j'ai écrit en anglais...
Merci beaucoup pour votre réponse,
NVJ1

 

[patricktoulon]

de rien NVJ1

if you want the last value it's that:

=MAX(COLONNE(A2:M2)*(A2:M2>0))
and do same the first example
extend the formula down!!!!

😉 😛