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.
