GST Course

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

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


Tags :



Category Students, Other Articles by - CA Rishabh Pugalia (ExcelNext) 



Comments


update