Forum Discussion
Jeev125
Aug 18, 2020Copper Contributor
Need help with excel
I have 2 sets of data wherein in need to find,\ if Indicator indicates alarm then it needs to calculate time difference between the time its start STOPPED to ALARM and ALARM TO MOVING as per Indicat...
Ramiz_Assaf
Aug 18, 2020Iron Contributor
I am feeling you need to update your excel file,
anyways, here is the formulas that find the last stopped if alarm and the last alarm if moving,
If you need the id just add it using and AND()
Jeev125
Aug 18, 2020Copper Contributor
- Ramiz_AssafAug 19, 2020Iron ContributorPlease take a minute to indicate it is an acceptable solution so we can close the thread
- Jeev125Aug 19, 2020Copper Contributor
- Ramiz_AssafAug 19, 2020Iron Contributoryou need to indicate that, not me 🙂