Call built-in IRR function in macro...
Read MoreHow to find partial matching elements in spreadsheet?...
Read MoreRemove rows where value is *not* in column on other sheet...
Read MoreObtain row and column index from cell name in LibreOffice Calc...
Read MoreConditionally show a value from a row that has a cell in it with a matching value...
Read MoreDefine matrix inline: LibreOffice Calc vs OpenOffice Calc...
Read MoreSort text column alphanumerically (letters before numbers)...
Read MoreDisplay the cells involved in the calculation of the current cell...
Read MoreSelect single column from array returned by GetQuote extension...
Read More'Sampling' equivalent function in Calc...
Read MoreHow to restrict character in a particular cell...
Read MoreAutofill based on list and value of a cell...
Read MoreHow can I count how many *pairs of cells* have each element meet a condition?...
Read MoreHow can I remove manually added page breaks?...
Read MoreHow to reference a cell or range in an external spreadsheet?...
Read MoreIs it possible to remove characters before a certain point?...
Read MoreAssign integral value to list of relative values...
Read MoreHow can I autocomplete formula that can change column name when dragged down?...
Read MoreHow to scroll all sheets together (or other ~3D-like ideas)...
Read MoreMerge two spreadsheets by matching one column...
Read MoreIn DGET function, how to use multiple cell ranges as search criteria?...
Read More