CAclubindia Articles

Identify duplicate names in data base using vlookup in excel

Posted by CA ROSHAN TIWARI 01 August 2020 37074 Views

SAMPLE DATA IS GIVEN BELOW :WRITE THE NAME YOU WANT TO CHECK FOR DUPLICATE ENTRY IN CELL C4 AS SHOWN BELOW :WRITE THE FORMULA IN CELL D7 & COPY IT FOR CELL ADDRESS AS SHOWN BELOW :WRITE THE FORMULA OF VLOOKUP IN CELL D4 AS SHOWN BELOW :IF THE N

One to one interaction of ICAI President with CAclubindia

Posted by Guest 20 February 2014 31282 Views

CAclubindia welcomes you all. We are here with our New ICAI President CA. K. Raghu. A worthy combination of youth, dynamism, experience and excellence, CA. K Raghu has taken over as the supreme torch-bearer of Indian accountancy profession as the Pre

Section 234E Cracked

Posted by Dingu 24 February 2014 47156 Views

Of late this month we must have received lot of demand from CPC seeking demand for non remittance of 234E FEES (not Tax). Well here is something to crunch on 234E will not apply to cases where TDS payment is made beyond the time limit prescribed for

Resolutions under the Companies Act, 2013

Posted by Vandana J Doshi 24 February 2014 392745 Views

Before going further, first of all let us understand what a Resolution is. A Company being an artificial person, any decision taken by it shall be in the form of a Resolution. Accordingly, a resolution may be

Proposed DTC is anti-reform

Posted by CA Anil Garg 20 February 2014 12550 Views

Income Tax law must have suffered the most volatility and changes since enactment in 1961. Government has been twisting it at will in order to extract more and more revenue. This must have the dubious distinction of being subject matter of highest li

Application of AS-22 in AS-19

Posted by ESHA AGRAWAL 20 February 2014 30082 Views

Hello everyone thanks for the appreciation for my last article why AS 22 is applied, coming with another article application of AS-22 in AS -19 leases. I am writing this article to discuss with

How to read and Understand CA/CMA/CS Exam Questions?

Posted by CMA Raveendranath 20 February 2014 34996 Views

In my continuous efforts to address many issues faced by students appearing for professional exams, I found that majority of students doesnt read and understand the questions properly before t

Highlight and Some question of Company ACT 2013

Posted by Binod 24 February 2014 52204 Views

Concept of independent director under new company act vs Co act 1956 Ans. 1. directors: Under Section 149 of the 2013 Act, there is a specific obligation on every listed public company that at least one-third of the board of directors should c

So, how do we solve our problems in India

Posted by CA Anil Garg 20 February 2014 12879 Views

Every 6th person in the world is an Indian. We are blessed with ancient civilization. History tells us that we have never been expansionists and have never attacked other countries. We have been happy to live within our borders and yet, we are afflic

Beware !! Another Fraud in the Air !!

Posted by Prof. Bajaj 24 February 2014 18278 Views

Mr. Rajeev Kumar, a Chartered Accountant, working with a leading Automobile company was worried about his insurance policy. He had bought an insurance-cum-investment plan from a company (say K) 3 years back with an annual premium of Rs