Jun 26 2021 02:42 AM
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.
Jun 26 2021 03:18 AM
Jun 26 2021 03:34 AM
SolutionI 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.
Jun 26 2021 03:41 AM
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?
Jun 26 2021 04:13 AM
Here is the version using the FILTER function.
Jun 26 2021 04:17 AM
Jun 26 2021 03:34 AM
SolutionI 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.