Forum

Hi Adam, Glad you've found our site helpful! Unfortunately, you can't add conditional formatting arrows to a Pivot Chart. Here's an example of a...

Hi Bouskila, Please provide a sample Excel file of your data and desired result so I can understand what you're working with. Mynda

Hi Max, It sounds like you're not using a tabular layout for your source data. If you were, then you could create a PivotTable report from the data...

Hi Laura, I can't see the very bottom of your screen. There should be an arrow there which is 'get data'. Mynda

Hi Ayal, To find the address of a cell, you can use the CELL function like so: =CELL("address",B2) Alternatively, the current cell address is...

Hi Chris, I think what Velouria is alluding to is to clear all filters, then set the formatting, then reapply the filters as required. This will ap...

Hi Sarfraz, Follow the link for the tutorial on Text.Select. Then see tutorial 3.05 on merging queries. Mynda

Hi Sarfraz, That formula is woefully inefficient. You can use this simpler formula nowadays: =TEXTJOIN("",TRUE,IFERROR((MID(D2,ROW(INDIRECT("1:"...

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