Sales by month

[sunboy]

I'm kindly asking for a formula that can rearrange the sales data by month.

Please find the attached excel sample.


Regards,

Sunboy

[Bo_Ry]

Please try at A36

=INDEX(A$6:A$23,AGGREGATE(15,6,ROW(A$6:A$23)/($A$6:$A$23>=$B$33)/($A$6:$A$23<EDATE($B$33,1)),ROWS(A$36:A36))-ROW($A$5))

[alansidman]

Another option is to use Power Query. You can then filter on Column A

Excel 2016 (Windows) 32 bit

	A	B	C	D	E	F	G
1	Date	Name	Vat Number	Total Amount	Total VAT	Invoice.Invoice	Vat %
2	January	Clint	2006400	2300	345	1	0.15
3	January	Desire	2006401	2400	360	2	0.15
4	January	Omega	2006402	2500	375	3	0.15
5	January	Ethan	2006403	2600	390	4	0.15
6	January	Clint	2006404	2700	405	5	0.15
7	January	clint	2006405	2800	420	6	0.15
8	February	Desire	2006401	2900	435	7	0.15
9	February	Omega	2006402	3000	450	8	0.15
10	February	Ethan	2006403	3100	465	9	0.15
11	February	Desire	2006401	3200	480	10	0.15
12	February	Omega	2006402	3300	495	11	0.15
13	February	Ethan	2006403	3400	510	12	0.15
14	March	Gabriel	2006406	3500	525	13	0.15
15	March	Graig	2006407	3600	540	14	0.15
16	March	Clint	2006400	3700	555	15	0.15
17	March	Desire	2006401	3800	570	16	0.15
18	March	Ethan	2006403	3900	585	17	0.15
19	March	Nollen	2006408	4000	600	18	0.15

Sheet: Sheet2

Please Login or Register  to view this content.

[sunboy]

Hi Bo_Ry

Thanks for the formula it does what I want BUT when I'm using it my worksheet, excel is saying there is something wrong with formula. I have tried it several times without success. Please advice me what to do. Its a perfect match to what I want.

Regards,

Sunboy

[alansidman]

I have amended the file to include a parameter that you can then filter automatically the Query.

[sunboy]

Hi

Thank you all for helping me.

Regards,

Sunboy

[oeldere]

I see brackets in the file uploaded by Bo_Ry.

In that case you need to close the formula with

Ctrl+Shift+Enter instead of Enter

The brackets will appear automaticly.