Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in worksheet-function

SumProduct over sets of cells (not contiguous)

excel worksheet-function

Count number of pieces data is split to by a certain delimiter

How to import data from one sheet to another

Excel Select Case?

How to set and use empty range in VBA?

Automatically increment sheet reference when dragging formula

String manipulation with Excel - how to remove part of a string if another part is there?

Excel charts - setting series end dynamically

Modify an Excel sheet from Matlab

Excel - How do I remove the items in column 1 from column 2 and put results in column 3?

excel worksheet-function

Sum cells in a column that have a specific value in a cell in their row

excel worksheet-function

Comparing two columns in Excel with exclusion

WorksheetFunction.CountA - not working post upgrade to Office 2010

Pretty Print Excel Formulas?

Fill non-contiguous blank cells with the value from the cell above the first blank

excel worksheet-function

Sorting Worksheet data by column values using Excel VBA

How to count up text of a different font colour in excel

Get parent folder path from file path using cell formula

excel worksheet-function

Using OR logic on an array as argument in Sumproduct

JXL solve #VALUE problem