Microsoft 365 Find out the index of the 1st occurrence

nvj1

XLDnaute Nouveau
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
 

Pièces jointes

  • aide-excel.xlsx
    9 KB · Affichages: 8

patricktoulon

XLDnaute Barbatruc
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 ;)
 

Statistiques des forums

Discussions
314 499
Messages
2 110 247
Membres
110 711
dernier inscrit
chmessi