Search code examples
Nested IF Formula...


excelif-statementexcel-formulaexcel-2007worksheet-function

Read More
Relational coding...


excelexcel-formulavlookupworksheet-function

Read More
Merging values into an aggregate column...


excelif-statementexcel-formulaworksheet-functioncountif

Read More
Find rows repeated in no particular order and show result sorted by number of repetitions...


excelexcel-formulavlookupworksheet-functionvba

Read More
Value between a range of values...


excelexcel-formulavlookupexcel-2013worksheet-function

Read More
Sorting/cleaning where data in columns is jumbled...


excelvbaexcel-formulavlookupworksheet-function

Read More
Finding the sum of values in cells that also contain other text...


excelexcel-formulasumworksheet-functionvba

Read More
Force '2.1' to be different from '2.10' (for SUMIF purposes)...


excelexcel-formulaworksheet-function

Read More
Count of unique values in multiple columns...


excelexcel-formulaworksheet-functioncountif

Read More
List row number of each first value of a repeated series...


excelif-statementexcel-formulaworksheet-function

Read More
Concatenating Text in a Chart Series Name Box...


excelchartsexcel-formulaworksheet-function

Read More
IF function to identify first character of cell...


stringexcelif-statementexcel-formulaworksheet-function

Read More
Matching data based on IDs...


excelexcel-formulavlookupworksheet-functionexcel-2011

Read More
Need to create a flag based off of a date column and today's date...


exceldatetimeexcel-formulaexcel-2010worksheet-function

Read More
Formula to reference data from a PivotTable...


excelexcel-formulaexcel-2010pivot-tableworksheet-function

Read More
How to rename duplicate rows...


excelexcel-formulaexcel-2010excel-2007worksheet-function

Read More
Alternatives to multiple IF functions...


excelif-statementexcel-formulavlookupworksheet-function

Read More
Referencing formula dates in a COUNTIFS statement...


exceldateexcel-formulaworksheet-functioncountif

Read More
COUNTIF formula based on today's date...


excelexcel-formulaworksheet-functioncountif

Read More
Merge two sheets and keep the redundant data...


excelexcel-formulavlookupworksheet-function

Read More
How to export data from a PivotTable to .csv in a specific format?...


excelexcel-formulapivot-tableexport-to-csvworksheet-function

Read More
Insert characters into string in different locations...


stringexceltextworksheet-functionvba

Read More
`10/2` evaluates to `42279.00`?...


stringexcelformattingexcel-formulaworksheet-function

Read More
Worksheet.Change Event in Excel in real time...


exceleventsworksheet-functionvba

Read More
Separating data and placing in individual worksheets Excel VBA...


excelworksheet-functionvba

Read More
Vlookup macro doesn't return all values needed but the values are input to pull from...


excelvbavlookupworksheet-function

Read More
Grouping a Table based on Text...


excelif-statementexcel-formulagroupingworksheet-function

Read More
Counting between 2 words...


excelworksheet-function

Read More
Excel INDEX MATCH repeats only first value...


excelworksheet-function

Read More
Excel COUNTIF dates...


excelworksheet-functioncountif

Read More
BackNext