From Friday, April 19th (11:00 PM CDT) through Saturday, April 20th (2:00 PM CDT), 2024, ni.com will undergo system upgrades that may result in temporary service interruption.

We appreciate your patience as we improve our online experience.

LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

0 Kudos
Message 11 of 12
(789 Views)

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…

Best regards,
GerdW


using LV2016/2019/2021 on Win10/11+cRIO, TestStand2016/2019
0 Kudos
Message 12 of 12
(781 Views)