'Find numbers in sum' category
How to do tiered calculations in one formula
The image above demonstrates a formula that calculates tiered values based on a tier table and returns a total. This […]
The image above demonstrates a formula that calculates tiered values based on a tier table and returns a total. This […]
Find numbers closest to sum
Excelxor is such a great website for inspiration, I am really impressed by this post Which numbers add up to […]
Excelxor is such a great website for inspiration, I am really impressed by this post Which numbers add up to […]
Find positive and negative amounts that net to zero [UDF]
Question:I would like to reduce the number of open items by identifying positive and negative amounts that net to zero […]
Question:I would like to reduce the number of open items by identifying positive and negative amounts that net to zero […]
Find numbers in sum [UDF]
This article describes how to find a sum from a range of numbers using a user defined function. Let´s see […]
This article describes how to find a sum from a range of numbers using a user defined function. Let´s see […]
Identify numbers in sum using Excel solver
Here is a useful feature I recently found googling for Excel solver examples. I have summed some random values from […]
Here is a useful feature I recently found googling for Excel solver examples. I have summed some random values from […]
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