Reading excel for for a particular date range and output the max corresponding value.

1 次查看（过去 30 天）
Rahul Kesarkar
Rahul Kesarkar 2021-4-7
评论： Rahul Kesarkar 2021-4-7
I want to write a script where, it has to read thrrough the excel file and find the highest value and its coresponding date and time.
For example date format dd:mm:yyyy hh:mm in column 1 and coulmn 2 has the data, the script needs to surf through the data and provide me the highest value and coressponding date and time. Assign this value ass 100% so the rest of the values ill b on bassis of this. If the highest values is 25 then 25 will be 100% and if the next hour has 22 then it should be aloted as 80%.

请先登录，再回答此问题。

回答（1 个）

Sulaymon Eshkabilov
An easy solution is: sortrows()

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by