I am creating a spreadsheet to keep track of the internal temperature and humidity of a construction project. I have all of my formulas working well except for my greatest humidity (K), my Max Temp (R), and Max Humidity (S) of tab 6th NW. I used the same formulas as I had on other tabs and cannot figure out why this tab is being difficult. Any help on this would be greatly appreciated. I have uploaded the file for your convenience.
You have a date in B130 that is text, not a real date
It says 18:00:00 PM, it should just say 6:00:00 PM
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
This may make it a bit neater for you...
=IF(ISNUMBER(MATCH(G3,INT($B$3:$B$11170),0)),MAX(IF(INT($B$3:$B$11170)=$G3,$D$3:$D$11170)),"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks