**Question description:**

*This user has given permission to use the problem statement for this blog.*

Hello!
There is a column with a certain number of rows in it. I need to calculate two averages: the average of every second row starting from the 1st one (aka the average of every odd-th cell) and the average of every second row starting from the 2nd one (aka the average of every even-th cell).
I got tangled up with =OFFSET...
Thanks!

Solved by C. J. in 37 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

User
17/12/2017 - 03:54

Hi!

User
17/12/2017 - 03:54

Let me sketch it up quick for you.

User
17/12/2017 - 03:56

Got it?

Excelchat Expert
17/12/2017 - 03:56

Okay

Excelchat Expert
17/12/2017 - 03:56

May i know your name?

User
17/12/2017 - 03:56

sure, i am Gábor

Excelchat Expert
17/12/2017 - 03:56

Hi m sudhans

User
17/12/2017 - 03:57

nice to meet you!

Excelchat Expert
17/12/2017 - 03:57

So you need only both the values

Excelchat Expert
17/12/2017 - 03:57

odd row's average

Excelchat Expert
17/12/2017 - 03:57

and for even too, right?

User
17/12/2017 - 03:58

yes

Excelchat Expert
17/12/2017 - 03:58

Great!

User
17/12/2017 - 03:59

i mean i would need the formula too

Excelchat Expert
17/12/2017 - 03:59

Yes Sure

Excelchat Expert
17/12/2017 - 03:59

Can you see the formula?

User
17/12/2017 - 04:00

This is the easy way, works if you have just a couple of values. I'd need something more scalabe, something that works with hundreds of cells in a column.

User
17/12/2017 - 04:00

*scalable

Excelchat Expert
17/12/2017 - 04:00

Okay you need dynamically

User
17/12/2017 - 04:00

yes, that's the word :)

Excelchat Expert
17/12/2017 - 04:01

OKAY, Gabor!

Excelchat Expert
17/12/2017 - 04:01

surely will do that, just give a while1

User
17/12/2017 - 04:01

sure thing

User
17/12/2017 - 04:04

i was trying average if mod row as array function, but the result even rows' average is simply not correct

Excelchat Expert
17/12/2017 - 04:04

Okay

User
17/12/2017 - 04:04

i guess i have to do something with offset, but not sure how

Excelchat Expert
17/12/2017 - 04:05

yes thats right i also figuring out that

Excelchat Expert
17/12/2017 - 04:05

just give a while

User
17/12/2017 - 04:05

take your time

Excelchat Expert
17/12/2017 - 04:05

if possible i would design a macro

User
17/12/2017 - 04:05

i'd rather not

Excelchat Expert
17/12/2017 - 04:05

Sure , Be with me

User
17/12/2017 - 04:05

okay

Excelchat Expert
17/12/2017 - 04:11

You there?

User
17/12/2017 - 04:14

yes

Excelchat Expert
17/12/2017 - 04:14

thank you

Excelchat Expert
17/12/2017 - 04:14

just a bit while more

User
17/12/2017 - 04:14

okay, no rush

User
17/12/2017 - 04:19

okay, i think i got it

Excelchat Expert
17/12/2017 - 04:19

Okay

Excelchat Expert
17/12/2017 - 04:19

are you sure i have written the code

User
17/12/2017 - 04:19

I'd like to take a look at it then :)

Excelchat Expert
17/12/2017 - 04:20

yes sure

Excelchat Expert
17/12/2017 - 04:20

just be a while or share me you mail id i can drop yo there!

User
17/12/2017 - 04:21

orrverzes@gmail.com

Excelchat Expert
17/12/2017 - 04:23

Sure thankyou

Excelchat Expert
17/12/2017 - 04:23

Please do a valuable rating that would help me a lot

Excelchat Expert
17/12/2017 - 04:25

Are you there

Excelchat Expert
17/12/2017 - 04:25

m done

User
17/12/2017 - 04:25

I am, and i will :)

Excelchat Expert
17/12/2017 - 04:26

thankyou

User
17/12/2017 - 04:26

i haven't received the mail yet

Excelchat Expert
17/12/2017 - 04:27

you will get it in 15 minutes

Excelchat Expert
17/12/2017 - 04:27

Server is getting tangled

User
17/12/2017 - 04:28

Okaz then

User
17/12/2017 - 04:28

Okay*

User
17/12/2017 - 04:28

thank you for your assistance!

Excelchat Expert
17/12/2017 - 04:28

yup

Excelchat Expert
17/12/2017 - 04:29

sure that in that sheet u just need to keep your numbers and hit a button it will automatically give you the result

User
17/12/2017 - 04:30

great!

User
17/12/2017 - 04:31

thank you then

User
17/12/2017 - 04:31

have a nice day

User
17/12/2017 - 04:31

bye

Excelchat Expert
17/12/2017 - 04:31

Have a nice day to you too

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*