# Looking for Absentees

• Hello,

I am looking for someone helping me to solve my attendance sheet where I can't get the Absentees based on the aqttendance date.

I have tried using vlookup but it is also very upsetting.

Attached here with my worksheet.

I would be very pleased and would appreciate your help. Thank you so much.

## Files

• ABSENTEES.xlsx

(13.57 kB, downloaded 16 times, last: )
• Greeting Sir,

Thank you for replying my attachment. Once again I attached my work sheet for you to see.

I have tried using Unique Name List and V Lookup but it does'nt show the correct result.

Thank you very much for your kind help.

1. COLUMN B is a range of Staffs name List with 40 staffs.

2. COLUMN C is a range of daily Attendance based on the Time and Date at COLUMN D : G

3. What Formula do we use to determind the daily ABSENTEES at COLUMN "H" based on the specific Date from CLOUMN ''G" ?

## Files

• ABSENTEES.xlsx

(14.25 kB, downloaded 12 times, last: )
• Since you still have not explained your logic for solving column H, suggest you manually mock up your worksheet with the correct answer for column H. I still do not understand your logic as you have repeated in your latest post exactly what you have in the first post. If you were to do this manually on a sheet of paper how would you determine the answer.

• Good day Sir,

Here I forward my worksheet that has my formula for your attention. Thank you for your support sir.

## Files

• ABSENTEES.xlsx

(15.48 kB, downloaded 15 times, last: )
• Here is a VBA solution. I do not have a Formula solution for you.

• Goodday Sir,

Thank you very much for your feedback which I find I am almost solving my Absentees Worksheet.

I have applied the VBA Code but I feel very sorry I can’t make it working. Once again I really hope you could

Help me to see to my worksheet where the absentees on the specific date are to be placed in column H accordingly.

Thanks again . God bless!

## Files

• Your request is not clear - even after all the toing and froing in the thread.

But, any sensible absentee reporting would be by date, so see this solution of absentees for each date:

ABSENTEES.xlsx

Cheers, Glenn.

Beauty is in the eye of the beer-holder.