Forum

Hi Stacey, Welcome to our forum! In the query editor Home tab go to Data Source Settings and 'change source' to point to the folder containing J...

Hi Jacqlyn, Will this value be used in anther query? I ask because usually Power Query cleans the data and then you summarise it (count etc.) in a ...

Hi Jessica, Not like you not to know the answer 😉 Printer settings like that are managed by the printer software, not Excel. I'd try a differe...

Hi Matt, You can use a nested IF with OR e.g. =IF(OR(U2="MD",AD2=123),1,0) If that's not what you're after, then please upload a sample file ...

Ah, I can see why if you're needing to print to PDF.

Hi Andrew, The file didn't get attached. You need to click 'start upload' after selecting your file, then wait for the grey check mark beside the f...

Hi Barry, You'd have to write some VBA code to update the charts automatically, as there's no built in way to accomplish this. However, I wonder...

Hi Valerie, Please try uploading the sample file again. After selecting the file, click the Upload button and wait for the grey check mark beside t...

Hi Russ, Welcome to our forum! Evaluation for volatile functions is triggered more frequently than non-volatile functions. As a result, your wor...

Hi Edward, There's no built in way to do this. You'd have to reconstruct the formula in a text string e.g. =B20&"/"&D5 Which would re...

Hi Matt, It depends on your file structure. Please upload a sample file that illustrates the issue and your desired result. Mynda

Hi Chuck, Welcome to our forum! Try this formula: =AND($AA2<>"",$AA2<TODAY()-14) Mynda

Hi Ivon, Welcome to our forum. If you bring the vertical axis back you'll see that it has a minimum of 133629.8333333333 and maximum of 133629.8...

Hi Mark, Power Automate would be the solution. There is a free Power Automate Desktop tool you can use, but the PC would need to be running for it ...

Hi Mark, Neither of these screenshots have any data because you don't have any fields in your values area. It may appear that you have data in the ...