Hi,
I would like to try and edit this formula to return non blank cells for a dropdown list:
The range that I would like to omit the blanks from is Results!$A$2:$S$183.Please Login or Register to view this content.
I also cannot use an array formula as I need to put this formula in the source field for the dropdown.
Thanks
*NB Please note that I have also posted this question in another forum but have not had a response so thought I would try here as well:
https://www.mrexcel.com/forum/excel-...ml#post5320718
Bookmarks