Attendance in percentage

[shivya]

I have 3 sheets in my workbook
1 sheet is the details of employee
2 sheet is the attendance
in 3 sheet, i want the average of attendance for each person

Make Sure the employee code and employee name does match.

There are some duplicates in employee code

 

[Pecoflyer]

Hello
is this some kind of homework?

 

[shivya]

No. This is dummy data.

 

[p45cal]

C2:
=COUNTIF(INDEX(Attendance!$C$3:$H$51,MATCH(A2,Attendance!$A$3:$A$51,0),0),"p")/6
Copy down. Format the cells as percentage.

EmpIDs 11 and 12 don't match with what's on the Emp Details sheet.

 

[Logit]

.
And, if you enter the VLOOKUP formula in F2 and drag down :

=VLOOKUP(E2,B2:C148, 2,FALSE)

You can get a summary :

	A​	B​	C​	D​	E​	F​
1​	Emp Id	Emp Name	Attendence(%)		Emp Name	Attendence(%)
2​	001​	shweta	33.33%​		shweta	33.33%​
3​	002​	shivya	33.33%​		shivya	33.33%​
4​	003​	neha	66.67%​		neha	66.67%​
5​	004​	sonia	66.67%​		sonia	66.67%​
6​	005​	neelam	83.33%​		neelam	83.33%​
7​	006​	anju	66.67%​		anju	66.67%​
8​	007​	divya	33.33%​		divya	33.33%​
9​	008​	jyoti	66.67%​		jyoti	66.67%​
10​	009​	princy	50.00%​		princy	50.00%​
11​	010​	nikita	66.67%​		nikita	66.67%​
12​	011​	rubi	83.33%​		rubi	83.33%​
13​	012​	neeru	66.67%​		neeru	66.67%​
14​	013​	ekta	33.33%​		ekta	33.33%​
15​	014​	shweta	50.00%​		renu	83.33%​
16​	015​	neha	83.33%​		pragya	66.67%​
17​	016​	sonia	66.67%​		preeta	50.00%​
18​	017​	neelam	50.00%​
19​	018​	anju	66.67%​

​

 

[TashaA2438]

I would try the vlookup method listed above as well. All you need to do is go to the formulas tab on your excel application, under the function library group click lookup & reference and the click vlookup. Set your lookup_value as well as your table_array. Click product information sheet tab and select your range. In the col_index_num box input the row in which the information is to be found and then click ok. This should give you what you are looking for.

I hope this helps

tashaa2438:d