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