Filtering Table Data for highest recording with multiple samples per day
2 views (last 30 days)
I have a table with two colomns inside. The first colomn are dates and the second colomn are heights. I am trying to filter data by the date by keeping the highest height on that specific date.
For example: In the image below I have multiple data recordings of 01-Aug-1629 and I want to keep the highest amplitude. Then repeate that same process for 17-Feb-1674.