Easy Office
LCI Learning

Counting instances of Duplicate Invoice Nos. in Excel

CA Rishabh Pugalia (ExcelNext) , Last updated: 23 April 2013  
  Share


CASE STUDY: Counting instances of Duplicate Invoice Nos.

APPLICATION AREAS: Vendor Payment, Account Credits

SOLUTION: =COUNTIFS()

EXAMPLE:

Step 1:� Write =COUNTIFS(

Step 2:� Choose range of list. E.g. A4:A13


Step 3:� Press < >�< > and, (comma) after selecting the list range to lock its position and move on. E.g. $A$4:$A$13,

Step 4:� Choose the Invoice No. in the adjoining cell. E.g. A4

Step 5:� Press < > and copy-paste the formula in cells beneath.

Refer CA Rishabh Pugalia�s other contribution on Advanced Excel tricks- Articles | Videos


4 Likes   26729 Views

Comments


Related Articles


Loading