# Excel - COLUMN Function Problem - Expert Solution

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
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
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
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.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.