excelhelpplz
New Member
- Joined
- Apr 16, 2014
- Messages
- 8
Hello All,
I am using Excel 97, Windows XP. I need help in counting. Sample of my data is given below:
In total i have 14 sheets. Each of the sheet have data in 16,000 rows (in the format mentioned above). I have to count number of directors for each of the company and write number in column 5 in the same row in which company name is given in column 1.
Please, help me. I tried it manually but it is taking so much of time. Then i found this website. I hope i will get good help from you as you all are expert in excel.
Thanks a lot...
I am using Excel 97, Windows XP. I need help in counting. Sample of my data is given below:
Column 1 | Column 2 | Column 3 | Column 4 | Column 5 |
Company Name | Date | Director Name | Director Designation | No. of Directors |
20 Microns Ltd. | 3/31/2002 | Chandresh Parikh | Chairperson & Managing Director | ? |
Bhupendra B Parikh | Vice Chairperson | |||
Bhanu B Patel | Chairperson Emeritus | |||
Dhimant B Parikh | Executive Director | |||
Rajesh Parikh | Executive Director | |||
Sudhir R Parikh | Executive Director | |||
Darshana Mankad (Mrs.) | Director | |||
Sanatkumar P Dave | Director | |||
Vishnu Varshney | Director (GVFL) | |||
Dhruva S Chaudhri | Director (GVFL) | |||
Lalita D Sharma (Mrs.) | Director (IDBI) | |||
Vitthaldas D Talati | Director & Co. Secretary | |||
A G C Networks Ltd. | 3/31/2002 | K A Chaukar | Chairperson | ? |
Niru Mehta | Vice Chairperson | |||
Horatio Wong | Director | |||
S Chandrasekhar | Director | |||
S Ramakrishan | Director | |||
N Srinath | Director | |||
Pradeep Mallick | Director | |||
C B Bhave | Director | |||
A M L Steel Ltd. | 3/31/2002 | R R Agarwal | Chairperson | ? |
Poonam Chand Jangir | Director | |||
Ajay Agarwal | Director | |||
A V T Natural Products Ltd. | 3/31/2002 | Ajit Thomas | Chairperson | ? |
M S A Kumar | Executive Director | |||
M A Alagappan | Director | |||
Shyam B Ghia | Director | |||
Habib Hussain | Director |
Please, help me. I tried it manually but it is taking so much of time. Then i found this website. I hope i will get good help from you as you all are expert in excel.
Thanks a lot...
Last edited: