Jun 16 2021 04:12 AM - edited Jun 16 2021 08:13 PM
Hi all
This is my attendance file. I have manually calculated and consolidated the absentees (C11:J11).
I want to calculate this automatically.
Pl help
Rensi
Jun 16 2021 05:00 AM
See the attached version.
Jun 16 2021 07:56 PM - edited Jun 16 2021 08:14 PM
Thankyou @Hans Vogelaar .
But I am not able to reproduce the formula (=_xlfn.TEXTJOIN(",",TRUE,IF(H$3:H$61="Ab",$B$3:$B$61,""))) Is it because I am working on Excel 2007 version?
When I add a new column and repeat the same , it shows "#Name?".
Sorry, I am not that familiar with Excel (could you share some help/document to explain this formula).
Rensi
Jun 16 2021 11:46 PM
TEXTJOIN is only available in Excel 2019 and 365, so it won't work in Excel 2007.
Because of that, you will have to use a custom VBA function.
The attached version is now a macro-enabled workbook, so you will have to enable macros when you open it.