How to find aximum value in a particular day

Want to find a maximum value for a particular day and if that value is more than 0.1 then i have take that value with corresponding other values in the same line

This is how my data looks like

1. time

2. prn

3. day

4. tec

5. rot

now

17.8152780000000 1 1 0.0299329491029012 0.0238570000000000

17.8819440000000 1 1 0.0361110886425115 0.0165560000000000

17.9486110000000 1 1 0.0609912912295436 0.0143080000000000

18.0152780000000 1 1 0.0525351996648996 0.00938500000000000

18.0819440000000 1 1 0.0458706181346478 0.00502800000000000

18.1486110000000 1 1 0.0458695507597667 0.00665000000000000

18.2152780000000 1 1 0.0516134215864671 0.0116360000000000

18.2819440000000 1 1 0.0316242692661046 0.00635400000000000

18.3486110000000 1 1 0.0361103841317258 0.0158660000000000

18.4152780000000 1 1 0.0453422293504342 0.0145850000000000

18.4819440000000 1 1 0.0596673580349598 0.0237340000000000

18.5486110000000 1 1 0.0475831349854618 0.0122550000000000

18.6486110000000 1 1 5.99231716569814 0.482069000000000

18.7486110000000 1 1 15.2063246834517 0.473571000000000

18.8386110000000 1 1 22.1305951631731 0.716901000000000

i want like ths, maximum value of rot in a particular day that is greater than 0.1

18.8386110000000 1 1 22.1305951631731 0.716901000000000

Answer 1

[Image Analyst]

Did you try groupsummary? Something like (untested)

dayNumber = data(:, 3);
rot = data(:, 5);
dailyMaxima = groupsummary(rot, dayNumber, 'max');

If you have any more questions, then attach your data and code to read it in with the paperclip icon after you read this:

TUTORIAL: How to ask a question (on Answers) and get a fast answer