[Solved] Data Manipulation, Hourly Basis

Dear,

I am attaching a file which have certain readings every hour daily. I want to find out how to calculate no of hours when

1. FT1003 (Column C in SO2 Sheet) value was increasing
2. FT1003 (Column C in SO2 Sheet) value was not increasing
3. P101 (Column D in SO2 Sheet) value was "TRUE"
4. P101 (Column D in SO2 Sheet) value was "FALSE"

Kindly help me to calculate the data,

Regards,
 
Dear, mfaisal.ce
Please check this below file.
We hope, this will solve your issue.
Thank you so much.
 

Attachments

  • File.xlsm
    52.9 KB · Views: 2
Dear, mfaisal.ce
Please check this below file.
We hope, this will solve your issue.
Thank you so much.
Thanks dear,

But i need result in some different way.

I need to calculate
1. No. of hours when Column C (FT1003) value increased than previous value.
2. No. of hours when Column C (FT1003) value decreased than previous value.

regards,
Muhammad Faisal
 
Dear,

Please find attached. I tried to give value as expected in Column E based on Column C value when it increasing or when it remains same to calculate no. of hrs

Hopefully, i explained

Regards,

Dear Faisal,

Can you put the expected values in Column E, then upload your Excel file again?

Best Regards,
Yousuf Shovo
 

Attachments

  • File.xlsm
    43.8 KB · Views: 1
Please find attached. I tried to give value as expected in Column E based on Column C value when it increasing or when it remains same to calculate no. of hrs
Dear Faisal,

Thank you for the expected results. I found a way to solve this. See the attached file and let me know if it works.

Best Regards,
Yousuf Shovon
 

Attachments

  • File.xlsm
    50 KB · Views: 3
Dear Faisal,

Thank you for the expected results. I found a way to solve this. See the attached file and let me know if it works.

Best Regards,
Yousuf Shovon
Dear,

Thanks for your help & support. Can u please explain the Function block you made? When i try to change the range, it is giving me error. Moreover, it is possible to make the function dynamic (Means if i delete the row in range or add any new row in range, it will update the function itself)

Regards,
 
Dear,

Thanks for your help & support. Can u please explain the Function block you made? When i try to change the range, it is giving me error. Moreover, it is possible to make the function dynamic (Means if i delete the row in range or add any new row in range, it will update the function itself)

Regards,
Dear Faisal,

on VBA, I added a Change event on the SO sheet to "force" calculate. See the attached Excel file for the desired dynamic function.

Regards,
Yousuf Shovon
 

Attachments

  • Faisal.xlsm
    51.2 KB · Views: 7

Online statistics

Members online
0
Guests online
1
Total visitors
1

Forum statistics

Threads
287
Messages
1,240
Members
508
Latest member
HaroldDyeme
Top