Pick The Absent Days From The Attendance Report And It Separated With Coma

[binoyfalcon]

Dear friends,

please help.
pick the absent dates from the report.

 

[pecoflyer]

Please post a sample sheet. Pictures are quite useless to work with

 

[vletm]

binoyfalcon​

Here one sample based Your picture:
A-column has those absent dates - You name one, but normally there are many of those.
AL-column has the 'result'.
You can see a sample code right side.

As written in previous post ... it could be smoother for You to post a sample file.

 

[Marc L]

Hello, according to the initial post picture assuming 'EMPLOYEE NAME' is in cell A3 a formula VBA demonstration for starters :​

Do you like it ? So thanks to click on bottom right Like !​

​