Forum Discussion
muhammadwaseem
Aug 26, 2023Copper Contributor
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...
- Aug 27, 2023
See the attached version. It uses the formula that I proposed.
muhammadwaseem
Aug 27, 2023Copper Contributor
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
HansVogelaar
Aug 27, 2023MVP
See the attached version. It uses the formula that I proposed.
- muhammadwaseemAug 27, 2023Copper Contributorthank you sooo much for your kind words