petitallien
New Member
- Joined
- Dec 12, 2020
- Messages
- 8
- Office Version
- 2019
- Platform
- Windows
Good evening,
I work in scheduling. I spend a fair amount of time converting a schedule every day. I am sure I have a pic-nic (problem in chair, not in Computer) moment. I am confident to excel can help.
Let me explain:
I have a schedule organized by date(Column A), with Crew associated to ships Column B to Column E (there are many more in the full sheet), and I need to get the table on the right where the same information is organized differently. I struggle to find the formulas for Columns M and Column N. I would also much prefer to stay with Formulas as the file may not be by computer savvy operators, and I am not good enough to understand it.
Any Bright genius who would take the challenge?
I work in scheduling. I spend a fair amount of time converting a schedule every day. I am sure I have a pic-nic (problem in chair, not in Computer) moment. I am confident to excel can help.
Let me explain:
I have a schedule organized by date(Column A), with Crew associated to ships Column B to Column E (there are many more in the full sheet), and I need to get the table on the right where the same information is organized differently. I struggle to find the formulas for Columns M and Column N. I would also much prefer to stay with Formulas as the file may not be by computer savvy operators, and I am not good enough to understand it.
Any Bright genius who would take the challenge?