Forum Discussion
Excel send serial number
Hello guys! I need help of someone to solve that. I have column with the serial number in my company and another with the date. And I want to creat a function that send me all the serial numbers t...
=SE.ERRO(ÍNDICE($A$2:$A$13;MENOR(SE($B$2:$B$13="";LIN($B$2:$B$13)-1);LIN(1:1)));"")=SEERRO(ÍNDICE($A$2:$A$13;MENOR(SE($B$2:$B$13="";LIN($B$2:$B$13)-1);LIN(1:1)));"")An alternative could be this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021. The formula is in cell D2 and filled down to cell D8.