Forum Discussion

LouisEB_MSSS's avatar
LouisEB_MSSS
Copper Contributor
Dec 28, 2021

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 tdes onglet de recherches sur mes données. 80% des tri de mes tables dupliquées fonctionnent sauf 3. La formule (=nb.si(j2:j419;"non") en bas du tableau me rapporte 270 visuellement. Toutefois, Excel me dit qu'il repère 274 cases avec "non"

excel
Formulas and Functions

4 Replies

Sort By
  • LouisEB_MSSS's avatar
    LouisEB_MSSS
    Copper Contributor
    Dec 28, 2021

    LouisEB_MSSS 

    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

      • LouisEB_MSSS's avatar
        LouisEB_MSSS
        Copper Contributor
        Dec 28, 2021
        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

Resources