Al Taylor, Author at mapflo

Using INDEX and MATCH to lookup a value in a table
Using INDEX and MATCH to lookup a value in a table

INDEX and MATCH are slightly trickier than VLOOKUP but reduce errors as they match to a specific value rather than count columns.

Read article
Regex in Excel and Google Sheets
Regex in Excel and Google Sheets

Surprisingly, Excel does not support Regular Expression (regex or regexp). Google Sheets has three functions that use Regex. Mapflo has regex natively built in - it's a great tool for data analysis and automating manual processes.

Read article
Search and Find functions
Search and Find functions

Search and Find functions in Excel and Google Sheets, includes examples.

Read article
Calculate the time difference between two dates in Excel and Google Sheets
Calculate the time difference between two dates in Excel and Google Sheets

Calculate the time difference between two dates in Excel and Google Sheets

Read article
XLOOKUP in Excel and Google Sheets
XLOOKUP in Excel and Google Sheets

XLOOKUP in Excel and Google Sheets. Can be used to join datasets together.

Read article
VLOOKUP in Excel and Google Sheets
VLOOKUP in Excel and Google Sheets

VLOOKUP in Excel and Google Sheets. Can be used to join datasets together.

Read article
Count unique values
Count unique values

Learn how to use COUNTIF in excel. includes examples for handling different data types.

Read article
COUNTIFS
COUNTIFS

Learn how to use COUNTIFS in excel. includes examples for handling different data types.

Read article
SUMIFS
SUMIFS

Learn how to use SUMIFS in excel. includes examples for handling different data types.

Read article
FREE for your first 3 flows. Plans start from $15/month
Launching soon