Forum

Hi Meyanui, For this you must put your data in the correct tabular layout in a single sheet. You can use Power Query to consolidate the data into o...

Hi Rod, You don't need VBA to do this. You can use a dynamic named range. You can use INDEX and MATCH to find the last value in a column and define...

Hi Ridwan, The NETWORKDAYS.INTL function's first two arguments are the start date and end date. If you want a different range calculated, then chan...

Hi Matt, You should be able to use COUNTIF on column U to count the different license types? Or COUNTIFS for multiple criteria which would enable y...

Hi Ridwan, Welcome to our forum! You can use NETWORKDAYS.INTL for this, but you need to list your holiday dates. See file attached. Mynda

Hi Thomas, That depends what you want this chart title to say? e.g. Do you want it to say 'Employees in Office between Monday and Friday', or 'Empl...

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