Share on Facebook

Share on Twitter

Share on LinkedIn

Share on Email

Share More

CASE STUDY: Counting instances of Duplicate Invoice Nos.

APPLICATION AREAS: Vendor Payment, Account Credits



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   66 Shares   22740 Views


Related Articles


Popular Articles

Follow Book Book GST Live Course Book Business Course caclubindia books

CCI Articles

submit article

Stay updated with latest Articles!