Hello all,
Have an interesting problem which I'm not able to dynamically solve for.
Sheet "Base" has raw attendance report from the system in the fixed format which cannot be altered. Sheet "Emp list" is the desired output which calculates the number of days present for each employee. Trying to make this dynamic and scalable.
Using "MS 365"
Bookmarks