Forum

Hi Sunil, You will have to clarify the request. For the moment, it's not clear what the code should search for, where it needs to display the resul...

Hi, You should use IFERROR. The way you use -IFERROR seems wrong, what's the logic behind this?

Hi Maria, The easiest way is to go to to Set the privacy level of the Data Source as None or Public, it will no longer display that error. Of co...

You can create a table with a single row that contains your folder path. In power query, add a new line using Advanced Editor with: FolderName =...

PQ does not extract any formatting from source files, unfortunately.

Hi Rahul, Try SQL Express 2008

Under message text editor, there is a button-Attachments. Browse for a file using Add Files button, then start Upload (the orange button next to Add F...

Hi Jason, You're saying that everything looks good, but it might not look that good for someone else. Without seeing a sample file with your query ...

Hi Renee, You should use a pivot table, it's much easier to view and filter data. I used power query to add year, quarter, month and week before ad...

Hi, C and D contains text, G has numbers. In text columns, if the number is at the end of the text, it will autofill the numbers when you drag down...

Hi Melanie, You have an error in a cell's formula, you have to fix that REF error in the source workbook. For the date/time error, you should be...

Hi Michelle, Can you upload a sample file to see how your data looks like and describe what details you want to see? If you prefer a generic rep...

Hi Doug, There is no easy answer with formulas, this usually happens when the data structure is not tabular. If the data is properly structured,...

Hi Aye, You should sort the EffDt column descending, then select first 4 columns and remove duplicates, this will remove the duplicates with older ...

It should be Msgbox, not Megbox: Megbox "You have entered worong info!", vbCritical