QUESTION : I have a spreadsheet with three columns, each column listing the folder names found on a server. Server1 […]
Tag: microsoft-excel-2007
Excel: Compute statistics (like an average) of all non-zero data
QUESTION : I have an array of data that contains some zeros at the end (though I’d like NOT to […]
How can I merge multiple workbooks into one?
QUESTION : Say I have a directory with the following files: Workbook1.xlsx (Contains Sheet1, Sheet2 and Sheet3) Workbook2.xlsx (Contains Sheet4 […]
Condition Formatting error
QUESTION : I am unable use condition formatting using the code below, I don’t know were I am going wrong […]
How can/does one dynamically adjust line width using Excel?
QUESTION : I have a series of figures that look like the “Basic Radial” SmartArt Graphic in Excel. My goal […]
Excel 2007 – cannot open the clipboard
QUESTION : Every now and then within Excel when I do Ctrl–x (cut) or Ctrl–c (copy) I get the pop-up […]
Adding line graphs adjacent to each other in Excel
QUESTION : I have a set of data that is grouped by both “Male and Female”, and also three different […]
Formatting a column based on another columns cell TEXT (not value) in Excel [duplicate]
QUESTION : This question already has an answer here: Closed 9 years ago. Possible Duplicate: Excel 2010 conditional formatting: selectively […]
Horizontal array constant definition issue
QUESTION : I can’t understand where I fail (except following MS-original help :-D) in attempt to enter horizontal array constant […]
Line Graph using Row summations
QUESTION : I’m having some trouble in Excel producing a line graph for the following data: +——+——–+———–+———–+ | Id | […]