Although this formula works smoothly in Excel and Google Sheets, there is a drawback. You need to change the cell number every time. That is why using this function is quite time-consuming.