I need to run a min formula where if a value is "Date", then the min function is applied to only those cells where said "Date" is true. So: if the date is 7/22/2010 within column B, then I need the minimum temperature from those days that are values in column D. So, in this case = 54.777. Please, and thank you.
A B C D E F G A088 7/22/2010 AM 70.372 61.848 69.6 62.533 A088 7/22/2010 PM 73.731 62.319 73.342 63.09 A088 7/22/2010 PM 77.247 63.048 80.449 63.99 A088 7/22/2010 PM 75.724 63.862 75.637 66.515 A088 7/22/2010 PM 76.768 65.316 76.375 68.484 A088 7/22/2010 PM 69.6 66.6 69.685 69.814 A088 7/22/2010 PM 74.899 66.686 74.163 69.557 A088 7/22/2010 PM 67.543 66.558 67.114 69.256 A088 7/22/2010 PM 63.99 66.258 63.99 68.614 A088 7/22/2010 PM 61.29 65.745 61.248 67.798 A088 7/22/2010 PM 55.647 65.145 56.079 66.943 A088 7/22/2010 PM 55.776 64.503 56.122 66.043 A088 7/22/2010 PM 54.777 63.862 55.081 65.188 A088 7/23/2010 AM 53.951 63.304 54.212 64.459 A088 7/23/2010 AM 53.472 62.748 53.865 63.819 A088 7/23/2010 AM 52.772 62.233 53.078 63.176 A088 7/23/2010 AM 51.721 61.72 51.984 62.577 A088 7/23/2010 AM 50.621 61.205 50.886 61.977 A088 7/23/2010 AM 49.737 60.647 50.047 61.29 A088 7/23/2010 AM 50.841 60.132 50.974 60.69 A088 7/23/2010 AM 52.817 59.659 52.992 60.132 A088 7/23/2010 AM 55.949 59.401 55.776 59.873 A088 7/23/2010 AM 59.142 59.315 59.229 59.83 A088 7/23/2010 AM 70.115 59.445 67.885 59.959 A088 7/23/2010 AM 71.49 59.83 68.657 60.647 A088 7/23/2010 PM 69.343 60.604 69.814 61.59 A088 7/23/2010 PM 71.103 61.333 71.49 62.962 A088 7/23/2010 PM 65.444 61.977 66.173 64.503 A088 7/23/2010 PM 59.529 62.276 58.798 64.76 A088 7/23/2010 PM 58.971 62.233 59.358 64.418 A088 7/23/2010 PM 56.944 62.105 56.901 64.117 A088 7/23/2010 PM 56.208 61.891 56.426 63.732 A088 7/23/2010 PM 55.992 61.633 56.208 63.262 A088 7/23/2010 PM 55.429 61.376 55.602 62.875 A088 7/23/2010 PM 54.865 61.075 55.038 62.447 A088 7/23/2010 PM 54.865 60.775 55.038 61.977 A088 7/23/2010 PM 54.212 60.433 54.3 61.547 A088 7/24/2010 AM 53.733 60.132 53.82 61.162 A088 7/24/2010 AM 53.951 59.83 53.951 60.775 A088 7/24/2010 AM 54.3 59.616 53.994 60.433 A088 7/24/2010 AM 54.169 59.358 53.82 60.132 A088 7/24/2010 AM 53.384 59.185 53.121 59.873 A088 7/24/2010 AM 52.729 58.928 52.335 59.572 A088 7/24/2010 AM 52.86 58.669 52.729 59.229 A088 7/24/2010 AM 54.909 58.411 54.343 58.928 A088 7/24/2010 AM 58.626 58.282 57.42 58.798 A088 7/24/2010 AM 63.561 58.411 63.09 59.014 A088 7/24/2010 AM 66.043 58.928 66.814 59.788 A088 7/24/2010 AM 66.729 59.702 67.372 60.861 A088 7/24/2010 PM 64.931 60.474 65.615 61.848 A088 7/24/2010 PM 65.53 61.205 65.829 62.704 A088 7/24/2010 PM 75.767 61.547 76.768 63.347 A088 7/24/2010 PM 72.523 62.962 73.558 65.316 A088 7/24/2010 PM 66.729 64.288 66.515 66.857 A088 7/24/2010 PM 59.702 64.845 59.572 67.028 A088 7/24/2010 PM 60.517 64.589 59.185 66.472 A088 7/24/2010 PM 59.83 64.117 59.445 65.788 A088 7/24/2010 PM 57.807 63.561 57.979 65.145 A088 7/24/2010 PM 58.712 62.962 58.798 64.418 A088 7/24/2010 PM 58.195 62.49 58.195 63.775 A088 7/24/2010 PM 57.679 62.062 57.506 63.262
Aucun commentaire:
Enregistrer un commentaire