banner_ad

CAclubindia Articles


Identify duplicate names in data base using vlookup in excel

Posted by CA ROSHAN TIWARI 24 February 2014 37021 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



Section 234E Cracked

Posted by Dingu 24 February 2014 47122 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 392638 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



Highlight and Some question of Company ACT 2013

Posted by Binod 24 February 2014 52184 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



Beware !! Another Fraud in the Air !!

Posted by Prof. Bajaj 24 February 2014 18245 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



Taxability of Foreign companies in recent times

Posted by CA. Kunal Lakhotia 24 February 2014 14522 Views

Controversy on taxability of Engineering Procurement & Construction (EPC) company EPC companies are those which design the installation, procure the necessary materials and build the project, either directly or by subcontracting par



One to one interaction of ICAI President with CAclubindia

Posted by Guest 20 February 2014 31253 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



Proposed DTC is anti-reform

Posted by CA Anil Garg 20 February 2014 12537 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



So, how do we solve our problems in India

Posted by CA Anil Garg 20 February 2014 12863 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



Application of AS-22 in AS-19

Posted by ESHA AGRAWAL 20 February 2014 30050 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




Popular Articles





CCI Pro
Meet our CAclubindia PRO Members

Follow us
add to google news

CCI Articles

submit article



Company
ARTICLESHIP 14 May 2026
CA ARTICLE

PRAVEEN GARG & CO

Faridabad

CA Foundation

View Details
Company
23 May 2026
Article Assistant

Geeta Manchanda & CO.

New Delhi

CA Inter

View Details
Company
18 May 2026
MIS Executive

Primarc Pecan Retail Limited

Mumbai

B.Com

View Details
Company
22 May 2026
Audit assistant

Displayandbeyond

Mumbai

CA

View Details
Company
01 May 2026
Chartered Accountant

Agrawal Jain & Co.

Raipur

CA

View Details
Company
08 May 2026
Paid Assistants

Quick Taxperts Private Limited

Bengaluru

Graduate (Any)

View Details
Company
23 May 2026
Account Executive

SMJ global advisors pvt ltd

New Delhi

B.Com

View Details
Company
14 May 2026
Senior Associate

ABHISHEK SHANKAR AGARWAL & ASSOCIATES

Kolkata

CA

View Details