Hi everybody,
I hope some excel wizard is able to help me with this small task for my training program.
What I’m trying to make is a list with 3 or more options (Example: Sum, Pass 1 and Pass 2 and so on) Sum is the total workout of the two or more passes. Each pass (could be running) would contain the cells distance, kcal, zone, time, min/km and intensity where only distance and time should be fill out and intensity, which also is a list, a predefined values chosen. The rest of the cells will automatically be filled out duo to the other cells.
The means that Sum is empty in the beginning, but when pass 1 is filled out, Sum is equal to pass 1. When pass 2 is filled out, Sum is equal to pass 1 and 2 put together.
When Pass 1 or any other pass from the list is chosen, the cells are empty with the default numbers.
See screenshot with the current setup (WIP)
Hope it make sans.
Regards
Zanno, Denmark
Bookmarks