Index of /courses/excel_course/topics/formulas
Name
Last modified
Size
Description
Parent Directory
-
year-is-a-leap-year.json
2025-10-22 14:42
2.1K
worksheet-name-exists.json
2025-10-22 14:42
1.7K
working-days-left-in-month.json
2025-10-22 14:42
2.6K
workdays-per-month.json
2025-10-22 14:42
2.1K
win-loss-points-calculation.json
2025-10-22 14:42
2.0K
weighted-average.json
2025-10-22 14:42
1.5K
volunteer-hours-requirement-calculation.json
2025-10-22 14:42
1.7K
vlookup-without-na-error.json
2025-10-22 14:42
2.1K
vlookup-with-two-client-rates.json
2025-10-22 14:42
1.6K
vlookup-with-numbers-and-text.json
2025-10-22 14:42
2.9K
vlookup-with-multiple-critiera.json
2025-10-22 14:42
3.1K
vlookup-with-2-lookup-tables.json
2025-10-22 14:42
2.3K
vlookup-from-another-workbook.json
2025-10-22 14:42
2.8K
vlookup-from-another-sheet.json
2025-10-22 14:42
2.2K
vlookup-by-date.json
2025-10-22 14:42
1.8K
value-is-within-tolerance.json
2025-10-22 14:42
1.6K
value-is-between-two-numbers.json
2025-10-22 14:42
2.0K
value-exists-in-a-range.json
2025-10-22 14:42
2.8K
validate-input-with-check-mark.json
2025-10-22 14:42
1.9K
two-way-summary-count-with-countifs.json
2025-10-22 14:42
1.9K
two-way-lookup-with-vlookup.json
2025-10-22 14:42
2.5K
two-way-lookup-with-index-and-match.json
2025-10-22 14:42
1.7K
transpose-table-without-zeros.json
2025-10-22 14:42
1.9K
total-rows-in-range.json
2025-10-22 14:42
1.2K
total-hours-that-fall-between-two-times.json
2025-10-22 14:42
2.6K
total-columns-in-range.json
2025-10-22 14:42
1.2K
total-cells-in-a-range.json
2025-10-22 14:42
1.6K
time-difference-in-hours-as-decimal-value.json
2025-10-22 14:42
3.3K
tax-rate-calculation-with-fixed-base.json
2025-10-22 14:42
1.6K
sumproduct-count-multiple-or-criteria.json
2025-10-22 14:42
2.1K
summary-count-with-percentage-breakdown.json
2025-10-22 14:42
1.9K
summary-count-with-countif.json
2025-10-22 14:42
2.6K
summary-count-of-non-blank-categories.json
2025-10-22 14:42
2.1K
summary-count-by-month-with-countifs.json
2025-10-22 14:42
3.2K
sumifs-with-multiple-criteria-and-or-logic.json
2025-10-22 14:42
2.6K
sum-visible-rows-in-a-filtered-list.json
2025-10-22 14:42
1.6K
sum-top-n-values.json
2025-10-22 14:42
3.1K
sum-top-n-values-with-criteria.json
2025-10-22 14:42
3.0K
sum-sales-in-last-30-days-by-id.json
2025-10-22 14:42
1.9K
sum-range-with-index.json
2025-10-22 14:42
2.1K
sum-race-time-splits.json
2025-10-22 14:42
2.1K
sum-lookup-values-using-sumif.json
2025-10-22 14:42
2.3K
sum-last-n-columns.json
2025-10-22 14:42
2.0K
sum-if-one-criteria-multiple-columns.json
2025-10-22 14:42
1.5K
sum-if-not-blank.json
2025-10-22 14:42
1.8K
sum-if-multiple-criteria.json
2025-10-22 14:42
1.6K
sum-if-less-than.json
2025-10-22 14:42
2.6K
sum-if-greater-than.json
2025-10-22 14:42
2.7K
sum-if-equal-to-one-of-many-things.json
2025-10-22 14:42
1.9K
sum-if-equal-to-either-x-or-y.json
2025-10-22 14:42
2.6K
sum-if-ends-with.json
2025-10-22 14:42
2.2K
sum-if-date-is-greater-than.json
2025-10-22 14:42
2.3K
sum-if-date-is-between.json
2025-10-22 14:42
1.9K
sum-if-cells-contain-specific-text.json
2025-10-22 14:42
2.1K
sum-if-cells-contain-either-x-or-y.json
2025-10-22 14:42
2.9K
sum-if-cells-contain-both-x-and-y.json
2025-10-22 14:42
1.9K
sum-if-cells-contain-an-asterisk.json
2025-10-22 14:42
2.4K
sum-if-cells-are-not-equal-to.json
2025-10-22 14:42
2.0K
sum-if-cells-are-equal-to.json
2025-10-22 14:42
1.8K
sum-if-cell-contains-text-in-another-cell.json
2025-10-22 14:42
2.5K
sum-if-by-year.json
2025-10-22 14:42
2.1K
sum-if-between.json
2025-10-22 14:42
2.3K
sum-if-begins-with.json
2025-10-22 14:42
2.1K
sum-every-nth-column.json
2025-10-22 14:42
2.6K
sum-every-n-rows.json
2025-10-22 14:42
1.8K
sum-every-3-cells.json
2025-10-22 14:42
2.0K
sum-entire-column.json
2025-10-22 14:42
1.7K
sum-columns-based-on-adjacent-criteria.json
2025-10-22 14:42
2.6K
sum-by-weekday.json
2025-10-22 14:42
2.7K
sum-by-week.json
2025-10-22 14:42
1.9K
sum-by-week-number.json
2025-10-22 14:42
1.8K
sum-by-month.json
2025-10-22 14:42
2.8K
sum-by-month-ignore-year.json
2025-10-22 14:42
2.0K
sum-by-group.json
2025-10-22 14:42
2.4K
sum-bottom-n-values.json
2025-10-22 14:42
2.7K
sum-bottom-n-values-with-criteria.json
2025-10-22 14:42
2.7K
sum-2d-range-with-multiple-criteria.json
2025-10-22 14:42
2.1K
subtotal-invoices-by-age.json
2025-10-22 14:42
1.6K
subtotal-by-invoice-number.json
2025-10-22 14:42
1.6K
subtotal-by-color.json
2025-10-22 14:42
1.7K
student-class-enrollment-with-table.json
2025-10-22 14:42
2.3K
strip-protocol-and-trailing-slash-from-url.json
2025-10-22 14:42
2.3K
strip-numeric-characters-from-cell.json
2025-10-22 14:42
3.3K
strip-non-numeric-characters.json
2025-10-22 14:42
2.9K
strip-html-from-text-or-numbers.json
2025-10-22 14:42
1.8K
square-root-of-number.json
2025-10-22 14:42
1.5K
split-text-with-delimiter.json
2025-10-22 14:42
2.6K
split-text-string-at-specific-character.json
2025-10-22 14:42
2.2K
split-text-and-numbers.json
2025-10-22 14:42
4.6K
split-payment-across-months.json
2025-10-22 14:42
2.1K
split-numbers-from-units-of-measure.json
2025-10-22 14:42
2.7K
split-dimensions-into-two-parts.json
2025-10-22 14:42
2.5K
split-dimensions-into-three-parts.json
2025-10-22 14:42
2.5K
smaller-of-two-values.json
2025-10-22 14:42
1.6K
simple-currency-conversion.json
2025-10-22 14:42
2.4K
shade-alternating-groups-of-n-rows.json
2025-10-22 14:42
2.2K
series-of-dates-by-year.json
2025-10-22 14:42
1.8K
series-of-dates-by-workdays.json
2025-10-22 14:42
2.1K
series-of-dates-by-weekends.json
2025-10-22 14:42
2.3K
series-of-dates-by-month.json
2025-10-22 14:42
1.9K
series-of-dates-by-day.json
2025-10-22 14:42
1.7K
self-contained-vlookup.json
2025-10-22 14:42
2.3K
search-multiple-worksheets-for-value.json
2025-10-22 14:42
3.1K
search-entire-worksheet-for-value.json
2025-10-22 14:42
2.1K
running-count-of-occurrence-in-list.json
2025-10-22 14:42
2.1K
round-to-nearest-1000.json
2025-10-22 14:42
1.5K
round-to-nearest-5.json
2025-10-22 14:42
2.2K
round-time-to-nearest-15-minutes.json
2025-10-22 14:42
1.7K
round-by-bundle-size.json
2025-10-22 14:42
2.0K
round-a-price-to-end-in-99.json
2025-10-22 14:42
1.3K
round-a-number.json
2025-10-22 14:42
1.4K
round-a-number-up.json
2025-10-22 14:42
1.7K
round-a-number-up-to-next-half.json
2025-10-22 14:42
1.3K
round-a-number-up-to-nearest-multiple.json
2025-10-22 14:42
1.9K
round-a-number-to-nearest-multiple.json
2025-10-22 14:42
1.7K
round-a-number-to-n-significant-digits.json
2025-10-22 14:42
3.0K
round-a-number-down.json
2025-10-22 14:42
1.8K
round-a-number-down-to-nearest-multiple.json
2025-10-22 14:42
1.8K
reverse-a-list-or-range.json
2025-10-22 14:42
2.2K
replace-one-character-with-another.json
2025-10-22 14:42
1.6K
remove-unwanted-characters.json
2025-10-22 14:42
2.2K
remove-text-by-variable-position.json
2025-10-22 14:42
2.1K
remove-text-by-position.json
2025-10-22 14:42
1.7K
remove-text-by-matching.json
2025-10-22 14:42
1.9K
remove-leading-and-trailing-spaces-from-text.json
2025-10-22 14:42
2.3K
remove-file-extension-from-filename.json
2025-10-22 14:42
1.8K
remove-characters-from-right.json
2025-10-22 14:42
2.4K
remove-characters-from-left.json
2025-10-22 14:42
2.1K
rank-with-ordinal-suffix.json
2025-10-22 14:42
2.2K
rank-race-results.json
2025-10-22 14:42
1.4K
rank-function-example.json
2025-10-22 14:42
1.5K
range-contains-specific-text.json
2025-10-22 14:42
2.0K
range-contains-one-of-many-values.json
2025-10-22 14:42
2.4K
range-contains-one-of-many-substrings.json
2025-10-22 14:42
1.9K
range-contains-numbers.json
2025-10-22 14:42
1.9K
range-contains-a-value-not-in-another-range.json
2025-10-22 14:42
2.0K
randomly-assign-people-to-groups.json
2025-10-22 14:42
2.8K
randomly-assign-data-to-groups.json
2025-10-22 14:42
2.4K
random-value-from-list-or-table.json
2025-10-22 14:42
2.3K
random-times-at-specific-intervals.json
2025-10-22 14:42
2.4K
random-text-values.json
2025-10-22 14:42
2.1K
random-number-from-fixed-set-of-options.json
2025-10-22 14:42
2.4K
random-number-between-two-numbers.json
2025-10-22 14:42
1.7K
random-date-between-two-dates.json
2025-10-22 14:42
2.5K
put-names-into-proper-case.json
2025-10-22 14:42
1.4K
project-complete-percentage.json
2025-10-22 14:42
1.5K
position-of-max-value-in-list.json
2025-10-22 14:42
2.0K
position-of-first-partial-match.json
2025-10-22 14:42
1.8K
position-of-2nd-3rd-etc-instance-of-character.json
2025-10-22 14:42
1.9K
percent-sold.json
2025-10-22 14:42
1.6K
percent-of-students-absent.json
2025-10-22 14:42
2.0K
percent-of-goal.json
2025-10-22 14:42
2.0K
partial-match-with-vlookup.json
2025-10-22 14:42
2.3K
partial-match-against-numbers-with-wildcard.json
2025-10-22 14:42
2.3K
pad-week-numbers-with-zeros.json
2025-10-22 14:42
1.7K
pad-a-number-with-zeros.json
2025-10-22 14:42
2.3K
nth-smallest-value.json
2025-10-22 14:42
1.4K
nth-smallest-value-with-criteria.json
2025-10-22 14:42
2.5K
nth-root-of-number.json
2025-10-22 14:42
1.6K
nth-largest-value.json
2025-10-22 14:42
1.5K
nth-largest-value-with-duplicates.json
2025-10-22 14:42
2.2K
nth-largest-value-with-criteria.json
2025-10-22 14:42
2.3K
normalize-text.json
2025-10-22 14:42
3.1K
normalize-size-units-to-gigabytes.json
2025-10-22 14:42
2.2K
next-working-day.json
2025-10-22 14:42
1.6K
next-largest-match-with-the-match-function.json
2025-10-22 14:42
2.0K
next-business-day-6-months-in-future.json
2025-10-22 14:42
1.7K
next-biweekly-payday-from-date.json
2025-10-22 14:42
2.2K
next-anniversary-date.json
2025-10-22 14:42
2.0K
nested-if-function-example.json
2025-10-22 14:42
3.0K
multiplication-table-formula.json
2025-10-22 14:42
2.9K
multiple-matches-in-comma-separated-list.json
2025-10-22 14:42
2.1K
multiple-chained-vlookups.json
2025-10-22 14:42
1.8K
multiple-cells-have-same-value.json
2025-10-22 14:42
1.8K
multiple-cells-have-same-value-case-sensitive.json
2025-10-22 14:42
2.1K
multiple-cells-are-equal.json
2025-10-22 14:42
2.4K
multi-criteria-lookup-and-transpose.json
2025-10-22 14:42
2.1K
most-frequently-occurring-text.json
2025-10-22 14:42
2.5K
most-frequently-occurring-number.json
2025-10-22 14:42
1.4K
minimum-value.json
2025-10-22 14:42
1.3K
minimum-value-if.json
2025-10-22 14:42
2.1K
minimum-if-multiple-criteria.json
2025-10-22 14:42
3.2K
merge-tables-with-vlookup.json
2025-10-22 14:42
2.8K
maximum-value.json
2025-10-22 14:42
1.3K
maximum-value-if.json
2025-10-22 14:42
2.1K
maximum-if-multiple-criteria.json
2025-10-22 14:42
3.2K
max-of-every-nth-column.json
2025-10-22 14:42
2.8K
max-if-criteria-match.json
2025-10-22 14:42
2.3K
match-next-highest-value.json
2025-10-22 14:42
2.0K
match-first-error.json
2025-10-22 14:42
2.0K
map-text-to-numbers.json
2025-10-22 14:42
2.3K
map-inputs-to-arbitrary-values.json
2025-10-22 14:42
2.7K
lookup-with-variable-sheet-name.json
2025-10-22 14:42
2.3K
lookup-up-cost-for-product-or-service.json
2025-10-22 14:42
1.9K
lookup-lowest-value.json
2025-10-22 14:42
1.6K
lookup-latest-price.json
2025-10-22 14:42
2.2K
lookup-last-file-version.json
2025-10-22 14:42
3.3K
lookup-last-file-revision.json
2025-10-22 14:42
3.8K
lookup-entire-row.json
2025-10-22 14:42
2.1K
lookup-entire-column.json
2025-10-22 14:42
2.0K
lookup-and-sum-column.json
2025-10-22 14:42
1.8K
longest-winning-streak.json
2025-10-22 14:42
2.8K
list-sheet-index-numbers.json
2025-10-22 14:42
1.5K
list-most-frequently-occuring-numbers.json
2025-10-22 14:42
3.3K
list-holidays-between-two-dates.json
2025-10-22 14:42
2.3K
list-contains-duplicates.json
2025-10-22 14:42
2.5K
leave-a-comment-in-a-formula.json
2025-10-22 14:42
1.5K
last-updated-date-stamp.json
2025-10-22 14:42
2.2K
last-row-number-in-range.json
2025-10-22 14:42
2.4K
last-row-in-text-data.json
2025-10-22 14:42
3.2K
last-row-in-numeric-data.json
2025-10-22 14:42
3.2K
last-row-in-mixed-data-with-no-blanks.json
2025-10-22 14:42
2.5K
last-row-in-mixed-data-with-blanks.json
2025-10-22 14:42
3.0K
last-column-number-in-range.json
2025-10-22 14:42
2.5K
larger-of-two-values.json
2025-10-22 14:42
1.6K
large-with-criteria.json
2025-10-22 14:42
1.9K
join-tables-with-index-and-match.json
2025-10-22 14:42
2.9K
join-first-and-last-name.json
2025-10-22 14:42
2.2K
join-date-and-text.json
2025-10-22 14:42
1.6K
join-cells-with-comma.json
2025-10-22 14:42
2.7K
issue-response-time-calculation.json
2025-10-22 14:42
1.9K
invoice-status-with-nested-if.json
2025-10-22 14:42
1.8K
indirect-named-range-different-sheet.json
2025-10-22 14:42
1.9K
index-and-match-with-multiple-criteria.json
2025-10-22 14:42
2.8K
index-and-match-descending-order.json
2025-10-22 14:42
2.5K
increment-a-number-in-a-text-string.json
2025-10-22 14:42
2.1K
increment-a-calculation-with-row-or-column.json
2025-10-22 14:42
2.1K
increase-by-percentage.json
2025-10-22 14:42
1.6K
if-this-and-that.json
2025-10-22 14:42
2.5K
if-this-and-that-or-that.json
2025-10-22 14:42
2.1K
if-not-this-or-that.json
2025-10-22 14:42
2.7K
if-monday-roll-back-to-friday.json
2025-10-22 14:42
1.8K
if-else.json
2025-10-22 14:42
2.9K
if-cell-is-x-or-y-and-z.json
2025-10-22 14:42
1.9K
if-cell-is-this-or-that.json
2025-10-22 14:42
2.7K
if-cell-is-not-blank.json
2025-10-22 14:42
2.0K
if-cell-is-greater-than.json
2025-10-22 14:42
1.8K
if-cell-is-blank.json
2025-10-22 14:42
1.9K
if-cell-equals.json
2025-10-22 14:42
2.5K
if-cell-contains.json
2025-10-22 14:42
1.9K
if-cell-contains-this-or-that.json
2025-10-22 14:42
2.1K
if-cell-contains-one-of-many-things.json
2025-10-22 14:42
2.6K
if-cell-begins-with-x-y-or-z.json
2025-10-22 14:42
2.6K
hyperlink-to-first-match.json
2025-10-22 14:42
2.0K
hyperlink-to-first-blank-cell.json
2025-10-22 14:42
2.4K
highlight-values-not-between-x-and-y.json
2025-10-22 14:42
3.0K
highlight-values-greater-than.json
2025-10-22 14:42
2.9K
highlight-values-between.json
2025-10-22 14:42
3.3K
highlight-unprotected-cells.json
2025-10-22 14:42
1.8K
highlight-unique-values.json
2025-10-22 14:42
2.6K
highlight-top-values.json
2025-10-22 14:42
2.1K
highlight-rows-with-dates-between.json
2025-10-22 14:42
2.5K
highlight-rows-with-blank-cells.json
2025-10-22 14:42
2.1K
highlight-rows-that-contain.json
2025-10-22 14:42
3.0K
highlight-row-and-column-intersection-exact-match.json
2025-10-22 14:42
2.8K
highlight-numbers-that-include-symbols.json
2025-10-22 14:42
1.9K
highlight-multiples-of-specific-value.json
2025-10-22 14:42
2.1K
highlight-missing-values.json
2025-10-22 14:42
2.7K
highlight-integers-only.json
2025-10-22 14:42
1.8K
highlight-every-other-row.json
2025-10-22 14:42
2.1K
highlight-entire-rows.json
2025-10-22 14:42
3.2K
highlight-duplicate-values.json
2025-10-22 14:42
2.7K
highlight-duplicate-rows.json
2025-10-22 14:42
3.1K
highlight-duplicate-columns.json
2025-10-22 14:42
2.1K
highlight-dates-that-are-weekends.json
2025-10-22 14:42
2.1K
highlight-dates-in-the-next-n-days.json
2025-10-22 14:42
2.6K
highlight-dates-in-same-month-and-year.json
2025-10-22 14:42
2.6K
highlight-dates-greater-than.json
2025-10-22 14:42
2.4K
highlight-dates-between.json
2025-10-22 14:42
2.5K
highlight-data-by-quartile.json
2025-10-22 14:42
2.0K
highlight-column-differences.json
2025-10-22 14:42
2.7K
highlight-cells-that-equal.json
2025-10-22 14:42
2.7K
highlight-cells-that-end-with.json
2025-10-22 14:42
3.3K
highlight-cells-that-contain.json
2025-10-22 14:42
2.8K
highlight-cells-that-contain-one-of-many.json
2025-10-22 14:42
2.1K
highlight-cells-that-begin-with.json
2025-10-22 14:42
2.9K
highlight-bottom-values.json
2025-10-22 14:42
2.1K
highlight-blank-cells.json
2025-10-22 14:42
2.4K
highlight-approximate-match-lookup-conditional-formatting.json
2025-10-22 14:42
3.0K
highlight-3-smallest-values-with-criteria.json
2025-10-22 14:42
2.4K
group-times-into-unequal-buckets.json
2025-10-22 14:42
2.6K
group-times-into-3-hour-buckets.json
2025-10-22 14:42
2.9K
group-numbers-with-vlookup.json
2025-10-22 14:42
1.9K
group-numbers-into-ranges-with-countifs.json
2025-10-22 14:42
2.1K
group-arbitrary-text-values.json
2025-10-22 14:42
2.0K
get-year-from-date.json
2025-10-22 14:42
1.8K
get-workdays-between-dates.json
2025-10-22 14:42
2.2K
get-workbook-path-only.json
2025-10-22 14:42
1.5K
get-workbook-name-only.json
2025-10-22 14:42
1.5K
get-workbook-name-and-path-without-sheet.json
2025-10-22 14:42
1.8K
get-work-hours-between-dates.json
2025-10-22 14:42
1.9K
get-work-hours-between-dates-custom-schedule.json
2025-10-22 14:42
3.2K
get-week-number-from-date.json
2025-10-22 14:42
2.3K
get-value-of-last-non-empty-cell.json
2025-10-22 14:42
2.9K
get-total-from-percentage.json
2025-10-22 14:42
1.3K
get-top-level-domain-tld.json
2025-10-22 14:42
3.6K
get-start-date-based-on-target-date.json
2025-10-22 14:42
2.2K
get-sheet-name-only.json
2025-10-22 14:42
1.9K
get-same-date-next-year.json
2025-10-22 14:42
1.3K
get-same-date-next-month.json
2025-10-22 14:42
1.2K
get-relative-row-numbers-in-range.json
2025-10-22 14:42
2.4K
get-relative-column-numbers-in-range.json
2025-10-22 14:42
2.2K
get-quarter-from-date.json
2025-10-22 14:42
1.6K
get-profit-margin-percentage.json
2025-10-22 14:42
1.3K
get-pivot-table-subtotal.json
2025-10-22 14:42
2.3K
get-pivot-table-subtotal-grouped-date.json
2025-10-22 14:42
2.6K
get-pivot-table-grand-total.json
2025-10-22 14:42
1.9K
get-percentage-of-total.json
2025-10-22 14:42
1.8K
get-percentage-discount.json
2025-10-22 14:42
1.5K
get-percent-of-year-complete.json
2025-10-22 14:42
2.0K
get-percent-change.json
2025-10-22 14:42
1.4K
get-original-price-from-percentage-discount.json
2025-10-22 14:42
1.5K
get-original-number-from-percent-change.json
2025-10-22 14:42
1.6K
get-number-at-place-value.json
2025-10-22 14:42
1.6K
get-nth-match.json
2025-10-22 14:42
2.6K
get-nth-match-with-vlookup.json
2025-10-22 14:42
2.4K
get-nth-match-with-index-match.json
2025-10-22 14:42
2.7K
get-nth-day-of-year.json
2025-10-22 14:42
1.8K
get-nth-day-of-week-in-month.json
2025-10-22 14:42
1.9K
get-next-day-of-week.json
2025-10-22 14:42
2.4K
get-name-from-email-address.json
2025-10-22 14:42
1.9K
get-most-recent-day-of-week.json
2025-10-22 14:42
1.8K
get-months-between-dates.json
2025-10-22 14:42
1.9K
get-month-name-from-date.json
2025-10-22 14:42
2.5K
get-month-from-date.json
2025-10-22 14:42
1.8K
get-middle-name-from-full-name.json
2025-10-22 14:42
2.6K
get-location-of-value-in-2d-array.json
2025-10-22 14:42
2.2K
get-last-working-day-in-month.json
2025-10-22 14:42
1.8K
get-last-word.json
2025-10-22 14:42
2.4K
get-last-weekday-in-month.json
2025-10-22 14:42
2.2K
get-last-name-from-name.json
2025-10-22 14:42
4.6K
get-last-name-from-name-with-comma.json
2025-10-22 14:42
2.2K
get-last-match.json
2025-10-22 14:42
2.7K
get-last-match-cell-contains.json
2025-10-22 14:42
3.2K
get-last-line-in-cell.json
2025-10-22 14:42
2.1K
get-last-entry-by-month-and-year.json
2025-10-22 14:42
2.3K
get-last-day-of-month.json
2025-10-22 14:42
1.8K
get-integer-part-of-a-number.json
2025-10-22 14:42
2.5K
get-information-corresponding-to-max-value.json
2025-10-22 14:42
2.1K
get-full-workbook-name-and-path.json
2025-10-22 14:42
1.6K
get-fiscal-year-from-date.json
2025-10-22 14:42
1.8K
get-fiscal-quarter-from-date.json
2025-10-22 14:42
2.1K
get-first-word.json
2025-10-22 14:42
2.1K
get-first-text-value-with-hlookup.json
2025-10-22 14:42
2.2K
get-first-text-value-in-a-list.json
2025-10-22 14:42
1.8K
get-first-non-blank-value-in-a-list.json
2025-10-22 14:42
2.6K
get-first-name-from-name.json
2025-10-22 14:42
2.2K
get-first-name-from-name-with-comma.json
2025-10-22 14:42
2.4K
get-first-monday-before-any-date.json
2025-10-22 14:42
2.9K
get-first-match-cell-contains.json
2025-10-22 14:42
3.1K
get-first-entry-by-month-and-year.json
2025-10-22 14:42
2.8K
get-first-day-of-previous-month.json
2025-10-22 14:42
1.6K
get-first-day-of-month.json
2025-10-22 14:42
1.7K
get-employee-information-with-vlookup.json
2025-10-22 14:42
2.1K
get-domain-name-from-url.json
2025-10-22 14:42
2.4K
get-domain-from-email-address.json
2025-10-22 14:42
2.1K
get-decimal-part-of-a-number.json
2025-10-22 14:42
1.4K
get-days-months-and-years-between-dates.json
2025-10-22 14:42
2.3K
get-days-hours-and-minutes-between-dates.json
2025-10-22 14:42
1.9K
get-days-between-dates.json
2025-10-22 14:42
1.9K
get-days-between-dates-ignoring-years.json
2025-10-22 14:42
1.6K
get-days-before-a-date.json
2025-10-22 14:42
2.1K
get-day-name-from-date.json
2025-10-22 14:42
2.5K
get-day-from-date.json
2025-10-22 14:42
1.6K
get-date-from-day-number.json
2025-10-22 14:42
2.0K
get-date-associated-with-last-entry.json
2025-10-22 14:42
2.1K
get-amount-with-percentage.json
2025-10-22 14:42
1.5K
get-age-from-birthday.json
2025-10-22 14:42
2.6K
get-address-of-named-range.json
2025-10-22 14:42
2.9K
get-address-of-lookup-result.json
2025-10-22 14:42
1.4K
formula-with-locked-reference.json
2025-10-22 14:42
2.2K
force-negative-numbers-to-zero.json
2025-10-22 14:42
1.8K
flip-table-rows-to-columns.json
2025-10-22 14:42
1.9K
flag-first-duplicate-in-a-list.json
2025-10-22 14:42
2.4K
fixed-value-every-n-months.json
2025-10-22 14:42
2.4K
first-row-number-in-range.json
2025-10-22 14:42
2.4K
first-match-in-range-with-wildcard.json
2025-10-22 14:42
1.8K
first-match-between-two-ranges.json
2025-10-22 14:42
2.4K
first-in-last-out-times.json
2025-10-22 14:42
2.2K
first-column-number-in-range.json
2025-10-22 14:42
2.2K
find-nth-occurrence-of-character.json
2025-10-22 14:42
1.9K
find-missing-values.json
2025-10-22 14:42
2.8K
find-lowest-n-values.json
2025-10-22 14:42
2.2K
find-longest-string-with-criteria.json
2025-10-22 14:42
2.2K
find-longest-string-in-column.json
2025-10-22 14:42
2.0K
find-duplicate-values-in-two-columns.json
2025-10-22 14:42
1.8K
filter-values-in-array-formula.json
2025-10-22 14:42
2.1K
faster-vlookup-with-2-vlookups.json
2025-10-22 14:42
3.7K
extract-word-that-begins-with-specific-character.json
2025-10-22 14:42
2.6K
extract-word-containing-specific-text.json
2025-10-22 14:42
2.8K
extract-unique-items-from-a-list.json
2025-10-22 14:42
4.1K
extract-time-from-a-date-and-time.json
2025-10-22 14:42
2.1K
extract-text-between-parentheses.json
2025-10-22 14:42
2.2K
extract-nth-word-from-text-string.json
2025-10-22 14:42
2.5K
extract-multiple-matches-into-separate-rows.json
2025-10-22 14:42
2.9K
extract-multiple-matches-into-separate-columns.json
2025-10-22 14:42
2.8K
extract-multiple-lines-from-a-cell.json
2025-10-22 14:42
2.8K
extract-last-two-words-from-cell.json
2025-10-22 14:42
3.0K
extract-date-from-a-date-and-time.json
2025-10-22 14:42
2.0K
extract-data-with-helper-column.json
2025-10-22 14:42
4.0K
exact-match-lookup-with-sumproduct.json
2025-10-22 14:42
3.0K
exact-match-lookup-with-index-and-match.json
2025-10-22 14:42
3.0K
easy-bundle-pricing-with-sumproduct.json
2025-10-22 14:42
2.5K
dynamic-worksheet-reference.json
2025-10-22 14:42
2.1K
dynamic-workbook-reference.json
2025-10-22 14:42
2.2K
dynamic-named-range-with-offset.json
2025-10-22 14:42
3.7K
dynamic-named-range-with-index.json
2025-10-22 14:42
3.1K
dynamic-lookup-table-with-indirect.json
2025-10-22 14:42
2.4K
double-quotes-inside-a-formula.json
2025-10-22 14:42
2.2K
display-the-current-date.json
2025-10-22 14:42
1.6K
display-the-current-date-and-time.json
2025-10-22 14:42
1.9K
decrease-by-percentage.json
2025-10-22 14:42
1.5K
days-until-expiration-date.json
2025-10-22 14:42
1.8K
days-in-month.json
2025-10-22 14:42
1.4K
date-is-workday.json
2025-10-22 14:42
2.3K
date-is-same-month.json
2025-10-22 14:42
1.6K
date-is-same-month-and-year.json
2025-10-22 14:42
1.7K
data-validation-with-conditional-list.json
2025-10-22 14:42
2.5K
data-validation-whole-percentage-only.json
2025-10-22 14:42
2.3K
data-validation-unique-values-only.json
2025-10-22 14:42
1.9K
data-validation-require-unique-number.json
2025-10-22 14:42
2.4K
data-validation-only-dates-between.json
2025-10-22 14:42
2.2K
data-validation-must-not-exist-in-list.json
2025-10-22 14:42
2.1K
data-validation-must-not-contain.json
2025-10-22 14:42
2.3K
data-validation-must-begin-with.json
2025-10-22 14:42
2.1K
data-validation-exists-in-list.json
2025-10-22 14:42
1.9K
data-validation-dont-exceed-total.json
2025-10-22 14:42
2.0K
data-validation-date-in-specific-year.json
2025-10-22 14:42
2.3K
data-validation-date-in-next-30-days.json
2025-10-22 14:42
2.3K
data-validation-contains-specific-text.json
2025-10-22 14:42
2.1K
data-validation-allow-weekday-only.json
2025-10-22 14:42
2.4K
data-validation-allow-uppercase-only.json
2025-10-22 14:42
2.0K
data-validation-allow-text-only.json
2025-10-22 14:42
1.5K
data-validation-allow-numbers-only.json
2025-10-22 14:42
1.8K
custom-weekday-abbreviation.json
2025-10-22 14:42
1.9K
cube-root-of-number.json
2025-10-22 14:42
1.4K
create-email-address-with-name-and-domain.json
2025-10-22 14:42
2.1K
create-email-address-from-name.json
2025-10-22 14:42
2.3K
create-date-range-from-two-dates.json
2025-10-22 14:42
2.0K
create-array-of-numbers.json
2025-10-22 14:42
2.6K
course-completion-summary-with-criteria.json
2025-10-22 14:42
2.5K
course-completion-status-summary.json
2025-10-22 14:42
2.7K
countifs-with-multiple-criteria-and-or-logic.json
2025-10-22 14:42
2.6K
countif-by-weekday.json
2025-10-22 14:42
2.5K
count-with-repeating-values.json
2025-10-22 14:42
2.2K
count-visible-rows-only-with-criteria.json
2025-10-22 14:42
2.7K
count-visible-rows-in-a-filtered-list.json
2025-10-22 14:42
1.7K
count-unique-values-in-a-range-with-countif.json
2025-10-22 14:42
2.9K
count-unique-text-values-with-criteria.json
2025-10-22 14:42
3.8K
count-unique-text-values-in-a-range.json
2025-10-22 14:42
5.2K
count-unique-numeric-values-with-criteria.json
2025-10-22 14:42
3.1K
count-unique-numeric-values-in-a-range.json
2025-10-22 14:42
2.9K
count-total-words-in-a-range.json
2025-10-22 14:42
2.2K
count-total-words-in-a-cell.json
2025-10-22 14:42
1.9K
count-total-matches-in-two-ranges.json
2025-10-22 14:42
3.1K
count-total-characters-in-a-range.json
2025-10-22 14:42
1.4K
count-total-characters-in-a-cell.json
2025-10-22 14:42
1.4K
count-times-in-a-specific-range.json
2025-10-22 14:42
1.9K
count-specific-words-in-a-range.json
2025-10-22 14:42
3.1K
count-specific-words-in-a-cell.json
2025-10-22 14:42
3.3K
count-specific-characters-in-a-range.json
2025-10-22 14:42
2.5K
count-specific-characters-in-a-cell.json
2025-10-22 14:42
2.1K
count-sold-and-remaining.json
2025-10-22 14:42
2.0K
count-rows-with-multiple-or-criteria.json
2025-10-22 14:42
2.6K
count-rows-with-at-least-n-matching-values.json
2025-10-22 14:42
2.7K
count-rows-that-contain-specific-values.json
2025-10-22 14:42
2.9K
count-paired-items-in-listed-combinations.json
2025-10-22 14:42
2.6K
count-occurrences-in-entire-workbook.json
2025-10-22 14:42
2.3K
count-numbers-that-begin-with.json
2025-10-22 14:42
1.8K
count-multiple-criteria-with-not-logic.json
2025-10-22 14:42
2.6K
count-missing-values.json
2025-10-22 14:42
2.2K
count-matches-between-two-columns.json
2025-10-22 14:42
2.2K
count-long-numbers-without-countif.json
2025-10-22 14:42
3.5K
count-line-breaks-in-cell.json
2025-10-22 14:42
1.9K
count-items-in-list.json
2025-10-22 14:42
1.8K
count-if-two-criteria-match.json
2025-10-22 14:42
2.0K
count-if-row-meets-multiple-internal-criteria.json
2025-10-22 14:42
2.7K
count-if-row-meets-internal-criteria.json
2025-10-22 14:42
2.7K
count-holidays-between-two-dates.json
2025-10-22 14:42
2.1K
count-day-of-week-between-dates.json
2025-10-22 14:42
2.5K
count-consecutive-monthly-orders.json
2025-10-22 14:42
3.0K
count-cells-that-end-with.json
2025-10-22 14:42
1.6K
count-cells-that-do-not-contain.json
2025-10-22 14:42
2.0K
count-cells-that-do-not-contain-errors.json
2025-10-22 14:42
2.3K
count-cells-that-contain-text.json
2025-10-22 14:42
2.4K
count-cells-that-contain-specific-text.json
2025-10-22 14:42
2.6K
count-cells-that-contain-positive-numbers.json
2025-10-22 14:42
1.7K
count-cells-that-contain-odd-numbers.json
2025-10-22 14:42
2.1K
count-cells-that-contain-numbers.json
2025-10-22 14:42
1.4K
count-cells-that-contain-negative-numbers.json
2025-10-22 14:42
1.7K
count-cells-that-contain-five-characters.json
2025-10-22 14:42
1.7K
count-cells-that-contain-errors.json
2025-10-22 14:42
2.1K
count-cells-that-contain-either-x-or-y.json
2025-10-22 14:42
3.1K
count-cells-that-begin-with.json
2025-10-22 14:42
1.6K
count-cells-that-are-not-blank.json
2025-10-22 14:42
1.8K
count-cells-that-are-blank.json
2025-10-22 14:42
1.4K
count-cells-over-100-characters.json
2025-10-22 14:42
1.7K
count-cells-not-equal-to.json
2025-10-22 14:42
2.1K
count-cells-not-equal-to-x-or-y.json
2025-10-22 14:42
1.9K
count-cells-not-equal-to-many-things.json
2025-10-22 14:42
2.4K
count-cells-less-than.json
2025-10-22 14:42
1.6K
count-cells-greater-than.json
2025-10-22 14:42
1.7K
count-cells-equal-to.json
2025-10-22 14:42
1.5K
count-cells-equal-to-one-of-many-things.json
2025-10-22 14:42
2.3K
count-cells-equal-to-either-x-or-y.json
2025-10-22 14:42
2.2K
count-cells-equal-to-case-sensitive.json
2025-10-22 14:42
2.3K
count-cells-between-two-numbers.json
2025-10-22 14:42
2.3K
count-cells-between-dates.json
2025-10-22 14:42
1.9K
count-birthdays-by-month.json
2025-10-22 14:42
1.9K
copy-value-from-every-nth-row.json
2025-10-22 14:42
2.8K
copy-value-from-every-nth-column.json
2025-10-22 14:42
2.7K
convert-time-to-time-zone.json
2025-10-22 14:42
3.4K
convert-text-to-numbers.json
2025-10-22 14:42
2.6K
convert-text-to-date.json
2025-10-22 14:42
3.8K
convert-text-date-ddmmyy-to-mmddyy.json
2025-10-22 14:42
2.4K
convert-string-to-array.json
2025-10-22 14:42
2.2K
convert-numbers-to-text.json
2025-10-22 14:42
2.0K
convert-decimal-seconds-to-excel-time.json
2025-10-22 14:42
2.2K
convert-decimal-minutes-to-excel-time.json
2025-10-22 14:42
2.1K
convert-decimal-hours-to-excel-time.json
2025-10-22 14:42
2.1K
convert-date-to-text.json
2025-10-22 14:42
3.3K
convert-date-to-month-and-year.json
2025-10-22 14:42
1.6K
convert-date-to-julian-format.json
2025-10-22 14:42
3.2K
convert-date-string-to-date-time.json
2025-10-22 14:42
2.4K
convert-column-number-to-letter.json
2025-10-22 14:42
1.6K
convert-column-letter-to-number.json
2025-10-22 14:42
1.6K
conditional-formatting-highlight-target-percentage.json
2025-10-22 14:42
2.3K
conditional-formatting-gantt-chart.json
2025-10-22 14:42
2.0K
conditional-formatting-gantt-chart-weekends.json
2025-10-22 14:42
2.4K
conditional-formatting-dates-overlap.json
2025-10-22 14:42
2.1K
compare-two-strings.json
2025-10-22 14:42
1.5K
clean-and-reformat-telephone-numbers.json
2025-10-22 14:42
2.7K
check-register-balance.json
2025-10-22 14:42
1.8K
change-negative-numbers-to-positive.json
2025-10-22 14:42
1.8K
cell-equals-one-of-many-things.json
2025-10-22 14:42
3.2K
cell-contains-which-things.json
2025-10-22 14:42
2.5K
cell-contains-specific-text.json
2025-10-22 14:42
2.9K
cell-contains-some-words-but-not-others.json
2025-10-22 14:42
2.8K
cell-contains-one-of-many-with-exclusions.json
2025-10-22 14:42
2.2K
cell-contains-one-of-many-things.json
2025-10-22 14:42
4.2K
cell-contains-number.json
2025-10-22 14:42
2.6K
cell-contains-all-of-many-things.json
2025-10-22 14:42
3.4K
categorize-text-with-keywords.json
2025-10-22 14:42
3.3K
cash-denomination-calculator.json
2025-10-22 14:42
2.8K
case-sensitive-match.json
2025-10-22 14:42
1.7K
cap-percentage-at-specific-amount.json
2025-10-22 14:42
1.6K
calculate-years-between-dates.json
2025-10-22 14:42
2.0K
calculate-simple-interest.json
2025-10-22 14:42
1.5K
calculate-shipping-cost-with-vlookup.json
2025-10-22 14:42
2.1K
calculate-running-total.json
2025-10-22 14:42
1.8K
calculate-retirement-date.json
2025-10-22 14:42
2.8K
calculate-principal-for-given-period.json
2025-10-22 14:42
2.0K
calculate-percent-variance.json
2025-10-22 14:42
2.4K
calculate-payment-periods-for-loan.json
2025-10-22 14:42
2.6K
calculate-payment-for-a-loan.json
2025-10-22 14:42
2.1K
calculate-original-loan-amount.json
2025-10-22 14:42
2.3K
calculate-number-of-hours-between-two-times.json
2025-10-22 14:42
4.4K
calculate-interest-rate-for-loan.json
2025-10-22 14:42
2.1K
calculate-interest-for-given-period.json
2025-10-22 14:42
2.0K
calculate-grades-with-vlookup.json
2025-10-22 14:42
2.4K
calculate-expiration-date.json
2025-10-22 14:42
1.9K
calculate-days-remaining.json
2025-10-22 14:42
2.0K
calculate-date-overlap-in-days.json
2025-10-22 14:42
1.8K
calculate-cumulative-loan-principal-payments.json
2025-10-22 14:42
2.3K
calculate-cumulative-loan-interest.json
2025-10-22 14:42
2.2K
calculate-compound-interest.json
2025-10-22 14:42
1.8K
calculate-a-ratio-from-two-numbers.json
2025-10-22 14:42
1.8K
build-hyperlink-with-vlookup.json
2025-10-22 14:42
1.8K
break-ties-with-helper-column-and-countif.json
2025-10-22 14:42
3.1K
basic-tax-rate-calculation-with-vlookup.json
2025-10-22 14:42
2.3K
basic-overtime-calculation-formula.json
2025-10-22 14:42
2.8K
basic-index-match-exact.json
2025-10-22 14:42
2.5K
basic-index-match-approximate.json
2025-10-22 14:42
2.1K
basic-in-cell-histogram.json
2025-10-22 14:42
1.8K
basic-error-trapping-example.json
2025-10-22 14:42
1.9K
basic-attendance-tracking-formula.json
2025-10-22 14:42
1.4K
average-top-3-scores.json
2025-10-22 14:42
1.7K
average-the-last-3-numeric-values.json
2025-10-22 14:42
2.9K
average-response-time-per-month.json
2025-10-22 14:42
2.7K
average-numbers.json
2025-10-22 14:42
1.4K
average-numbers-ignore-zero.json
2025-10-22 14:42
1.3K
average-last-5-values.json
2025-10-22 14:42
2.2K
average-last-5-values-in-columns.json
2025-10-22 14:42
2.7K
average-by-month.json
2025-10-22 14:42
2.8K
assign-points-based-on-late-time.json
2025-10-22 14:42
1.8K
approximate-match-with-multiple-criteria.json
2025-10-22 14:42
2.4K
annual-compound-interest-schedule.json
2025-10-22 14:42
1.8K
all-cells-in-range-are-blank.json
2025-10-22 14:42
1.9K
address-of-last-cell-in-range.json
2025-10-22 14:42
2.3K
address-of-first-cell-in-range.json
2025-10-22 14:42
2.3K
add-years-to-date.json
2025-10-22 14:42
1.6K
add-workdays-to-date-custom-weekends.json
2025-10-22 14:42
3.2K
add-workdays-no-weekends.json
2025-10-22 14:42
2.0K
add-months-to-date.json
2025-10-22 14:42
1.3K
add-line-break-based-on-os.json
2025-10-22 14:42
2.0K
add-decimal-minutes-to-time.json
2025-10-22 14:42
2.5K
add-decimal-hours-to-time.json
2025-10-22 14:42
2.6K
add-days-to-date.json
2025-10-22 14:42
1.4K
add-days-exclude-certain-days-of-week.json
2025-10-22 14:42
2.0K
add-business-days-to-date.json
2025-10-22 14:42
3.3K
add-a-line-break-with-a-formula.json
2025-10-22 14:42
1.7K
abbreviate-state-names.json
2025-10-22 14:42
2.9K
abbreviate-names-or-words.json
2025-10-22 14:42
2.8K
3d-sumif-for-multiple-worksheets.json
2025-10-22 14:42
2.6K
3d-sum-multiple-worksheets.json
2025-10-22 14:42
1.6K
Apache/2.4.58 (Ubuntu) Server at excel.ticketss.app Port 443