Excel And VBA Tips

=IFERROR(INDEX($C$2:$C$9,MATCH($E3&F$2,$B$2:$B$9&$A$2:$A$9,0)),"") QUARY RESULT Month Name Productivity   Name Jan Feb Mar Jan a 180   a   150 130 Jan b 150   b 150     Feb a 150   c   145   Feb c 145   d     155 Mar d 155   e     160 Mar e 160           Mar a 130          

{=SUMPRODUCT(1/COUNTIF( A8:A18,A8:A18 ))} A               Name Amount a  £    80.00 b  £    33.00 c  £    56.00 d  £    88.00 a  £    80.00 f  £    60.00 g  £    55.00 a  £    80.00 i  £    90.00 j  £    96.00 a  £    80.00