Forum

Hi Sarfraz, Happy new year to you too! I'm not sure what you're asking for as the file you attached already has the formula working in Excel. ...

You must have pasted the data from a range that had the darker blue as its fill colour. Select the entire table and set the background to "No fill". T...

It's difficult to say much about it without seeing your PDF and resulting Excel file. Are you able to share them? If it's confidential, you can email ...

Hi Sarfraz, You can use Text.Select to extract the number IDs from the two statements, as explained here: Extract Letters, Numbers, Symbols from St...

Hi James, It's probably a regional issue. My File Origin is detected as 1200: Unicode at the file import step. You can try using Change Type >...

Hi Eileen, The best solution I could come up with is to use TEXTJOIN in column C to concatenate the Account No. and Value together with a space: ...

Thanks for sharing your file. The issue is that your data is not in a suitable layout to lookup the results you want. Firstly, you have the years in m...

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...