Forum

Hi Mattias, I downloaded the Excel file from the source you referenced, and I can't see how you'd use that in Excel to lookup latitude and longitud...

Hi Eileen, I'm having trouble visualising the before and after view of your data that you want. Can you please upload a sample Excel file that show...

Hi and welcome to our forum! Can you please upload your file or an example file so we can see what you're trying to do in the context of the worksh...

Hi Lea, If you look at the underlying numbers in the Data table, you'll see they're already rounded to thousands, so what you're seeing in the char...

Hi Lea, You can use custom number formats. Please see this tutorial on scaling numbers with custom number formats in Excel. Let me know if you g...

Hi Tim, Welcome to our forum! I wish I could help you, but I'm not a Power Automate expert and I wouldn't know where to start, sorry. I recommend y...

Hi Julian, When you first make the post, in our forum or any other forum, when you've also posted the same question elsewhere, you must state that ...

Hi Dejan, Please see this post on identifying overlapping dates and times in Excel. If you're still stuck, come back and share your file so we c...

Glad you liked it, Julian and thanks for sharing my solution in the other forum. For future reference, please note that you must always make it cle...

Hi Julian, If you have Microsoft 365 you can use the new dynamic array formulas. e.g. where your sum is in cell A2 you can use this formula: =-S...

Hi Fahruk, Welcome to our forum! Thanks for sharing your file and example of the problem. Unfortunately, Excel wasn't designed to work with multipl...

So pleased it was helpful, Ricardo!

Hi Julien, As mentioned in my email reply to you, please upload a sample Excel file containing your data so we don't have to do the work for you. I...

Hi Floyd, Welcome to our forum! Can you please upload a sample Excel file that shows the desired result for the examples above. I'm not sure I shou...

Hi Ronald, Glad it's working now. When you change a date using Locale you don't need to change it a second time. It should already be in your lo...