How to average values corresponding to repeated values in a column.

[JIMMY7890]

I am able to remove the duplicate the repeated entries, but I want to average the corresponding entries and save the new data file.

[P@Anand]

I don't understand what you meant here. Are you trying to remove duplicate entries and find the average of it? Isn't it the same? Explain what do you want to write into the file.

[PalanivelThiruvenkadam]

Try to index all deleted values of same entries in an array and find the average of it

[PalanivelThiruvenkadam]

Logic has to be implemented for different duplicate entries...

[JIMMY7890]

I have 2d array with some repeated entries in 1st column, I want to take the average of the corresponding values in the 2nd column for repeated entries.
E.g: 1 10
2 20
2 22
3 30....
And I want the output to show
1 10
2 21
3 30....

[PalanivelThiruvenkadam]

Just combine all the duplication values with numbers for corresponding duplications
Then find the average of the same.

[AYanez]

Which datatype is your array?. Integer numbers like I 32 or string array. You can use a Variant Approach to do the task. But some number could be round to the nearest.

[ben64]

Can you show us what you've tried?

Spoiler

This is an excellent array manipulation exercise!

Ben64

[ben64]

Possible solution. A knight will probably ashame us again

Ben64

[JIMMY7890]

I  was trying this.