get-digital-help.com Open in urlscan Pro
2606:4700:20::ac43:4406  Public Scan

Form analysis
2 forms found in the DOM

https://www.google.com/cse

<form action="https://www.google.com/cse" id="mobile-cse-search-box">
  <input type="hidden" name="cx" value="013556871081535795816:kktl2_rs2y0">
  <input type="hidden" name="ie" value="UTF-8">
  <input type="text" name="q" id="googlecse" style="width: 200px; font-size: 12pt;border: 1px solid rgb(126, 157, 185); padding: 2px; background: url(" https:="" www.google.com="" cse="" static="" images="" 1x="" googlelogo_lightgrey_46x16dp.png")=""
    left="" center="" no-repeat="" rgb(255,="" 255,="" 255);="" text-indent:="" 48px;"="" placeholder="Website Search">
  <input style="font-size:12pt;margin-top:10px; font-size: 12pt; background-color: #6f5fff; color: white; border: 2px solid #6f5fff; border-radius: 4px;" type="submit" name="sa" value="Search">
</form>

https://www.google.com/cse

<form action="https://www.google.com/cse" id="cse-search-box">
  <div id="test" style="border:1px solid #ccc;padding:9px;text-align:left;vertical-align:middle;">
    <p style="font-size:14pt;margin-bottom:10px;">Search website</p>
    <input type="hidden" name="cx" value="013556871081535795816:kktl2_rs2y0">
    <input type="hidden" name="ie" value="UTF-8">
    <input type="text" name="q" id="googlecse" style="background: url(&quot;https://www.google.com/cse/static/images/1x/en/branding.png&quot;) left 9px top 50% no-repeat rgb(255, 255, 255);" placeholder="">
    <input style="font-size:12pt;margin-top:10px;" type="submit" name="sa" value="Search">
  </div>
  <input name="siteurl" value="get-digital-help.com/" type="hidden"><input name="ref" value="" type="hidden"><input name="ss" value="" type="hidden"><input name="siteurl" value="get-digital-help.com/" type="hidden"><input name="ref" value=""
    type="hidden"><input name="ss" value="" type="hidden">
</form>

Text Content

Get
Digital
Help

More

 * Home
 * Functions
 * Formulas
 * Features
   Excel Basics Excel Defined Table Advanced Filter Data Validation Drop-down
   lists Named Ranges Solver
 * Charts
 * Conditional formatting
 * Pivot table
 * VBA
   VBA Functions Methods Properties Statements Macros User defined functions
   Files & folders Checkboxes
 * Archive
   All articles sorted by date Categories Products Advanced Excel Course
 * Contact
   About me Blogs I read







CHECK OUT THE NEW FORMULA PAGE


LATEST MODIFIED BLOG ARTICLES

Unique distinct records sorted based on count or frequency

Sara asks: How can you use large with multiple criteria?? Example looking for
top 5 of a list based on […]




Partial match for multiple strings – AND logic

This article demonstrates formulas that let you perform partial matches based on
multiple strings and return those strings if all […]



Find earliest and latest overlapping dates in a set of date ranges based on a
condition

This article explains how to create a formula that returns the earliest
(smallest) and the latest (largest) date of overlapping […]



Find empty dates in a set of date ranges

The formula in cell B8, shown above, extracts dates not included in the
specified date ranges, in other words, dates […]




How to sum overlapping time

The worksheet above shows four different time ranges in column B and C, the
formula in cell C10 counts the […]



Partial match based on two conditions

Question: I want to search two columns with two search strings? The strings can
be anywhere in these two columns […]



Perform multiple partial matches and return records – AND logic

Question: Can expand this equation set into more than two colums of data, say if
I had a first, middle […]




Partial match and return multiple adjacent values

This article demonstrates array formulas that search for cell values containing
a search string and returns corresponding values on the […]



Partial match values and return value with highest level

This article demonstrates a formula that searches a cell (partial match) based
on values in a table and returns a […]



How to use the MAX function

The MAX function calculates the largest number in a cell range. The formula in
cell D3 extracts the highest number […]




INDEX MATCH with multiple criteria

This article demonstrates formulas that let you perform lookups using two or
more conditions. The image above shows two conditions […]



Get the smallest number larger than a given number

This article demonstrates how to extract the smallest number larger than a
condition and the largest number smaller than a […]



Match a range value containing both text and numerical characters

This article demonstrates how to match a value containing both text and digits
to ranges. The search value is specified […]



How to quickly find the maximum or minimum value [Formula]

This article demonstrates formulas that will return the largest and smallest
numbers, the corresponding column headers, the cell addresses, and […]



SUMPRODUCT – multiple criteria

This article demonstrates ways to sum values based on critera. Table of Contents
SUMPRODUCT - based on a list of […]



How to use the SUMPRODUCT function

The SUMPRODUCT function calculates the product of corresponding values and then
returns the sum of each multiplication.



Match two columns

This article demonstrates formulas that match two conditions in a column each
and return another value on the same row […]



INDEX MATCH – Case sensitive

The picture above demonstrates a formula in cell F3 that allows you to look up a
value in column B […]



How to use the MODE function

The MODE function calculates the most frequent number in a cell range. Number 4
exists 3 times on picture above […]



Sort text cells alphabetically from two columns

Table of Contents Sort text from two columns combined (array formula) How to
create an array formula How to copy […]



Sort column based on frequency

This article demonstrates a formula that sorts cell values by their frequency,
in other words, how many times a value […]



Excel formula not working

This article explains why your formula is not working properly, there are
usually four different things that can go wrong. […]



INDEX MATCH – multiple results

This article demonstrates how to use INDEX and MATCH functions to lookup and
return multiple results. The lookup value is […]



AVERAGE based on criteria

Table of Contents AVERAGE based on criteria AVERAGE - AND OR logic Get Excel
*.xlsx file 1. AVERAGE based on […]



Compare two columns and highlight differences

This article demonstrates a conditional formatting formula that will highlight
the differences between two columns. The image above shows two […]



If cell equals value from list

This article demonstrates formulas that check if a cell value is equal to any
value in a given list. Table […]



How to use the COUNTIF function

Counts the number of cells that meet a specific condition.



How to use the EXACT function

The EXACT function allows you to check if two values are precisely the same, it
returns TRUE or FALSE. The […]



How to use the MATCH function

Identify the position of a value in an array.



How to use the STOCKHISTORY function

The STOCKHISTORY function lets you get stock prices based on a stock quote. It
is in the Lookup and reference […]



List permutations no repetition [UDF]

This blog post describes how to create permutations, repetition is NOT allowed.
Permutations are items arranged in a given order meaning […]



How to use the SUBTOTAL function

The picture above shows row 4 and row 8 hidden, the SUM argument 9 sums all
values in C3:C11 whereas […]



How to use the SEQUENCE function

The SEQUENCE function creates a list of sequential numbers to a cell range or
array. It is located in the […]



How to use the FILTER function

The FILTER function lets you extract values/rows based on a condition or
criteria. It is in the Lookup and reference category […]



IF with OR function

This article shows examples of how to use the IF function with the OR function.
Table of Contents IF with […]



Partial match with two conditions and return multiple results

This article demonstrates a formula that extracts a row or record from a data
table using two strings as criteria. […]



Sum numbers between two dates

The formula in cell C15 uses two dates two to filter and then sum values in
column C, the SUMIFS […]



How to use the OR function

The OR function allows you to carry out a logical test in each argument and if
at least one argument returns […]



If cell contains text

This article demonstrates different formulas based on if a cell contains a given
text. Formula in cell C3: =B3=$E$3 The […]



How to use the AND function

The image above demonstrates the AND function with two logical expressions. If
the value in column B is equal to […]



IF function with AND function – multiple conditions

The AND function allows you to have multiple conditions in an IF function, you
can have up to 254 arguments. […]



How to use the YEAR function

The YEAR function converts a date to a number representing the year in the date.
The number is between 1900 […]



How to use the DATE function

The DATE function returns a number that acts as a date in the Excel environment.
The image above shows you […]



How to simplify nested IF functions

Nested IF statements in a formula are multiple combined IF functions so more
conditions and outcomes become possible. They all are […]



How to use the HYPERLINK function

The HYPERLINK function allows you to build a link in a cell pointing to
something else like a file, workbook, […]



Create links to all sheets in a workbook programmatically

The macro demonstrated above creates hyperlinks to all worksheets in the current
worksheet.  You will then be able to quickly […]



How to use the TEXT function

This article demonstrates how to use the TEXT function in great detail. The
formula in cell D3 formats the number […]



Create new worksheets programmatically based on values in a cell range [VBA]

This article demonstrates a macro that inserts new worksheets based on names in
a cell range. The cell range may […]



5 easy ways to extract Unique Distinct Values

First, let me explain the difference between unique values and unique distinct
values, it is important you know the difference […]



Match two criteria and return multiple records

This article demonstrates how to extract records/rows based on two conditions
applied to two different columns, you can easily extend […]



How to use the INDEX function

Gets a value in a specific cell range based on a row and column number.



Use IF + COUNTIF to evaluate multiple conditions

The image above demonstrates a formula that matches a value to multiple
conditions, if the condition is met the formula […]



Extract a unique distinct list and ignore blanks

This article demonstrates formulas that extract unique distinct values and
ignore blank empty cells. Table of contents Extract a unique […]



How to use the FREQUENCY function

Returns how many times values exist in a given range. Note, this function
returns an array of values.



If cell contains text from list

This article demonstrates several ways to check if a cell contains any value
based on a list. The first example […]



Search for a text string in a data set and return multiple records

This article explains different techniques that filter rows/records that contain
a given text string in any of the cell values […]



Formula for matching a date within a date range

This article demonstrates how to match a specified date to date ranges. The
image above shows a formula in cell […]



Extract all rows from a range that meet criteria in one column

Lookup with criteria and return records.



How to use the SUMIF function

The SUMIF function sums values based on a condition. The condition can be
applied to the values being summed or […]



Find latest date based on a condition

This article demonstrates how to return the latest date based on a condition
using formulas or a Pivot Table. The […]



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 […]



Distribute values across numerical ranges

This article demonstrates how to distribute values into specific ranges with
possible overlapping ranges. I have written articles about filter […]



Lookup and return multiple values concatenated into one cell

This article demonstrates how to find a value in a column and concatenate
corresponding values on the same row. The […]



How to create running totals

This article demonstrates a formula that calculates a running total. A running
total is a sum that adds new numbers […]



How to use the COUNTIF function to count not blank cells

The COUNTIF function is very capable of counting non-empty values, I will show
you how in this article. Excel can […]



Find empty cells and sum cells above

This article demonstrates how to find empty cells and populate them
automatically with a formula that adds numbers above and […]



Rearrange values using formulas

The picture above shows data presented in only one column (column B), this
happens sometimes when you get an undesired […]



Opening a workbook runs a macro automatically

This article explains how to set up a workbook so a macro is run every time you
open the workbook. […]



Run a Macro from a Drop Down list [VBA]

This article demonstrates how to run a VBA macro using a Drop Down list. The
Drop Down list contains two […]



How to use the XMATCH function

This article demonstrates the XMATCH function introduced in Excel 365. The
XMATCH function is an enhanced version of the MATCH […]



How to use the LET function

This article demonstrates the LET function introduced in Excel 365. What's on
this page How to use the LET function […]



How to extract a case sensitive unique list from a column

This article demonstrates a formula that extracts unique values from a column
also considering upper and lower characters (case sensitive). […]



Sort and return unique distinct single digits from cell range

This article demonstrates a formula that filters unique distinct single digits
from a cell range containing numbers. Cell range B3:B6 […]



Count unique distinct values based on a condition

This article demonstrates how to construct a formula that counts unique distinct
values based on a condition. The image above […]



Lookup based on a date range and a condition return multiple values

This article demonstrates a formula that extracts values from a column based on
a date range criteria and another condition. […]



Extract a list of alphabetically sorted duplicates based on a condition

The following image shows you a data set in columns B and C. The formula in cell
E2 extracts a […]



How to use the SEARCH function

Returns a number representing the position a substring is, if found in a
textstring. FIND is case sensitive and SEARCH is not.



Filter duplicate values using criteria

This article demonstrates formulas that extract duplicates based on three
conditions. Table of Contents Filter duplicate values using criteria How […]



Extract duplicate values with exceptions

This article demonstrates formulas that extract duplicate values from a column,
however, column D contains values that you don't want […]



Concatenate cell values based on a condition [No VBA]

Add cell values to a single cell with a condition, no VBA in this article.



Find last value in a column

This article demonstrates formulas that return the last value in a given cell
range or column. The image above shows […]



Unique distinct list sorted alphabetically based on a condition

This article demonstrates how to extract unique distinct values based on a
condition and also sorted from A to z. […]



Lookup and match last value – reverse lookup

This article shows a formula that performs a reverse lookup and returns the
corresponding value based on the last matching […]



How to use the XLOOKUP function

This article demonstrates how to use the XLOOKUP function in Excel 365. Table of
Contents XLOOKUP function - Overview Function […]



Use VLOOKUP and return multiple values sorted from A to Z

This article demonstrates how to extract multiple values based on a search value
and display them sorted from A to […]



Concatenate unique distinct values

This article demonstrates Excel formulas that extract unique distinct values
from a cell range and concatenates the values using any […]



How to use the TEXTJOIN function

The TEXTJOIN function is a relatively new function introduced in Excel 2019, it
is like the CONCATENATE function on steroids […]



How to use the HLOOKUP function

This article demonstrates how to use the HLOOKUP function in Excel. Use the new
XLOOKUP function which is an improved […]



How to use the VLOOKUP function

The VLOOKUP function lets you search the leftmost column for a value and return
another value on the same row […]



Highlight cells based on ranges

This article demonstrates a Conditional Formatting formula that lets you
highlight cells based on numerical ranges specified in an Excel […]



Rearrange values in a cell range to a single column

This article demonstrates formulas that rearrange values in a cell range to a
single column. Table of Contents Rearrange cells […]



How to use the SORT function

The SORT function lets you sort values from a cell range or array. It returns an
array with a size […]



Use VLOOKUP to calculate discounts, commissions, tariffs, charges, shipping
costs, packaging expenses or bonuses

Have you ever tried to build a formula to calculate discounts based on price?
The VLOOKUP function is much easier […]



Count matching strings using regular expressions

This article demonstrates a User Defined Function (UDF) that counts how many
times a string exists in a cell value […]



Reverse two-way lookups

This article demonstrates a few different formulas that extract values from the
table column header names and the right-most column. […]



How to create a map chart

Excel 2016 owners with an office 365 subscription can now easily build beautiful
map charts. Excel uses maps from Bing […]



Split search value using delimiter and search for each substring

This article demonstrates formulas and a UDF that searches for values in a table
based on concatenated values and returns […]



How to use the FILTERXML function

The FILTERXML function extracts specific values from XML content by using the
given xpath. The function was introduced in 2013 […]



Sort values in a cell based on a delimiting character

This article demonstrates a macro and a formula that allows you to sort
delimited data in a cell or cell […]



Fetching values from ThingSpeak programmatically

  Picture above shows cheap chinese IoT modules: a temp sensor and an esp8266-01
(25 mm x 15 mm) Thingspeak […]



Formula categories

Count
Dates
Extract
Index and Match
Logic
Lookups
String manipulation
Sum
Time
Vlookup

Search website








Privacy Policy



Update Privacy Preferences
An Elite CafeMedia Tech Publisher