CA Rishabh Pugalia (ExcelNext)
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
CAclubindia
