Hi! I'm working on a Project where I intend to get a better overview of our Gym's Group training sessions.
My goal is to have 1 row containing only dates of january, 1 of february, etc
I have added a Picture for easier explanation.
Attachment 566532
Hi! I'm working on a Project where I intend to get a better overview of our Gym's Group training sessions.
My goal is to have 1 row containing only dates of january, 1 of february, etc
I have added a Picture for easier explanation.
Attachment 566532
Last edited by Aritase; 03-20-2018 at 02:31 PM.
- Formula cannot delete anything
- Attach sample Excel file with reflected structure and type of data (not a picture)
Thank you for the quick answer.
I have uploaded a Excel sample.
If there is no way of automatically deleting the information in a cell. Perhaps there is a way of making the text and background automatically turn white, if the date shown is different from the other dates?
And I still need a formula for "C3" that will make it use the last date of january shown in the Excel file, and continue With the first monday in february (In Our case, every monday of the year is shown here).
In my mind something similar to this could be written on the C3 cell: (=If A7 contain jan. then A7+7, if A7 contain feb. then A6+7)
I didn't say you cannot delete. I said FORMULA cannot delete.
If you want to delete use VBA (Excel Programming / VBA / Macros)
edit:
in attached file I cannot see the result what you want to achieve (preppare it manually if necessary)
Last edited by sandy666; 03-20-2018 at 03:43 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks