“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

I am trying to calculate the average for every 3 rows of data and do it in each column separately. Not every 3 rows all calculating one average, but an average for every 3 rows, for just two cells of data.

Solved by F. D. in 13 mins

Hi, I need help to organize a data set.
I have 2500 rows of data, and every 3 rows correspond to one set of information. I would like them to be split into 3 columns.

Solved by E. J. in 25 mins

how do i calculate the NPV across two columns A and B and 36 rows, where column A has a spend across every row and Column B has a spend only for 3 random rows

Solved by T. C. in 11 mins

How can you sum up the Rows and Column number quickly in the Excel sheet?

Solved by G. H. in 17 mins

Working on an Excel spreadsheet in which I need to paste column results from one column to an adjacent column, skipping every 3 rows in the adjacent column repeatedly over the entire column.
Column A Column B
105 105
95
95 ....... etc

Solved by X. B. in 22 mins