Forum Discussion
Solved
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 u...
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.
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.
- Oh my goodness... It's so much simpler. Thanks a lot for your help. Really appreciate it.
