![Comment_Icon_black](https://blog.octanesolutions.com.au/hubfs/Imported_Blog_Media/Mode_Comment_Icon_black%20(1).webp)
![Comment_Icon_black](https://blog.octanesolutions.com.au/hubfs/Imported_Blog_Media/Calendar_Regular_Icon_1%20(1).webp)
![Alarm_Icon_1](https://blog.octanesolutions.com.au/hubfs/Imported_Blog_Media/Alarm_Icon_1%20(1).webp)
In this blog post, I aim to demonstrate a simple yet effective technique to display the members returned by a set as a list in Excel. This serves as a quick and efficient method for analysing the results from your static or MDX-based sets. This approach offers an alternative to using the TM1ELLIST function in Planning Analytics for Excel (PAfE), which also returns an array of members based on MDX expression or a set. However, the TM1ELLIST function requires the user to manually enter the formula to view the results and it does not support hierarchies. When you add a SUBNM or TM1Set function ...
![Line_2015](https://blog.octanesolutions.com.au/hubfs/Imported_Blog_Media/Line%2015-svg%20(1).webp)