is it possible to scan e.g. 100 excel files and detetct the maximum values of each?
in one file there are many distance values registered, so the goal is to extract the maximum distance per file.
--> file_1,max: 3 cm
file_2,max: 5 cm
file_3,max: 7 cm
file_100,max: 4 cm
And then I want to create a diagram out of these maximum datas which is not a big issue. The main task is to generate the maximum values of the files.