View Single Post
  #3   Report Post  
Max
 
Posts: n/a
Default

Oops, correction to formula in line:
Put in AA1: =COUNTIF($S$3:$X$6,Z1)


Put in AA1: =COUNTIF(S:X,Z1)
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--