gravanoc
Active Member
- Joined
- Oct 20, 2015
- Messages
- 351
- Office Version
- 365
- Platform
- Windows
- Mobile
I have a table of forex currency data where the first column is a date time combination, i.e. 1/2/2022 17:30. I want to use MINIFS to determine the lowest number on a specific day that falls within the 3rd column, Low. Is there a way to specify this, for example on 4/5/22? My current workaround involves creating a new table and using Find and Replace to remove the time component. Then, MINIFS (tblData[Time], tblData[Low], B3) will work, where B3 is 4/5/22. What I'm looking for would somehow apply INT to the Time column in conjunction with MINIFS, but I'm not sure how.