Aggregate Function Not Workinbg with Multi Counties

[boynejs]

I am working on a large tornado database. Everythig works well with the following equation

=IFERROR(AGGREGATE(14,6,$B$2:$B$19/($E15=$A$2:$A$19)/ISNUMBER(FIND(LEFT(F$14,2),$C$2:$C$19)),1),"")

However, when I can multicounties affected, the equation fails. I tried replacing $E15 with "*Dodge*" and "Dodge (MN)". The equation fails and it provides me with the earlier date or blank.

Any help would be greatly appreciated.

Jeff B

[Fluff13]

How about
=IFERROR(AGGREGATE(14,6,$B$2:$B$19/(ISNUMBER(SEARCH($E15,$A$2:$A$19)))/ISNUMBER(FIND(LEFT(F$14,2),$C$2:$C$19)),1),"")

[samba_ravi]

F15=IFERROR(AGGREGATE(14,6,$B$2:$B$19/ISNUMBER(SEARCH(TRIM($E15),$A$2:$A$19)*SEARCH(TRIM($C$2:$C$19),F$14)),1),"")
Try this, Copy and paste across

[Phuocam]

Or try:

=IFERROR(AGGREGATE(14,6,$B$2:$B$19/ISNUMBER(SEARCH($E16,$A$2:$A$19))/(RIGHT(F$14,2)=RIGHT($C$2:$C$19,2)),1),"")

[samba_ravi]

or can try
f15=IFERROR(AGGREGATE(14,6,$B$2:$B$19/ISNUMBER(SEARCH(TRIM($E15),$A$2:$A$19)*SEARCH(" "&TRIM($C$2:$C$19)&" "," "&F$14&" ")),1),"")

[boynejs]

Thanks everyone for the help!

[Fluff13]

You're welcome & thanks for the feedback.