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

[JIMMY7890]

The data is in the.xls format  having two coulms of floating data type.

[GerdW]

Hi Jimmy,

no, it's not in an "xls format"…

- ReadSpreadsheetFile will load a formatted text file with some delimiters between your data items

- NEVER compare floating point numbers for equality. You will find a lot of threads in this forum on exactly this matter…

- You're not a friend of the AutoCleanup tool? And you don't like snippets either?

When the first column contains just integer values I would go with Variant attributes. Each attribute would collect the "2nd row values" for a unique integer item…