Forum Discussion
Solved
I have a huge data to calculate its average 59 values in one cell then 59 values next to previous
I wanted a formula to complete my work I got a data which is huge in row but i just wanted its first 59 values average then that rows second 59 values average and soo on utill data ended he...
See the attached version. It uses the formula that I proposed.
Why do you have 0:00 to 23:00 (i.e. hours) if you want the time in minutes?
- im take 59 sec values which you can see in B row and getting average of 59 sec values
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
Visit this link
https://drive.google.com/drive/folders/1No7an3W9-xj1Rnxfw2aLvTsscZIm_xdrHansVogelaar
and if you dont understand plz see the formula i applied i need Quick formula to complete it on time