Hi,
Thanks for looking at my post.
Really appreciate if i get help on this post please
I have two sheets named as source and destination. What i am after is i wanted to add even rows together from row 2 and divide by number of times data available and transfer to destination please. Same thing for odd rows.
i.e I have data from row 2 till row 15, that is i have 7 blocks of data.
so it will be 25+21+5+5+2+1+5 = 64 divided by 7 will be 9.2. I wanted to transfer that 9.15 to destination please.
Same thing for 5+3+1+55+5+2+2 = 73 divided by 7 will be 10.4
Once data is added more i would like to take an average automatically please
Really appreciate if I get any help on this please.
Transfer average data
-
- 2StarLounger
- Posts: 153
- Joined: 31 Jan 2021, 09:12
Transfer average data
You do not have the required permissions to view the files attached to this post.
-
- Administrator
- Posts: 78790
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Transfer average data
In C2 on the destination sheet:
=AVERAGE(IF((source!$C$2:$C$1000<>"")*(MOD(ROW(source!$C$2:$C$1000),2)=MOD(ROW(),2)),source!$C$2:$C$1000))
Confirm with Ctrl+Shift+Enter, then fill down.
=AVERAGE(IF((source!$C$2:$C$1000<>"")*(MOD(ROW(source!$C$2:$C$1000),2)=MOD(ROW(),2)),source!$C$2:$C$1000))
Confirm with Ctrl+Shift+Enter, then fill down.
Best wishes,
Hans
Hans
-
- 2StarLounger
- Posts: 153
- Joined: 31 Jan 2021, 09:12
Re: Transfer average data
Fantastic Hans
Thanks a lot again
Thanks a lot again