Forum

Frans Visser
@fravis
Reputable Member
Joined: Apr 21, 2015
Topics: 25 / Replies: 312
Reply
RE: Need help with combination of more modern functions Filter, Choose and others to solve this problem

Thanks very much Charles and Riny for your contributions! (I see one extra from Charles is awaiting moderation, but these two are also very nice). ...

5 months ago
Reply
RE: Using Table name for data validation list

Two more things: 1) The issue is also adressed by Mynda in her blog (and that's from 2013!) and still not really solved I see 2) Hans asked my v...

9 months ago
Reply
RE: Using Table name for data validation list

Thanks Anders and Hans (also in the Netherlands I see :-)) The information Anders gave with this link helps a lot. It gives also the explanation wh...

9 months ago
Reply
Reply
RE: Working with the new Array functions how to combine them?

No, no, no! The LET function is not available for me at this moment. I read in one of your posts that it is in the Beta version available. We don't...

5 years ago
Reply
RE: Working with the new Array functions how to combine them?

Wow! I transposed your first solution to the original table and that's working very good. But this one is the one I was hoping for. I'll use that a...

5 years ago
Reply
RE: Working with the new Array functions how to combine them?

Thanks very much Mynda! We're on the right track. The sort option is indeed what I wanted: from largest to smallest. You gave one formula for th...

5 years ago
Reply
RE: What does a new 365 function look like when file opened in old Excel version?

Thanks Velouria. Maybe this will do for this purpose (with some explanation to the users if this happens). Frans

5 years ago
Reply
RE: Can we do some Excel layout magic for displaying some pivot tables?

Wow, what a code. Not my cup of coffee, but I hope Scotty can work with that! Good work Velouria, thanks. Frans

5 years ago
Reply
RE: Can we do some Excel layout magic for displaying some pivot tables?

As I understand it, that's exactly what Scotty wants Velouria, but (I think) not 'by hand' but by 'some Excel magic'. I think about a button under ...

5 years ago
Reply
RE: How to solve little issue with slicer?

Dear Anders, Philip and Sunny: Thanks very much. I love you guys! Fast answers and to the point. Thanks Anders for the link, because that also gave...

5 years ago
Page 1 / 23