Multiple condition lookup

=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

UNIQUE COUNT IN EXCEL

{=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

Column A range break to multiple ranges

Sub data_filter()
Dim k As Integer
For k = 2 To Sheet1.Range("A" & Rows.Count).End(xlUp).Row Step 40
Sheet1.Range(Sheet1.Cells(k, "A"), Sheet1.Cells(k + 39, "A")).Copy Sheet1.Range("XFD1").End(xlToLeft).Offset(0, 1)
Next
End Sub

Example :-

data	data	44,305	46,119	45,540
44,305		49,819	43,784	49,313
49,819		41,860	44,472	44,973
41,860
46,119
43,784
44,472
45,540
49,313
44,973