Forum Discussion

Marques_960's avatar
Marques_960
Copper Contributor
May 30, 2023

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 that dont have associated a date in the dirty front. The ChatGPT had suggested me that function " =SE(B2>A2;B2;A2)
"

I hope that anyone can help me :)) Thank you ❤️

 

excel
  • OliverScheurich's avatar
    OliverScheurich
    Gold Contributor
    May 30, 2023

    Marques_960 

    =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.

Resources