<H1> Excel For You </H1> |
<H1>
LAMBDA EXCEL: Letter Grade
</H1> |
<H1>
LAMBDA EXCEL: Bible Verse
</H1> |
<H1>
LAMBDA Excel: BINGO
</H1> |
<H1>
LAMBDA Excel: Molecular Weight
</H1> |
<H1>
Excel #8 – Making a Bingo Card Using Only Formulas with Dynamic Array Functions
</H1> |
<H1>
New Excel #7 – Creating an Unique List from a 3D Range Using Dynamic Arrays
</H1> |
<H1>
New Excel #6 – Returning a Table of First Occurrences from Master Table Using Dynamic Arrays
</H1> |
<H1>
New Excel #5 – Returning a Range of Last N Values in a Filtered List Using Dynamic Arrays
</H1> |
<H1>
New Excel #4 -Determining if a String is an Isogram Using Dynamic Arrays
</H1> |
<H1>
New Excel #3 – Creating a Sorted Unique List from a Filtered Range Using Dynamic Arrays
</H1> |
<H1>
New Excel #2 – Comparing String to Determine if They Are Anagrams Using Dynamic Arrays
</H1> |
<H1>
New Excel #1 – Shuffling a String Using the new Dynamic Array Formulas
</H1> |
<H1>
xlCubeSuper7: An Unexpected Major Update – New Download – UDF Power
</H1> |
<H1>
Adding Data Validation to ANY Cell Using an Excel User-Defined Function
</H1> |
<H1>
Excel Filter and Sort UDFs – Amazing!
</H1> |
<H1>
#Excel: Generate a List of Antonyms Using an User-Defined Function (UDF)
</H1> |
<H1>
xlCubeSuper An Excel Game Explained – Part6
</H1> |
<H1>
xlCubeSuper An Excel Game Explained – Part5
</H1> |
<H1>
xlCubeSuper An Excel Game Explained – Part4
</H1> |
<H1>
xlCubeSuper An Excel Game Explained – Part3
</H1> |
<H1>
xlCubeSuper An Excel Game Explained – Part2
</H1> |
<H1>
xlCubeSuper An Excel Game Explained – Part1
</H1> |
<H1>
#Excel Data Validation – Non-Contiguous Ranges and Changing Data Validation List after Picking
</H1> |
<H1>
#Excel: Extracting an Array of Words From a Sentence
</H1> |
<H1>
#Excel: Remove Multiple Characters From a String Using The TEXTJOIN Function and Without Using the SUBSTITUTE or REPLACE Function
</H1> |
<H1>
#Excel: Most Frequent Item in a List of Delimited Strings
</H1> |
<H1>
Insert a Line-Feed Between Every 3rd Character Using an Excel Worksheet Formula
</H1> |
<H1>
Boolean Formula for Repetitive Characters in a String
</H1> |
<H1>
#Excel Short and Sweet Tip #29: Inserting Icons Using a User-Defined Function
</H1> |
<H1>
Generating a “Realtime” Voice Alert for the Latest Magnitude 5 or Greater Earthquake
</H1> |
<H1>
Get Latest Storm Information in #Excel Using Only An Address and Storm name
</H1> |
<H1>
Excel Super Links 1-150
</H1> |
<H1>
Highlighting Actual Words in an #Excel List Using the Hyperlink Rollover Method
</H1> |
<H1>
Using #Excel to Find How Far the Event is from Your Location
</H1> |
<H1>
#Excel Advanced Filter: Selectively Show Control Chart Data by Standard Deviation
</H1> |
<H1>
Adding Multiple DAX Measures to Non-PowerPivot Versions of #Excel using an User-Defined VBA Function
</H1> |
<H1>
#Excel Impossibly Easy #2: Change Sheet Tab Color with a User-Defined Worksheet Formula
</H1> |
<H1>
Returning a List of Formulas Based on a Specific #Excel Function by David Hager
</H1> |
<H1>
#Excel Impossibly Easy #1: Return a 1D Array from Non-Contiguous Native 3D Ranges
</H1> |
<H1>
Documenting Formulas in an #Excel Range Using the FORMULATEXT, ISFORMULA and TEXTJOIN Functions by David Hager
</H1> |
<H1>
Extracting Ingredients from an #Excel List by Cost Category by David Hager
</H1> |
<H1>
#Excel Short and Sweet Tip #28: Jazzing Up a Star Rating by Using the TEXTJOIN by David Hager
</H1> |
<H1>
Creating a Priority List With #Excel by David Hager
</H1> |
<H1>
List of Priority Items from Another List Using #Excel TEXTJOIN Function by David Hager
</H1> |
<H1>
Creating a Set of Custom Instructions Using the #Excel TEXTJOIN Function by David Hager
</H1> |
<H1>
Run Your Power Query M Code Procedures in #Excel Worksheet Cells by David Hager
</H1> |
<H1>
Storing and Running Power Query M Code from #Excel Worksheet Cells by David Hager
</H1> |
<H1>
Bible Verse In Any Language Using #Excel by David Hager
</H1> |
<H1>
#Excel Short and Sweet Tip #26 (Showing an UserForm With a Worksheet UDF) by David Hager
</H1> |
<H1>
#Excel: Getting the Sunrise and Sunset Times From an Address by David Hager
</H1> |
<H1>
Getting the Latest Earthquake Alert Using the WEBSERVICE and FILTERXML Functions in #Excel by David Hager
</H1> |
<H1>
#Excel Short and Sweet Tip #25 (Random Sound – Worksheet UDF) by David Hager
</H1> |
<H1>
Conditional Formatting Gem in #Excel: Highlight the N Closest Values to the Mean of a Range in a Filtered List by David Hager
</H1> |
<H1>
Using Conditional Formatting in #Excel to Highlight the N Closest Values to the Mean of a Range by David Hager
</H1> |
<H1>
Lookup a Bible Verse Using #Excel (w/o VBA) by David Hager
</H1> |
<H1>
Automating Word and PowerPoint from #Excel with a Worksheet UDF by David Hager
</H1> |
<H1>
Enable #Excel Formulas to Give an Audio Result by David Hager
</H1> |
<H1>
Excel: Conditional Format Rows in List 1 that are Not in List 2 by David Hager
</H1> |
<H1>
Excel: Conditional Format Rows in One List that are in Another List by David Hager
</H1> |
<H1>
Great #Excel Technique: August 2017 Total Eclipse Info by David Hager
</H1> |
<H1>
Creating Dependent Lists from a Column Lookup in an #Excel List by David Hager
</H1> |
<H1>
#Excel Super Links #75 – shared by David Hager
</H1> |
<H1>
#Excel Sparklines: Display Last N Values by David Hager
</H1> |
<H1>
#Excel Short and Sweet Tip #23 (Open Windows File Explorer with Worksheet UDF) by David Hager
</H1> |
<H1>
Advanced Filter Magic by David Hager
</H1> |
<H1>
#Excel: Exciting New Features – Using a Worksheet UDF to Modify Shapes on a Worksheet by David Hager
</H1> |
<H1>
#Excel Short and Sweet Tip #22 (Move VBA Module Copy to Another Workbook) by David Hager
</H1> |
<H1>
#Excel Exchange Rate UDF With Symbol Lookup by David Hager
</H1> |
<H1>
#Excel Short and Sweet Tip #21 (Remove Unused Custom Formats) by David Hager
</H1> |
<H1>
#Excel Short and Sweet Tip #20 (Create VBA Procedure List) by David Hager
</H1> |
<H1>
Using Excel UDF to Translate a Phrase From One Language to Another by David Hager
</H1> |
<H1>
Using #Excel to Make A Round Robin Tournament Schedule by David Hager
</H1> |
<H1>
Revisiting Using the Excel TEXTJOIN Function To Return Unique Items From A 3D Range by David Hager
</H1> |
<H1>
Excel: Using Power Query to Return All Words From a List of Letters Including Wildcards by David Hager
</H1> |
<H1>
#Excel Short and Sweet Tip #19 (Invaluable Excel Speller) by David Hager
</H1> |
<H1>
#Excel Short and Sweet Tip #18 (Toggle Formatting on Worksheet) by David Hager
</H1> |
<H1>
#Excel Short and Sweet Tip #17 (Returning a Letter Grade Based on a Normal Grading Scale Without Lookup Table) by David Hager
</H1> |
<H1>
#Excel: Project Tracking Workbook by David Hager
</H1> |
<H1>
#Excel Short & Sweet Tip #16 (Multiple Delimiters with TEXTJOIN for Custom Formatting) by David Hager
</H1> |
<H1>
#Excel Native 3D Ranges with the TEXTJOIN Function Plus Bonus by David Hager
</H1> |
<H1>
#Excel UDF Using Google API to Return the Elevation of an Address by David Hager
</H1> |
<H1>
#Excel: Creating a List of Option Expiration Dates and Triple Witching Dates with Excel Formulas by David Hager
</H1> |
<H1>
#Excel Short and Sweet Tip #15 (Using TEXTJOIN With Non-Contiguous Ranges) by David Hager
</H1> |
<H1>
Copy #Excel Chart as a Enhanced metafile Picture by David Hager
</H1> |
<H1>
Generating Random Initials with DAX in Power BI by David Hager
</H1> |
<H1>
#Excel Short and Sweet Tip #14 (Generating Random Initials) by David Hager
</H1> |
<H1>
#Excel: Removing Outliers with Excel Formulas to Modify Control Limits by David Hager
</H1> |
<H1>
#Excel For You Blog Posts Containing Downloadable Workbook Files by David Hager
</H1> |
<H1>
#Excel Short and Sweep Tip #13 (KeyBoard DFAROT Unique Technique) by David Hager
</H1> |
<H1>
#Excel: Origin of Sparklines – LineChart VBA User-Defined Function by David Hager
</H1> |
<H1>
#Excel: Finding and Visualizing the Last Record in a Table Based on Criteria by David Hager
</H1> |
<H1>
#Excel Short and Sweet Tip #12 (Documenting Formulas and Highlighting Those Formulas With Conditional Formatting) by David Hager
</H1> |
<H1>
#Excel: Creating a Environmental Variables Table with the VBA ENVIRON Function UDF by David Hager
</H1> |
<H1>
#Excel: Building a Frequency Summary Table Based on an Excel List by David Hager
</H1> |
<H1>
#Excel Short and Sweep Tip #11 (Most Frequent Item in Column) by David Hager
</H1> |
<H1>
#Excel: A Model Using the CONVERT Function Containing Categories by David Hager
</H1> |
<H1>
#Excel Magic Consolidator by David Hager
</H1> |
<H1>
#Excel Short and Sweep Tip #10 (Add Custom AutoCorrect with UDF) by David Hager
</H1> |
<H1>
#Excel: Using Conditional Formatting to Highlight Cells That Contain Array Formulas Using the FORMULATEXT Function by David Hager
</H1> |
<H1>
Excel Short & Sweet Tip #9 (Get IP Address) by David Hager
</H1> |
<H1>
#Excel: Generating a Random Sampling From a List Using VBA and the TEXTJOIN Function by David Hager
</H1> |
<H1>
Excel Short & Sweet Tip #8 (VBA Function to Return Zodiac Sign) by David Hager
</H1> |
<H1>
#Excel Worksheet UDF that Adds a Comment to Any Cell by David Hager
</H1> |
<H1>
Excel Short & Sweet Tip #7(Highlighting External Links) by David Hager
</H1> |
<H1>
#Excel: Using Conditional Formatting to Highlight 3D Formulas with Defined names by David Hager
</H1> |
<H1>
Excel Short & Sweet Tip #6 (Shuffling a String) by David Hager
</H1> |
<H1>
#Excel: Using Conditional Formatting to Highlight Cells Containing Native 3D Formulas by David Hager
</H1> |
<H1>
Excel Short & Sweet Tip #5 (Hiding Error Triangles) by David Hager
</H1> |
<H1>
Excel Short & Sweet Tip #4 (Hide Defined names)
</H1> |
<H1>
#Excel Short and Sweep Tip #3 (Freeze Values) by David Hager
</H1> |
<H1>
#Excel: Modifying Shapes From An UDF in a Worksheet Cell by David Hager
</H1> |
<H1>
#Excel Short & Sweet Tip (Find Formulas)#2
</H1> |
<H1>
Excel Short and Sweet Tip #1 (Alphabetic String With TEXTJOIN) by David Hager
</H1> |
<H1>
#Excel: Four Super Filter Techniques by David Hager
</H1> |
<H1>
#Excel: Using Advanced Filter with a Custom List By David Hager
</H1> |
<H1>
#Excel VBA: Create a Table of File Locations and URLs for Your Favorites by David Hager
</H1> |
<H1>
#Excel Identifying if a String is the Anagram of Another String Using the TEXTJOIN Function by David Hager
</H1> |
<H1>
Mine3D for #Excel: An Excel-based Game by David Hager
</H1> |
<H1>
Using the SUBTOTAL Function in #Excel To Aggregate Values From Multiple Filtered Lists by David Hager
</H1> |
<H1>
Using #Excel VBA to Create a Filter Criteria User Defined Function by David Hager
</H1> |
<H1>
TEXTJOIN: Multiple Lookup Values in a Single Cell (With/Without Duplicates) Using Only #Excel Formulas by David Hager
</H1> |
<H1>
Using TEXTJOIN: Generating a Sorted Unique Array in #Excel using Only Formulas by David Hager
</H1> |
<H1>
#Excel: Creating A List Made Up Of Formulas From A Filtered List by David Hager
</H1> |
<H1>
#Excel Filtered List Using a Calculated Column to Count Occurrence Number by David Hager
</H1> |
<H1>
#Excel For You Blog Posts Having Downloadable Workbook Files by David Hager
</H1> |
<H1>
Using the #Excel Advanced Filter to a List Having Internal Numbers in a String By David Hager
</H1> |
<H1>
Using Conditional Formatting to Highlight Unique Items in an Excel Filtered List By David Hager
</H1> |
<H1>
Chapter on Conditional Formatting in Excel by David Hager (a Blast from the Past)
</H1> |
<H1>
My Collection of Excel Tips by David Hager
</H1> |
<H1>
Using the CHOOSE and AGGREGATE Functions To Apply Conditional Formatting to a Filtered List in Excel By David Hager
</H1> |
<H1>
Calculating Aggregation for Internal Numbers From Strings in a Range by David Hager
</H1> |
<H1>
Using the Excel TEXTJOIN function to Extract an Internal Numeric String From a String by David Hager
</H1> |
<H1>
Averaging of Scientific Results in Excel
</H1> |
<H1>
Charting Data With Formula Links In Excel By David Hager
</H1> |
<H1>
Creating a Unique Delimited String from an Excel Filtered List by Using the TEXTJOIN Function By David Hager
</H1> |
<H1>
Archive of Excel Experts E-Letter (by David Hager)
</H1> |
<H1>
Creating an Excel Table of Components By Product From a List Using the TEXTJOIN Function By David Hager
</H1> |
<H1>
Creating A Unique Delimited String From a Delimited String – Excel Formula Method With TEXTJOIN( David Hager)
</H1> |
<H1>
Using the Excel TEXTJOIN Function To Return Unique Items In A One-Cell Delimited String From A 2D and 3D Range By David Hager
</H1> |
<H1>
xlCube: An Excel game
</H1> |
<H1>
Power BI Help for Excel
</H1> |
<H1>
Measuring Distance in Power BI Desktop
</H1> |
<H1>
The DAX ENDSWITHX Function Equivalent
</H1> |
<H1>
BINGO! An #Excel Game by David Hager
</H1> |
<H1>
And the Best Excel site is…..!
</H1> |
<H1>
Go To Special for Browser Copy/Paste to Excel
</H1> |
<H1>
Calculating the Nth Best Performance (unique individuals) with Excel and PowerPivot
</H1> |
<H1>
Using Excel 3D Formulas on Filtered Lists
</H1> |
<H1>
EXCEL 3D – Easy as 1-2-3 and A-B-C and Others
</H1> |
<H1>
Returning the First Temperature in PowerPivot
</H1> |
<H2> For the Excel community – by David Hager </H2> |
<H2> </H2> |
<H2> </H2> |
<H3> Post navigation </H3> |
<H3> Recent Posts </H3> |
<H3> Recent Comments </H3> |
<H3> Archives </H3> |
<H3> Categories </H3> |
<H3> meta </H3> |
<H3> </H3> |
<H4> August 31, 2015 </H4> |
Social
Social Data
Cost and overhead previously rendered this semi-public form of communication unfeasible.
But advances in social networking technology from 2004-2010 has made broader concepts of sharing possible.