Forum

Frans Visser
@fravis
Reputable Member
Joined: Apr 21, 2015
Topics: 25 / Replies: 312
Reply
RE: Colour rows based on a cells value

I first put in some numbers in column A and after each number there came various colored lines on the row I was working on. So that's good. When I ...

8 years ago
Reply
RE: Employee statistic

I think the question is: What is Seniority? We don't know what you mean by that so we can't give any formula or whatsoever. Maybe it's something...

8 years ago
Reply
RE: Date selector for different Dates

OK, this might not be the most elegant way, but maybe you can work it further to your convenience. I always have some difficulties with date and ti...

8 years ago
Reply
RE: Date selector for different Dates

OK that helps. I'll give it a try.

8 years ago
Reply
RE: Data Validation

I think you need to set your cel format correct to your wishes. Just recently here on the MOTH website Mynda published a ton of information just fo...

9 years ago
Reply
RE: Time conditional formatting

Nice question! Working with time brings always an extra thing with it, doesn't it? Thought I figured it out, but something went wrong (something wi...

9 years ago
Reply
RE: Date selector for different Dates

You first have to bring your data one way or another to one table I think. Then create a PivotTable from that table and use the slicer on the Date ...

9 years ago
Reply
RE: Excel locking up

From my own experience: it should work nice and fine but it doesn't always. I think and hope that lot's of people who use Cloud services work perfect ...

9 years ago
Reply
RE: Return value that need to satisfy condition.

Yeah I saw that one too! But if our man has seen it and used it? We maybe never know......

9 years ago
Reply
RE: Best way to automate update PivotTable?

Thanks Mynda and Sunny for your replies. Both confirm my opinion/knowledge about this. That's sometimes also good to see! I think you're right Sunn...

9 years ago
Reply
RE: Return value that need to satisfy condition.

Hi Ahmad Khalil Che Ab Aziz, I'm always interested if the suggestion helped you or if you need further assistance? Would be kind hearing from you!

9 years ago
Reply
RE: Sorting by Financial Year

I had to search, but here's a blogpost from our Mynda that I think exactly explains how to deal with your problems: Good luck!

9 years ago
Reply
RE: Slicer text custom sort

You can also begin the text 'Pre 1937' with a space. The space is sorted before the numbers so that'll do the same.

9 years ago
Reply
RE: Sorting by Financial Year

Other way is I think shown in the Dashboard course here by Mynda: make a helper column where you 'translate' the month to the period in the financial ...

9 years ago
Page 16 / 23