Hi,
I'm updating a training record which is updated from time to time.
And by every end of the month, I need to prepare a report to show on the progress (how many gaps closed compared to previous month etc)
Not quite sure of how to go about this.
Thought of using Index/Match/TimeStamp I am just not sure..
Pls help! Thank you
Monthly Data Captured.JPG
Hi eridarl,
Welcome to the forum.
Basis your image, you need the formula in the below table in your image.. but today() will again change on next day.
Can you share some results manually and upload the workbook (not image) this time .. thanks.
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks