Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hi, I have a column of about 300 cells in excel. I am trying to average every 10 cells in the column, starting on the

Hi, I have a column of about 300 cells in excel. I am trying to average every 10 cells in the column, starting on the second row (ie A2-A11, A12-A21, A22-A31, etc) and place each average in another column (A2-A11 in B2, A12-A21 in B3, etc). It would be very tedious to do this without a formula so if you could provide one that'd be great!

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

Locate the centroid (x, y) of the compositearea. -3 ft 1.5 ft 1 ft

Answered: 1 week ago

Question

How is intelligence defined?

Answered: 1 week ago