will you provide sample workbook pls?
thanks
=MAX(IFERROR(LOOKUP(2,1/COUNTIF(AE6,"*" & {"Winds","Fog","Rain","Blowing","Snow","Freezing","Thunderstorm"} & "*"),{3,4,5,6,7,8,9}),1),IFERROR(LOOKUP(2,1/COUNTIF(AE39:AE41,"*" & {"Winds","Fog","Rain","Blowing","Snow","Freezing","Thunderstorm"} & "*"),{3,4,5,6,7,8,9}),1))
The above formula does not need to be array-entered.
Title | # Comments | Views | Activity |
---|---|---|---|
Sending a email via excel using vba | 6 | 55 | |
Pivot help | 3 | 21 | |
When a VBA code will not work in Excel 64bit? | 2 | 17 | |
onOpen. check dates in column, colour background | 6 | 18 |
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
13 Experts available now in Live!