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
Sulaymon Eshkabilov 2021 年 4 月 7 日
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