I am looking for a funtion to find whether the values under the header text contains "variance" based on the values greater than or equal to 1. Formula should come in H Column
Please help
I am looking for a funtion to find whether the values under the header text contains "variance" based on the values greater than or equal to 1. Formula should come in H Column
Please help
Something like this...
=IF(SUMIF($B$1:$F$1,"*Variance*",$B2:$F2)>0,"Yes","No")
H2 copied down
HTH
Regards, Jeff
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks