Sort week nr's with formula

[Ramballah]

Hi Everyone,

I have 2 pivot tables that I want to merge into one chart (both on different sheets)
I need to do this for multiple pivot tables so I want to get this done with a formula.
In tab 3 I make a new chart where I use vlookups on the week numbers.
See my result:

So what I have are 2 pivot tables, and then in tab 3 (3rd picture) I want to only show me the weeks that I have in the pivot tables. I have no use for week 1-3 etc (weeks that I'm not using)
Is this possible as a formula?

Thanks in advance,
Ram

Workbook: https://easyupload.io/cy8urp

 

[Peter_SSs]

See if something like this would work for you.

Schemas Saldilijsten.xlsx
	A	B	C
1	week	debiteur	crediteur
2	4	€ -	€ -1,702.40
3	8	€ 3,554.98	€ -
4	15	€ 6,493.00	€ -
5	16	€ 13,945.25	€ -
6	17	€ -	€ 170,987.90
7	18	€ -	€ 57,237.10
8	19	€ 467.10	€ -51,622.24
9	25	€ 88,487.78	€ -
10	26	€ 23,050.50	€ 27.64
11	27	€ 2,379.16	€ 445.89
12	28	€ 1,182.50	€ 655.78
13	29	€ 5,043.89	€ 16.95
14	30	€ -	€ 8.65
15	31	€ 575,911.07	€ -
16	32	€ 768.35	€ 10.15
17	33	€ 6,922.71	€ 666.75
18	34	€ 2,428.03	€ 6.00
19	35	€ 17,152.08	€ -121.00
20	36	€ 14,296.15	€ 254.10
21	37	€ 13,136.75	€ 11,540.64
22	38	€ 96,881.53	€ 5,592.51
23	39	€ 264,778.04	€ 203,766.85
24	40	€ 94,740.08	€ 217,201.30
25	41	€ 176,952.39	€ 107,932.66
26	42	€ 340,502.57	€ 51,095.32
27	43	€ 319,410.30	€ 73,084.13
28	44	€ 68,610.00	€ 34,513.35
29	45	€ 6,125.18	€ 85,129.05
30	46	€ 87,552.43	€ 16,134.50
31	47	€ 18,486.23	€ -
32	49	€ 458.59	€ -
33	50	€ 867.03	€ -
34	51	€ 2,338.93	€ -
35
36
37
Totaal

Cell Formulas
Range	Formula
A2:A37	A2	=IF(OR(A1="",A1=MAX(MAX(Debiteuren!A$3:A$50),MAX(Crediteuren!A$3:A$50))),"",MIN(IFERROR(AGGREGATE(15,6,Debiteuren!A$3:A$50/(Debiteuren!A$3:A$50>N(A1)),1),99),IFERROR(AGGREGATE(15,6,Crediteuren!A$3:A$50/(Crediteuren!A$3:A$50>N(A1)),1),99)))
B2:B37	B2	=IF(A2="","",IFERROR(VLOOKUP(A2,Debiteuren!A:B,2,FALSE),0))
C2:C37	C2	=IF(A2="","",IFERROR(VLOOKUP(A2,Crediteuren!A:B,2,FALSE),0))

 

[Ramballah]

See if something like this would work for you.

Thanks this seems to work like a charm, I'll update you if it wont work in the future! thanks a lot !

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.