microsoft-excel-2019 Archives

Excel Dynamic Arrays – creating multiple dynamic arrays based on another one

By JamesPosted on January 3, 2023

QUESTION : I’m trying out the new functionality of Office 365’s Insider versions of Microsoft Excel, dynamic arrays, and was […]

By JamesPosted on January 1, 2023

QUESTION : So I have a table and in one of the table columns I have the following =IF(ISNUMBER(SEARCH(“JugA”,[@[Original Wonderware […]

By JamesPosted on November 29, 2022

QUESTION : How can I draw the correlation for calculating Y and R squared as scatter graph in Excel 2019 […]

By JamesPosted on November 27, 2022

QUESTION : In Excel 365 (the full online version), I see there is such functionality: Now, I find articles implying […]

By JamesPosted on December 16, 2021

QUESTION : I have a problem with my Excel sheet. “Kolom4” has the product codes. Each code has two rows […]

By JamesPosted on October 29, 2021

QUESTION : I need a 2-axis Excel chart. Primary axis is US Deficit by year – this would be a […]

By JamesPosted on June 26, 2021

QUESTION : I have a problem with my Excel sheet. “Kolom4” has the product codes. Each code has two rows […]

By JamesPosted on June 16, 2021

QUESTION : I was wondering if there is a way to make a formula to automatically adjust so that the […]