Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • How To Create Frequency Distribution in Excel
  • Create Scatter Chart in Excel
  • How To Filter Data in Excel
  • How to do a t-Test in Excel?
  • Example of COUNTIFS with variable table column in Excel

References

  • How to retrieve first match between two ranges in Excel
  • Last row number in range
  • MATCH function: Description, Usage, Syntax, Examples and Explanation
  • Two-way lookup with VLOOKUP in Excel
  • How to use Excel ROW Function

Data Validations

  • Excel Data validation date in next 30 days
  • Excel Data validation only dates between
  • Excel Data validation allow weekday only
  • How To Create Drop-down List in Excel
  • Data validation must not exist in list

Flash Fill in Excel

by

Use flash fill in Excel 2013 or later to automatically extract or combine data.

Join

1. For example, use flash fill to join the last names in column A and the first names in column B to create email addresses.

2. First, tell Excel what you want to do by entering a correct email address in cell C1.

Worked Example:   How to return TRUE when all cells in range are blank in Excel

3. On the Data tab, in the Data Tools group, click Flash Fill.

Result:

Note: again, Excel does not insert formulas, if you change the text strings in column A or column B, Excel will not update the email addresses in column C.

Worked Example:   Circular Reference Problem Solved

Extract

1. For example, use flash fill to extract the numbers in column A below.

2. First, tell Excel what you want to do by entering the value 4645 into cell B1.

Worked Example:   How to get address of named range in Excel

3. On the Data tab, in the Data Tools group, click Flash Fill.

Result:

Note: Excel does not insert formulas, if you change the text strings in column A, Excel will not update the numbers in Column B.

Post navigation

Previous Post:

PI function: Description, Usage, Syntax, Examples and Explanation

Next Post:

Offset in Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • OR function Examples in Excel
  • IFNA function: Description, Usage, Syntax, Examples and Explanation
  • SWITCH function: Description, Usage, Syntax, Examples and Explanation
  • IF, AND, OR and NOT Functions Examples in Excel
  • Excel If, Nested If, And/Or Criteria Examples

Date Time

  • How to calculate quarter from date in Excel
  • DAYS360 function: Description, Usage, Syntax, Examples and Explanation
  • WEEKDAY function: Description, Usage, Syntax, Examples and Explanation
  • How to get year from date in Excel
  • Steps to create Dynamic calendar grid in Excel

Grouping

  • Map text to numbers in Excel
  • Group times into 3 hour buckets in Excel
  • Running count group by n size in Excel
  • Group times into unequal buckets in Excel
  • Map inputs to arbitrary values in Excel

General

  • How to Insert Cells, Row and Rows in Excel
  • Sum by group in Excel
  • How to Create Calendar in Excel
  • How to calculate percentage discount in Excel
  • Print Excel Sheet In Landscape Or Portrait
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning