Note: The other languages of the website are Google-translated. Back to English
Se connecter  \/ 
x
or
x
INSCRIPTION  \/ 
x

or

Comment compter les valeurs en double dans une colonne dans Excel?

Si vous avez une liste de données dans une feuille de calcul avec des valeurs uniques et des valeurs en double, et que vous ne voulez pas seulement compter la fréquence des valeurs en double, vous voulez également connaître l'ordre d'occurrence des valeurs en double. Dans Excel, la fonction COUNTIF peut vous aider à compter les valeurs en double.


Comptez la fréquence des doublons dans Excel

Dans Excel, vous pouvez utiliser la fonction COUNTIF pour compter les doublons.

Sélectionnez une cellule vide à côté des premières données de votre liste et saisissez cette formule = COUNTIF ($ A $ 2: $ A $ 9, A2) (la gamme $ A $ 2: $ A $ 9 indique la liste des données, et A2 tient la cellule dont vous voulez compter la fréquence, vous pouvez les changer selon vos besoins), puis appuyez sur Entreret faites glisser la poignée de recopie pour remplir la colonne dont vous avez besoin. Voir la capture d'écran:

Trucs: Si vous souhaitez compter les doublons dans toute la colonne, utilisez cette formule = COUNTIF (A: A, A2) (les Colonne A indique la colonne de données, et A2 représente la cellule dont vous souhaitez compter la fréquence, vous pouvez les modifier selon vos besoins).

Sélectionnez et comptez rapidement toutes les valeurs en double / uniques à partir d'une colonne dans Excel

En général, nous pouvons facilement supprimer les doublons d'une liste en Data > Supprimer les doublons dans Excel. Mais comment sélectionner des valeurs dupliquées / uniques ou les compter à partir d'une colonne? Et que se passe-t-il si vous sélectionnez ou comptez les doublons / uniques sauf le premier en double? Essayez Kutools pour Excel Sélectionnez les cellules dupliquées et uniques utilitaire!
Essai gratuit de 30 jours maintenant!        Acheter!
la sélection d'annonce compte les doublons

Kutools pour Excel - Comprend plus de 300 outils pratiques pour Excel. Essai gratuit complet de 30 jours, aucune carte de crédit requise! Achetez-le Maintenant

Compter l'ordre d'apparition des doublons dans Excel

Mais si vous souhaitez compter l'ordre d'apparition des doublons, vous pouvez utiliser la formule suivante.

Sélectionnez une cellule vide à côté des premières données de votre liste et saisissez cette formule = COUNTIF ($ A $ 2: $ A2, A2) (la gamme $ A $ 2: $ A2 indique la liste des données, et A2 tient la cellule dans laquelle vous souhaitez compter la commande, vous pouvez les modifier selon vos besoins), puis appuyez sur Entreret faites glisser la poignée de recopie pour remplir la colonne dont vous avez besoin. Voir la capture d'écran:


Comptez et sélectionnez tous les doublons dans une colonne avec Kutools for Excel

Parfois, vous souhaiterez peut-être compter et sélectionner tous les doublons dans une colonne spécifiée. Vous pouvez le faire facilement avec Kutools for Excel's Sélectionnez les doublons et les cellules uniques utilitaire.

Kutools pour Excel - Comprend plus de 300 outils pratiques pour Excel. Essai gratuit complet de 30 jours, aucune carte de crédit requise! Essai gratuit maintenant!

1. Sélectionnez la colonne ou la liste dans laquelle vous comptez tous les doublons, puis cliquez sur le bouton Kutools > Choisir > Sélectionnez les doublons et les cellules uniques.

2. Dans la boîte de dialogue d'ouverture Sélectionner les cellules dupliquées et uniques, cochez la case Doubles (sauf le premier) Option ou Tous les doublons (y compris le premier) selon vos besoins, puis cliquez sur le Ok .

Et puis vous verrez une boîte de dialogue sortir et montrer combien de doublons sont sélectionnés, et en même temps les doublons sont sélectionnés dans la colonne spécifiée.

A Noter: Si vous souhaitez compter tous les doublons, y compris le premier, vous devez vérifier le Tous les doublons (y compris le premier) dans la boîte de dialogue Sélectionner les cellules dupliquées et uniques.

3. Clique le OK .

Kutools pour Excel - Comprend plus de 300 outils pratiques pour Excel. Essai gratuit complet de 30 jours, aucune carte de crédit requise! Achetez-le Maintenant


Compter les occurrences de chaque doublon dans une colonne avec Kutools for Excel

Kutools pour Excel Lignes de combinaison avancées L'utilitaire peut aider les utilisateurs d'Excel à compter par lots les occurrences de chaque élément dans une colonne (la colonne fruitée dans notre cas), puis à supprimer facilement les lignes en double en fonction de cette colonne (la colonne fruit) comme ci-dessous:

Kutools pour Excel - Comprend plus de 300 outils pratiques pour Excel. Essai gratuit complet de 30 jours, aucune carte de crédit requise! Essai gratuit maintenant!

1. Sélectionnez le tableau contenant la colonne dans laquelle vous comptez chaque doublon et cliquez sur Kutools > du Paquet > Lignes de combinaison avancées.

2. Dans les lignes de combinaison avancées, sélectionnez la colonne dans laquelle vous comptez chaque doublon et cliquez sur Clé primaire, sélectionnez ensuite la colonne dans laquelle vous allez mettre les résultats de comptage et cliquez sur Calculer > Compter, puis cliquez sur le OK bouton. Voir la capture d'écran:

Et maintenant, il a compté l'occurrence de chaque doublon dans la colonne spécifiée. Voir la capture d'écran:

Kutools pour Excel - Comprend plus de 300 outils pratiques pour Excel. Essai gratuit complet de 30 jours, aucune carte de crédit requise! Achetez-le Maintenant


Démo: compter les valeurs en double dans une colonne dans Excel par Kutools for Excel


Kutools pour Excel comprend plus de 300 outils pratiques pour Excel, gratuits à essayer sans limitation en 30 jours. Téléchargez et essayez gratuitement maintenant!

Articles relatifs:


Les meilleurs outils de productivité de bureau

Kutools for Excel résout la plupart de vos problèmes et augmente votre productivité de 80%

  • Réutilisation: Insérer rapidement formules complexes, graphiques et tout ce que vous avez utilisé auparavant; Crypter les cellules avec mot de passe; Créer une liste de diffusion et envoyer des e-mails ...
  • Barre Super Formula (modifiez facilement plusieurs lignes de texte et de formule); Disposition de lecture (lire et modifier facilement un grand nombre de cellules); Coller dans la plage filtrée...
  • Fusionner les cellules / lignes / colonnes sans perdre de données; Contenu des cellules divisées; Combiner des lignes / colonnes en double... Empêcher les cellules en double; Comparer les gammes...
  • Sélectionnez Dupliquer ou Unique Lignes; Sélectionnez les lignes vides (toutes les cellules sont vides); Super Find et Fuzzy Find dans de nombreux classeurs; Sélection aléatoire ...
  • Copie exacte Plusieurs cellules sans changer la référence de formule; Créer automatiquement des références à plusieurs feuilles; Insérer des puces, Cases à cocher et plus encore ...
  • Extrait du texte, Ajouter du texte, Supprimer par position, Supprimer l'espace; Créer et imprimer des sous-totaux de pagination; Conversion entre le contenu et les commentaires des cellules...
  • Super filtre (enregistrer et appliquer des schémas de filtrage à d'autres feuilles); Tri avancé par mois / semaine / jour, fréquence et plus; Filtre spécial par gras, italique ...
  • Combiner des classeurs et des feuilles de travail; Fusionner les tableaux en fonction des colonnes clés; Diviser les données en plusieurs feuilles; Conversion par lots xls, xlsx et PDF...
  • Plus de 300 fonctionnalités puissantes. Prend en charge Office / Excel 2007-2019 et 365. Prend en charge toutes les langues. Déploiement facile dans votre entreprise ou organisation. Essai gratuit de 30 jours. Garantie de remboursement de 60 jours.
onglet kte 201905

Office Tab apporte une interface à onglets à Office et simplifie considérablement votre travail

  • Activer l'édition et la lecture par onglets dans Word, Excel, PowerPoint, Publisher, Access, Visio et Project.
  • Ouvrez et créez plusieurs documents dans de nouveaux onglets de la même fenêtre, plutôt que dans de nouvelles fenêtres.
  • Augmente votre productivité de 50% et réduit des centaines de clics de souris chaque jour!
bas de cabine
Say something here...
symbols left.
You are guest
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    Lia · 1 months ago
    Halo, bagaimana jika kita ingin menjumlahkan total dari data duplikat tersebut? Contoh, Banyaknya Apel pada baris satu adalah 734pcs, Apel pada baris 5 100pcs, Apel pada baris 8 20pcs. Bagaimana cara menjumlahkannya dengan otomatis? Terima Kasih untuk jawabannya
  • To post as a guest, your comment is unpublished.
    Manikandan.K · 1 years ago
    Hi, I'm trying to calculate the duplicate values as a single value in excel. But I can't. Can you help me?. For example, I have entered in rows as 1001,1002,1003,1004 and again 1001,1002,1003,1004" like this. In this case, all are duplicate ones. but it should bring "1001" as a single count, not two counts. Is there any formula for it?
    • To post as a guest, your comment is unpublished.
      kellytte · 1 years ago
      Hi Manikandan.K,
      Supposing the data you will count are placed in the Range A1:A20, you can use below arrow formula to count (a set of duplicates only count once):
      =SUM(IF(A1:A20<>"",1/COUNTIF(A1:A20,A1:A20)))
      Please note that it’s an array formula, please press Ctrl + Shift + Enter keys to get the counting result.
  • To post as a guest, your comment is unpublished.
    Michael · 1 years ago
    Hi I'm trying to run the "Advanced Combined Row" feature, but when I run it excel crashes every time.
  • To post as a guest, your comment is unpublished.
    Sampath Rangan · 1 years ago
    I have entered in a row as " 10,10,10,10,10,10,10,8,11,10,10,10,10,10" like this, now I entered 14 number values. How I can count the different number in single row? the result should be "14" in my case.
    • To post as a guest, your comment is unpublished.
      kellytte · 1 years ago
      Hi Sampath Rangan,
      Do you need to count all numbers in the row, or count the duplicates in the row?
      Supposing the numbers are in the Range A1:N1, now you can count the numbers as follows:
      Count all numbers: =COUNT(A1:N1)
      Count duplicates, says 10: =COUNTIF($A$1:$N$1,"10")
  • To post as a guest, your comment is unpublished.
    Mel Scott · 2 years ago
    Thanks so much, saved me hours!
  • To post as a guest, your comment is unpublished.
    patel akshay · 2 years ago
    i need this
    There are 24 students.how many groups are there to take 10 student in 1 group
    example:
    1,2,3,4,5 take 1 group in 3 number

    ans={1,2,3} {2,3,4} {3,4,5} {4,5,1} {5,1,2,}

    how to do this excel will create this file
    • To post as a guest, your comment is unpublished.
      kellytte · 2 years ago
      Hi patel akshay,
      You can use the COMBIN function in Excel directly.
      =COMBIN(24,10)
  • To post as a guest, your comment is unpublished.
    Jothibasu · 2 years ago
    Thank You very much. It's very useful.
  • To post as a guest, your comment is unpublished.
    BillBrewster · 3 years ago
    I must be stupid as the KuTools solution is not working for me. I have copied the example with Fruits column (which I put 3 Apple entries in), made a column next to it which is blank called Count column. KuTools -> Content -> Advanced Combine Rows. Select Fruit column as primary key, Count column as Calculate -> Count. Hit OK. Nothing. No change to the sheet. Help please?
    • To post as a guest, your comment is unpublished.
      kellytte · 2 years ago
      Hi BillBrewster,
      Would you do me a favor and send me a screenshot about the Advanced Combine Rows dialog? Just like the screenshot as below. Thanks in advance!
  • To post as a guest, your comment is unpublished.
    mhusnainkamboh@gmail.com · 3 years ago
    Dear, I am working on the attached Screenshot and Excel File. I need to calculate the Values in Column "G" i.e. to Count unique text values based on multiple (Two) criteria, but criteria are in NUMBERS. Further, Its is big sheet, therefore I want to use the cell reference in range and in criteria. I am very confused. I want to count the column C i.e. Degree based on the Criteria E and F. That is,I need to set formula in G2, such that, Look E2 in column A and Look F2 in column B and count the unique text values in Column C. Hope it is clear.

    I am very thankful to you please


    Details:
    I have a data of more than 1000 companies with different year. As in column A, I have companies and B shows the year for which these companies have data. For example, First company have data for year 2011, 2012, 2013 and 2015. For company 2, I have data for year 2014 and 2011 and so on. Since majority of companies have data from 2011 to 2015, therefore I select this range in column F for each company. Now, I want to count the unique Degrees for cell G2, if there is 389841988 (Company ID for First company) in A and there is 2011 in Column B. Now I need to set formula in G2,in a way, If I will drag the formula G2 in cell G3, then It should give me the value by looking such as if there is 389841988 (Company ID for First company) in A and there is 2012 in Column B, the based on these two criteria, it should count the unique text in C2 and so on.
    Look on the second sheet named Example, I did the same for INDEX, MATCH function and as well for SUMIFS function; in C2 I have the array formula INDEX($F:$H,MATCH(1,(A2=$F:$F)*(B2=$G:$G),0),3) and in D2 I have SUMIFS(I:I,F:F,A2,G:G,B2). These help me to do what I want with two criteria (To match and also to sum) and also I can drag these for rest of cell. I am looking something like this, or anything that I can drag to count unique degrees. Thank you very much. I am waiting.

    Plz help. I am very thankful to for this kindness
  • To post as a guest, your comment is unpublished.
    mhusnainkamboh@gmail.com · 3 years ago
    Dear, I got the way to upload the screenshot. Kindly consider the attached one,
    Thank you very much
    • To post as a guest, your comment is unpublished.
      mhusnainkamboh@gmail.com · 3 years ago
      Dear, I am working on the attached Screenshot and Excel File. I need to calculate the Values in Column "G" i.e. to Count unique text values based on multiple (Two) criteria, but criteria are in NUMBERS. Further, Its is big sheet, therefore I want to use the cell reference in range and in criteria. I am very confused. I want to count the column C i.e. Degree based on the Criteria E and F. That is,I need to set formula in G2, such that, Look E2 in column A and Look F2 in column B and count the unique text values in Column C. Hope it is clear.

      I am very thankful to you please


      Details:
      I have a data of more than 1000 companies with different year. As in column A, I have companies and B shows the year for which these companies have data. For example, First company have data for year 2011, 2012, 2013 and 2015. For company 2, I have data for year 2014 and 2011 and so on. Since majority of companies have data from 2011 to 2015, therefore I select this range in column F for each company. Now, I want to count the unique Degrees for cell G2, if there is 389841988 (Company ID for First company) in A and there is 2011 in Column B. Now I need to set formula in G2,in a way, If I will drag the formula G2 in cell G3, then It should give me the value by looking such as if there is 389841988 (Company ID for First company) in A and there is 2012 in Column B, the based on these two criteria, it should count the unique text in C2 and so on.
      Look on the second sheet named Example, I did the same for INDEX, MATCH function and as well for SUMIFS function; in C2 I have the array formula INDEX($F:$H,MATCH(1,(A2=$F:$F)*(B2=$G:$G),0),3) and in D2 I have SUMIFS(I:I,F:F,A2,G:G,B2). These help me to do what I want with two criteria (To match and also to sum) and also I can drag these for rest of cell. I am looking something like this, or anything that I can drag to count unique degrees. Thank you very much. I am waiting.

      Plz help. I am very thankful to for this kindness
    • To post as a guest, your comment is unpublished.
      mhusnainkamboh@gmail.com · 3 years ago
      The screenshot is not showing in the post. I don't know way.
      • To post as a guest, your comment is unpublished.
        kelly001 · 3 years ago
        Hi,
        Click the “Reply” to show the replying textbox, and then click the small icon at the bottom of the textbox to upload your screenshot:
  • To post as a guest, your comment is unpublished.
    mhusnainkamboh@gmail.com · 3 years ago
    Dear, I am working on the attached Sheet. I need to calculate the Values in Column "G" i.e. to Count unique text values based on multiple (Two) criteria, but criteria are in NUMBERS not in TEXT. Further, Its is big sheet, therefore I want to use the cell reference in range and in criteria. I am very confused. I want to count the column C i.e. Degree based on the Criteria E and F. That is, Look E2 in column A and Look F2 in column B and count the unique text values in Column C. Hope it is clear.
    Plz help. Thank you
    • To post as a guest, your comment is unpublished.
      kelly.extendoffice@gmail.com · 3 years ago
      Hi,
      Could you upload a screenshot about your problem? A picture may help us understand you problem much clear. Thank you!
      • To post as a guest, your comment is unpublished.
        Husnain · 3 years ago
        thank you very much.
        I am trying to upload the Screenshot, but I don't know how I can upload it in the comment section.


        CompanyID* YEAR Degree CompanyID* YEAR Count Unique Degree
        389841988 2015 PhD 389841988 2011 1
        389841988 2015 Master 389841988 2012 2
        389841988 2011 Matric 389841988 2013 1
        389841988 2012 PhD 389841988 2014 0
        389841988 2012 PhD 389841988 2015 2
        389841988 2012 Matric 23819116896 2011 1
        389841988 2013 Matric 23819116896 2012 0
        23819116896 2014 Master 23819116896 2013 0
        23819116896 2014 Master 23819116896 2014 1
        23819116896 2011 Master 23819116896 2015 0
        168402710018 2011 Master 168402710018 2011 1
        168402710018 2014 PhD 168402710018 2012 0
        168402710018 2014 PhD 168402710018 2013 0
        168402710018 2014 1
        168402710018 2015 0
        • To post as a guest, your comment is unpublished.
          deepak · 3 years ago
          Row Number B column c column D column E column F column G column

          Forumula: =C1&D1&E1&F1&G1

          13 168402710018 2014 PhD 1.68403E+11 2012 0 2014PhD16840271001820120
          14 168402710018 2014 PhD 1.68403E+11 2012 0 2014PhD16840271001820120


          Result: Row number 13 and 14 are same.
  • To post as a guest, your comment is unpublished.
    rafiq · 4 years ago
    how can we count duplicate values in excel row
  • To post as a guest, your comment is unpublished.
    Vishvas · 4 years ago
    Can't we get count of duplicate values with the help of count if function if yes how ? please advise
    as this is a interview question asked to me.
    • To post as a guest, your comment is unpublished.
      deepak · 3 years ago
      Vishvas use countif formula



      Forumula:=COUNTIF($A$2:$A$10,A1)
      row no A column Counts
      2 a 2
      3 b 2
      4 b 2
      5 c 1
      6 d 3
      7 d 3
      8 d 3
      9 a 2
      10 e 1
  • To post as a guest, your comment is unpublished.
    HARVIND · 4 years ago
    Hi , in below table some are appearing more than once, i need to catch them with number of appearance along with the series. like, B25 = 2. please help

    B25
    B17
    B9
    B15
    B1
    -
    B6
    B25
    B4
    B8
    B4
    B3
    B21
    B7
    B18
    B20
    B5
    B22
    B16
    B14
  • To post as a guest, your comment is unpublished.
    Bernadette Wright · 4 years ago
    Super helpful -- thank you!!
  • To post as a guest, your comment is unpublished.
    Unni · 5 years ago
    Hi,

    Please help me to solve the below problem

    =COUNTIFS('Weld Map'!$O$6:$O$7105,"="&F2,'Weld Map'!$V$6:$V$7105,"=Rej*",'Weld Map'!$AL$6:$AL$7105,"=REJ*")

    I need to count the text "REJ" from columns "V" and "AL" under the criteria of a period between F1 and F2
    • To post as a guest, your comment is unpublished.
      Adrian · 4 years ago
      =COUNTIF(D9:AG9,"*REJ*")
  • To post as a guest, your comment is unpublished.
    Unni · 5 years ago
    Hi,

    Please help me to solve the below problem

    =COUNTIFS('Weld Map'!$O$6:$O$7105,"="&F2,'Weld Map'!$V$6:$V$7105,"=Rej*",'Weld Map'!$AL$6:$AL$7105,"=REJ*")

    I need to count the text "REJ" from columns "V" and "AL" under the criteria of a period between F1 and F2

    Thanks and regards
    • To post as a guest, your comment is unpublished.
      aNKIT · 5 years ago
      use this instead of yours

      =SUM(COUNTIFS(J1:J196,"agree",A1:A196,"yes"),COUNTIFS(J1:J196,"agree",A1:A196,"no"))
  • To post as a guest, your comment is unpublished.
    Rhytha · 5 years ago
    I appreciate for the Solution provided. It is very helpful.
  • To post as a guest, your comment is unpublished.
    Najam Ul Hassan · 5 years ago
    very nice formula for counting of duplicate. It is very helpful
    Thanks extend office team
  • To post as a guest, your comment is unpublished.
    Stefan · 5 years ago
    Thank you SO much for this post its exactly what I needed!

    Please could you tell me why your formula "=COUNTIF($A$2:$A2,A2)" didn't work as expected in my worksheet until I amended it to "=COUNTIF($A2:$A$2;A2)" ?
    i.e. switching the absolute references around

    Thanks in advance
  • To post as a guest, your comment is unpublished.
    Khan · 5 years ago
    Please help to resolve this issue

    site ID Supplier Line
    12 abc good
    12 VV good
    12 TT good

    site ID Supplier Line
    12 abc good

    Required Supplier Name - formula required to show "Multiple Suppliers" as against same site iD and line there are 3 different suppliers.

    Please help to resolve this issue.
  • To post as a guest, your comment is unpublished.
    mohammad · 6 years ago
    many many thanks :-)
  • To post as a guest, your comment is unpublished.
    Ash · 6 years ago
    Let say I have different number of PO's in column A but some numbers are the same how can I count the total number of PO without including the duplicate number?
    • To post as a guest, your comment is unpublished.
      Rupesh Brahme · 4 years ago
      use formula =SUMPRODUCT(1/COUNTIF(A1:A1483, A1:A1483&""))
      =1/sumproduct(1/countif(range, criteria))
      :-)
  • To post as a guest, your comment is unpublished.
    Fujilives · 6 years ago
    =COUNTIF($A$1:$A1,A1)

    This method for finding duplicates is amazing, because it allows you to do a simple filter on the column (just deselect 0 and 1) to show all 'duplicate entries' instead of 'entries that have duplicates'. What I mean by this, is I can then select ALL visible after the filter, and delete the entire rows, and be left with only a single entry of a row containing that item.

    For MANY projects, this is a fantastic way to filter things down quickly.
  • To post as a guest, your comment is unpublished.
    Brice · 6 years ago
    If you want to get a sum of duplicate values in a column(without counting the first one), try:
    =IF(COUNTIF($A$1:$A1,A1)-1>=1,1,0)

    For example, let's say that you have a same value 5 times. It will count 1 for each of the 4 duplicate values. Then, you just have to get a sum.
  • To post as a guest, your comment is unpublished.
    Amol · 6 years ago
    suppose there is a column which contains values as GR1, GR2, GR3 and so on..... but some also getting repeated again. how can i get the final count of the item. Like if it reaches to GR29, the the value should show as 29 in the formula cell
  • To post as a guest, your comment is unpublished.
    Harrison · 6 years ago
    I am trying to label an individual data point as "1"...and if it has a duplicate, it will label the duplicates as "0"...but it would still label at least one of the data points as "1". Example, I could have one PO number on a truck, or multiple.

    Thanks
  • To post as a guest, your comment is unpublished.
    NAVEEN · 6 years ago
    i had query regarding for eg: 1st sheet of work book 1st is column is with data received fruits, 2nd column is fruits names, 3rd column is for normal defects, 4th column is for Major Defects, 5th column is for Critical defects

    2nd sheet for Normal Defects,
    3rd sheet for Major Defects,
    4th sheet for Critical Defects,
    My query is when we are updating these above sheet it total count should be reflected in 1st by individual fruits and for individual defects.

    Regards,
    Naveen kumar
  • To post as a guest, your comment is unpublished.
    NAVEEN · 6 years ago
    hI

    In sheet1 we have three columns, 1st columns "fruits names" 2nd column Date of received, Name of supplies only to supplies and in 3rd 4th 5th columns are Normal defect, Major defects and Critical defects,all these in 1st sheet.

    in 2nd sheet, 3rd sheet, 4th sheet, saparetly post all of Normal defects in 2nd sheet, Major defects in 3rd sheet, critical defects in 4th sheet. when we are updating these sheet it automatically should update 1st individual in normal, Major, Critical.

    Thanks
    Naveen
  • To post as a guest, your comment is unpublished.
    Ajeet singh · 7 years ago
    Impotent work if duplicate value.
  • To post as a guest, your comment is unpublished.
    Gaurav Pahuja · 7 years ago
    easy to use and helpful..:-p
  • To post as a guest, your comment is unpublished.
    munish · 7 years ago
    easy and helpful in large working
  • To post as a guest, your comment is unpublished.
    Zana · 7 years ago
    Awesome, it's easy and useful. Thaks
  • To post as a guest, your comment is unpublished.
    Priyanka · 7 years ago
    Is there any other function or way to calculate the same..?? Because countif() slows down the functioning of the sheet. Please suggest.
    • To post as a guest, your comment is unpublished.
      Ankit · 7 years ago
      contact me @@ if u want stop duplicacy!! * conditional formating duplicate
    • To post as a guest, your comment is unpublished.
      Amol Chopade · 7 years ago
      More use of functions and formulas make worksheet slower. There is no method to solve it even i suggest you to use special paste option after using formulas and functions. It will solve your problem. Just use it "Alt+s+e+v". :-)
  • To post as a guest, your comment is unpublished.
    Adnan Khan · 7 years ago
    easy and good one :D