Forum Discussion
Formula to create a dynamic checklist
Hi,
I have been trying to generate a dynamic checklist based on the maintenance schedule as shown in the attached excel file "Maintenance Dynamic checklist". The 'X' indicates the tasks required under the specific scheduled maintenance. The second table in the spreadsheet shows the outcome I would like to achieve: It should retrieve the Task ID and the Task Description based on droplist in N1. All blanks row to be excluded. I hope the community could help me in this solution. Thanks.
I have attached a solution that will work in all versions of Excel.
If you have Excel in Microsoft 365, you can use a much simpler formula with the new FILTER function.
5 Replies
I have attached a solution that will work in all versions of Excel.
If you have Excel in Microsoft 365, you can use a much simpler formula with the new FILTER function.
Wow, thanks for solution. It looks complicated. My workplace is using the older version of excel. However, I have subscribed to 365. For learning purpose, could you share the simpler solutions for 365?
Here is the version using the FILTER function.
- Hi choongko
Tbh, I have problems on understand detailed what you want :'D
Can you try to be more precise with maybe an example. 🙂
Schnittlauch ^^
