Search code examples
How to read characters from the right until a slash is reached...


stringexcelsearchexcel-formulaworksheet-function

Read More
Using INDIRECT and IF functions together with dynamic range...


excelif-statementexcel-formulaworksheet-functionexcel-indirect

Read More
How to replace regular text in Excel into HTML unordered list (for export to CSV)?...


excelexcel-formulaconcatenationexport-to-csvworksheet-function

Read More
How to delay a formula to be shown for a certain number of hours?...


excelexcel-formulaworksheet-functionexcel-2013

Read More
Using INDEX partially to populate a matrix from a list...


excelindexingexcel-2010worksheet-functioncountif

Read More
Maximum values per day from data with different dates...


excelexcel-formulamaxpivot-tableworksheet-function

Read More
Locating a string and copy adjoining cell to new column...


excelsearchif-statementexcel-formulaworksheet-function

Read More
Round to two decimal places...


excelexcel-formulaexcel-2010roundingworksheet-function

Read More
Move rows based on criteria within string...


vbaexcelexcel-formulaworksheet-function

Read More
IF statement containing four conditions but single answer (or blank)...


excelif-statementnestedexcel-formulaworksheet-function

Read More
Compare 2 set of cells and count...


excel-formulaworksheet-function

Read More
Combine multiple VLOOKUPs...


excelif-statementexcel-formulavlookupworksheet-function

Read More
Separate some values by brackets and decrease a number from a column to another column...


excelexcel-formulaworksheet-functionsubstitutionvba

Read More
Combined COUNTIF for several columns...


excelexcel-formulaworksheet-functioncountif

Read More
Replace "Lunch Out, Lunch In" with duration in formula to give Time Out/In difference excl...


excelexcel-formularoundingworksheet-functiontime-format

Read More
Calculate the conditional median value?...


excelexcel-formulaworksheet-functionmedianarray-formulas

Read More
Concatenate by group excluding group member from same row...


excelexcel-formulaconcatenationworksheet-functionsubstitution

Read More
Using Wildcards to Extract Text from Cell String Containing a Specific Value/Character...


stringexcelextractwildcardworksheet-function

Read More
If the row contains specific text highlight row by row where two columns are the same...


excelexcel-formulaworksheet-functionconditional-formattingcountif

Read More
Return highest number value in column cell plus a related row cell data...


excelexcel-formulamaxconcatenationworksheet-function

Read More
Count how often a value in a cell in one specific column is not the same as the value in the same ro...


excelsumexcel-formulaworksheet-functioncountif

Read More
Change a full column of such as F01U123456 to F.01U.123.456...


stringexcelexcel-formulaworksheet-functionvba

Read More
Detecting what value was in a cell prior to a change...


excelworksheet-functionvba

Read More
INDEX/MATCH, or another function?...


excelexcel-formulamatchvlookupworksheet-function

Read More
Count all rows in column A containing "(CLOSED)" or "(DO NOT USE)"...


exceltextexcel-formulaworksheet-functioncountif

Read More
Copy paste to new Worksheet in Excel...


excelcopy-pasteworksheet-functionvba

Read More
Copying specific data from one sheet to another...


excelpivot-tableworksheet-functionarray-formulasvba

Read More
Combine a constant column with a variable row...


excelfunctionvariablesworksheet-functionexcel-indirect

Read More
Conditionally assign unique values...


excelif-statementexcel-formulamaxworksheet-function

Read More
Formula to increment by volume and issue number, each in sets of three...


excelintegerexcel-formulaworksheet-functionmodulus

Read More
BackNext