Forum

Hi Martha, Welcome to our forum! How did you add the monthly data to the source data? How was the source data generated? If it is a query, then ...

Hi Vishal, Welcome to our forum! You could use Power Query to connect to the SQL database and get the data, but the Excel file must be open for ...

Hi PB, You can't remove the watermark but if you view the page in 'Normal' view you don't see them. I never use Page Layout view for working in the...

Hi Tracie, Welcome to our forum! If you choose a style from the Table Styles gallery it should stick. It certainly does when I use them. If you ...

Hi Chris, What happens if you use the function returned by split by non digit in your earlier version of Excel? e.g. in Query Table1 (2) add a cust...

Hi Chris, It's tricky as I also have 365 and can't test it, but can you use Splitter.SplitTextByEachDelimiter and set BLK as the delimiter? Then yo...

You can remove duplicates based on one or more columns. Simply choose the columns before clicking Remove Duplicates.

Hi Jacek, Can't you just append and then remove duplicates? Mynda

Hi Andrea, I wonder if custom data types could work for this task. Mynda

Hi Damian, Can you please supply an example file so we can see what you mean and try to reproduce the problem? Mynda

Hi Mark, Welcome to our forum! You can use this formula in a new column to extract the values from column 1: = try if [Col 1] = "c" then [Col...

Hi Tina, The file must be opened for the refresh to execute. You could possibly write some VBA in another workbook that you keep open on your PC th...

Hi Mahbub, Sorry, I was referring to your Power BI desktop file that didn't get uploaded to the forum in your first message. Firstly, creating a...

Hi Dave, What version of Excel do you have? If you have Microsoft 365 you could use the FILTER function to extract the values > and < specifi...

Hi Terry, Welcome to our forum! It sounds like something went wrong because none of my example files should return that error. Can you please sh...