Forum

Hi Elaine, Welcome to our forum! You can track changes with Excel Online as shown here. i.e. open the file created in Excel on your desktop and ...

Hi Zita, It doesn't look like the file author (which is what I presume you mean by 'file owner') data is available in the meta data brought in by P...

Hi Cedric, Welcome to our forum! Have you tried getting this file with Power Query? If so, what was the outcome? Have you tried using the Power ...

Hi Johan, If you don't want the 4 Cylinder End then I'd create another column that concatenates the Explosion Level and Component columns together,...

Hi Bax, Yes, you can edit the queries. Just update all instances of the file and table names you want to replace in the advanced editor for each he...

Hi Alexander, I guess, at a minimum, you'll have an Orders table and a Stock table. The Orders table will have the project details, but the Stock t...

You're welcome, Clay. Hopefully you can follow the steps in the file I shared. I'm sure you'd learn a lot from my course, and it will help fit the pie...

Hi Clay, Welcome to our forum! I think you're on the right track in trying to import this data in two queries, one for the header information an...

Using a technique like this highlight min and max values in a chart. It obviously highlights the min and max, but you can change the formula to includ...

Please provide a sample file that illustrates how your data is structured and what you mean by 'the selection of any two dates'.

Hi Shashank, Chart's cannot display conditional formatting or detect conditional formats in cells in order to display them. You would have to use a...

Hi Frederic, Welcome to our forum! You can use LASTNONBLANK for this, as explained here. See file attached. Mynda

Hi Keith, Only if you import that data into Power Query as a separate query. Mynda

Hi Priyanka, In Cell D2 of the Emp Individual Schedule sheet enter this formula: =INDEX(Code, MATCH(INDEX('Emp Information '!I$2:I$30, MATCH('Em...

Hi Lea, If you mean that you want to remove the asterisks, then you can use Find & Replace on the column and replace them with nothing. Be sure...