'INT function' category
How to use the INT function
The INT function removes the decimal part from positive numbers and returns the whole number (integer) except negative values are […]
The INT function removes the decimal part from positive numbers and returns the whole number (integer) except negative values are […]
How to use Excel Tables
An Excel table allows you to easily sort, filter and sum values in a data set where values are related.
An Excel table allows you to easily sort, filter and sum values in a data set where values are related.
How to generate a round-robin tournament
This article demonstrates macros that create different types of round-robin tournaments. Table of contents Basic schedule - each team plays […]
This article demonstrates macros that create different types of round-robin tournaments. Table of contents Basic schedule - each team plays […]
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 […]
Excel calendar
Table of Contents Excel monthly calendar - VBA Calendar Drop down lists Headers Calculating dates (formula) Conditional formatting Today Dates […]
Table of Contents Excel monthly calendar - VBA Calendar Drop down lists Headers Calculating dates (formula) Conditional formatting Today Dates […]
How to create permutations
I discussed the difference between permutations and combinations in my last post, today I want to talk about two kinds […]
I discussed the difference between permutations and combinations in my last post, today I want to talk about two kinds […]
Monthly calendar template
Table of Contents Monthly calendar template Monthly calendar template 2 Calendar - monthly view - Excel 365 Calendar - monthly […]
Table of Contents Monthly calendar template Monthly calendar template 2 Calendar - monthly view - Excel 365 Calendar - monthly […]
Calculate machine utilization
Question: I need to calculate how many hours a machine is utilized in a company with a night and day […]
Question: I need to calculate how many hours a machine is utilized in a company with a night and day […]
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