I have a huge data and the following image is a part of my data,
First column is always a natural number (not necessary consecutive) and for the rows which have the same first column data I want to find the average of each of its next column data. For example first three cells on the first column is 142 and I want to find the average of next three cells of each next columns. Since I have lot’s of data I want to make this process automatic I tried “AVERAGEIF” formula but with no result. Can you please help me?
