Forum Discussion
I have a huge data to calculate its average 59 values in one cell then 59 values next to previous
- Aug 27, 2023
See the attached version. It uses the formula that I proposed.
Hello there muhammadwaseem!
I hope the day finds you well. It Looks like you still need an answer so let me try and help you. First, we need a base understanding of some parameters and set
standards for our communication.
I've noticed a couple of points so we can make a good start 😌
1. We need the workbook to be in the same edition, e.g. latest. I'll provide you with an example just in case.
2. We need to have the same formatted time. I suggest having a look into it by checking this https://www.ablebits.com/office-addins-blog/excel-time-format/ .
a good read and there is a https://cdn.ablebits.com/excel-tutorials-examples/excel-time-format.xlsx workbook.
3. Looks like you have alot of differently formatted cells, clean those up to having the same format. Sometimes this causes errors in your desired result.
EDIT: I didn't see the last posts but there is still good info to be had here so i'll leave it there. Good luck in your journey