How to make automatic unique ranking table if changing only week number?

[Sochen]

Hi All,

I have the excel below which I want to make a dynamic table.
1. The data in the table automatically change if change the week number
2. Only top 5 categories (unique) will be appear in the table base on the sales performance

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1
2							Change the week number from Week 2 to Week 3 as the result will automatically change in the table below
3
4
5	Week No.	Date	Categories	Sales			Week No.	2			Week No.	3
6	2	11-Jan-23	Apple	$ 50.00			Rank.	Categories	Total Sales		Rank.	Categories	Total Sales
7	2	11-Jan-23	Mango	$ 25.00			1	Apple	$ 90.00		1	Banana	$ 80.00
8	2	11-Jan-23	Banana	$ 15.00			2	Dragon fruits	$ 55.00		2	Apple	$ 75.00
9	2	11-Jan-23	Orange	$ 10.00			3	Watermelon	$ 45.00		3	Strawberry	$ 70.00
10	2	14-Jan-23	Apple	$ 40.00			4	Banana	$ 40.00		4	Orange	$ 65.00
11	2	14-Jan-23	Mango	$ 30.00			5	Mango	$ 35.00		5	Cherry	$ 60.00
12	2	14-Jan-23	Watermelon	$ 20.00
13	2	14-Jan-23	Papaya	$ 75.00			Note:	Update the Week No. to see the sale performance of any week.
14	2	15-Jan-23	Dragon fruits	$ 15.00				Once changing the week number, then the categories and total sales will automaticallt change. And only the top 5 categories will appear on the table.
15	3	18-Jan-23	Cherry	$ 60.00
16	3	18-Jan-23	Apple	$ 75.00
17	3	18-Jan-23	Strawberry	$ 70.00
18	3	18-Jan-23	Grapes	$ 30.00
19	3	18-Jan-23	Durian	$ 20.00
20	3	18-Jan-23	Orange	$ 55.00
21	3	18-Jan-23	Banana	$ 35.00
22	3	18-Jan-23	Pineaple	$ 55.00
23	3	19-Jan-23	Orange	$ 10.00
24	3	19-Jan-23	Banana	$ 45.00
25
Sheet1

Cell Formulas
Range	Formula
A6:A24	A6	=ISOWEEKNUM(B6)

 

[Fluff]

You're welcome & thanks for the feedback.