selecting and use cells with the same value

[keis386]

Dear sir/madam

You begin by looking to the value of the first cell in column B now you have to look if there are other cells in column B with the same value.

2. if you found cells with the same value you go one cell to the right (so to column C) and you have to look to the value of that cell(s)

3. Now sum up the the numbers of the selected cells of column C and divide them by the number of cells you selected. This value is the answer.

I have attached my excel file

I really tried a lot so I hope that someone can help me!

[watersev]

hi, keis386, please check attachment, result in Column E, done with formula, hope this helps

[keis386]

Thanks for helping me! It is not completly what i wanted, because in most cases there are multiple cells with the same value. The answer here is 0 or 1 so there is only 1 cell that you selected. You select a cell if it has the same value as cell b3. Then you go one to the right to column c. Then you have to sum up the values of all the selected cells and divide it by the number of cells you selected.

[watersev]

can you provide a couple of calculation examples basing on the posted workbook?

[keis386]

In the attached file there are a few examples

[snb]

I think you better use afronden() and somproduct.
Cfr the attachment.