Hi
I have 4 Columns namely:
A: anchor(Ram, Rita, Gita)
B: System
C: Product
D: Value
Each of the anchor needs to update this sheet with information regarding B,C,D against their name. How can i find how many Anchors have left how cells as blank or not filled their information. Attached sheet...
Hey thanks this works awesome. Just 3 more doubts:
1. Wats an array formula?
2. Incase for certain cases, i want to define the name of the employee for a particular HM is it possible, for eg. employee name Abhishek or an employee id 1382 should have HM as Ashok.
3. Incase i want to learn more...
Hi All
I have uploaded the file here:
http://speedy.sh/x2gKp/Manpower-Dashboard-2.3.2012.xlsx
Sheet 1 is where i need to populate data of HM, and Sheet 2 has the HM Table.
Please help
Hi, the scenario is as under:
Employee: 1, (location- a, billing status- billed, project- z)
Employee: 2, (location- b, billing status- billed, project- y)........12000 + employees all with different permutation and combinations.
The HM will be as under:
Ram is the HM of all employees in...
Hi
I have data like of 12000+ employees, like their location, project, billing etc and for each of these employees i need to add data of who is their Head manager on the basis of a table.
The table will have data that if an employee belong to X location, Y project and Z billing status then...