'Solver' category

How to solve simultaneous linear equations in Excel
This article demonstrates how to solve simultaneous linear equations using formulas and Solver. The variables have the same value in […]
How to use the COMBIN function
The COMBIN function returns the number of combinations for a specific number of elements out of a larger number of […]
Excel solver examples
This article demonstrates ways to use solver in Excel. Table of Contents Using Excel Solver to schedule employees Cash drawer […]
Identify numbers in sum using Excel solver
  Table of Contents Identify numbers in sum using Excel solver Find numbers in sum - UDF Find positive and […]

Excel formula categories

AverageChooseCombine MergeCompareConcatenateConditional FormattingCountCount valuesDatesDuplicatesExtractFilterFilter recordsFiltered valuesFilterxmlHyperlinkIf cellIndex MatchLogicLookupsMatchMaxMinNumbers in sumOR logicOverlappingPartial matchRecordsSequenceSmallSort bySort valuesSumSumifsSumproductString manipulationTimeUnique distinct recordsUnique distinct valuesUnique recordsUnique valuesVlookupVlookup return values

Excel categories