hi,
i am not able to get count value at H16 cell for the selected range(H3:H15 having the range formula =IFERROR(INDEX($C$3:$C$19,MATCH(0,COUNTIF($H$2:H2,$C$3:$C$19)+($B$3:$B$19<>$G$3),0)),"")
please find the attached sheet, please help me...
regards,
giri.