There is no such function in Excel and to workaround this problem you have two options: help yourself using VBA (solution from here), consider using a plugin (spending 39 USD), i.e. Kutools for Exc…