Forum Discussion
LouisEB_MSSS
Dec 28, 2021Copper Contributor
Formule =nb.si(range;"non") et nb cellule vide
Bonjour, Formulas Chartingand FunctiBI & Data Analysisons J'ai une immensre table qui est bâti à partie des liens de 24 onglets (une ligne de titre, 419 entités et environ 30 colonnes). Je fais ...
HansVogelaar
Dec 28, 2021MVP
I'm glad you found the cause.
LouisEB_MSSS
Dec 28, 2021Copper Contributor
And I had to "redo" 419 times "n" for "NON" and "enter" and against in the cell below......it was not the funniest part of the job. But now, everthing is in controlled. It won't happen againt. I put a macro in VBA so no one can copy-paste, still if I unprotect my sheet.
Have a nice Xmas time
Have a nice Xmas time