poonawalla

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


 

4 Likes   66 Shares   22740 Views

Comments


Related Articles


Loading



Popular Articles




Follow Book Book GST Live Course Book Business Course caclubindia books


CCI Articles

submit article

Stay updated with latest Articles!




update