Posts

Showing posts from October, 2012

Multiple condition lookup

=IFERROR(INDEX($C$2:$C$9,MATCH($E3&F$2,$B$2:$B$9&$A$2:$A$9,0)),"")

QUARYRESULTMonthNameProductivityNameJanFebMarJana180a150130Janb150b150Feba150c145Febc145d155Mard155e160Mare160Mara130


UNIQUE COUNT IN EXCEL

{=SUMPRODUCT(1/COUNTIF(A8:A18,A8:A18))}


A              


NameAmounta £    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