Forum Discussion
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 ...
I check the cells in my list and some were not registered as "text". In 4 cells, we can see the visual "NON" but it was not considered as alphanumerical. As it come from a dropdown list in several sheets, I figured it out the maybey my collgue copy-past "NON" from somewhere else. It is to bad because my sheet it's protected against copy-paste but yesterday, I had to do mainrtenance for 3 minutes.....the time someone paste the 4 cells.
Thanks for your help
I'm glad you found the cause.
- 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