Forum

m Shi
@tlyqtyl
Eminent Member
Joined: Jan 5, 2021
Topics: 7 / Replies: 14
Reply
RE: How to Get Dynamic values for slicers

Hello Mynda, Thanks a lot. I tried to understand the method. There is small issue. I wish I can have 'Year' Slicer too so when I select 2, I can ha...

3 years ago
Forum
Topic
Forum
Replies: 3
Views: 205
Reply
RE: How to return a dynamic column array in numbers?

Thanks. So whatever will it apply for {1;2;...;n} or {1, 2, ...,n}, can use same methodology?

4 years ago
Reply
RE: How to return a dynamic column array in numbers?

Thanks a lot. I thought this way but just stuck by starting number with 0. By the way, If I want to use for {1, 2, 3, ...} for this, is this s...

4 years ago
Reply
RE: How to return a dynamic column array in numbers?

Ok, Thanks. Please see attached file. Please focus on the formula for Calendar of June. The array formula is using "StartDate+{0;1;..;7}*WeekDays" ...

4 years ago
Reply
RE: Keep data by Power Query while delete original file?

Thanks for your reply. Is there a way to meet this purpose? Since the original files will be for couple years, after I input into Excel, the purpos...

4 years ago
Forum
Topic
Page 1 / 2