jeudi 28 mars 2019

IF + AND + Date range formula

I have a problem to create a formula so I want to ask you for your help. Excel sheet has 150 000 rows and with this formula I want to safe a time. I have a Date, Name and Status and I need to see in other cell which Name was 4x or more time in consecutive GOOD or OK

https://imgur.com/a/v45qlTT

I think IF + AND + DATE Range it’s enough, but I don’t know how to put it together.

Thanks a lot for your suggestions !

Aucun commentaire:

Enregistrer un commentaire