Got another problem at hand which the excelforum community may be able to help me with! Want to thank everyone for this platform.

I created a searchable drop down list in a combo box with this method: https://www.extendoffice.com/documen...st-search.html

This method is using countifs and a named range, with a bit of VBA to create the search drop down element.

However, due to the countif formulas (and the other formulas), my spreadsheet becomes very slow as I have approx. 500 data sets to search from.

Could anyone advise how I could get this to work more smoothly? Or if there are any other methods?

Thanks!