Welcome To The Full Collection Of Formula Friday Excel Tips.

My Formula Friday Excel Tips blog post series has been running for 6+ years now, beginning in April 2015.

You can find ALL of the links to the blog post series right here on this page as well as the example workbook where all the examples are available to download for free.

Use the #FormulaFriday to follow me on Twitter or you can find me on Facebook.

You may also want to check out my recommended online Excel courses,  You can check them out at the bottom of the page or you can jump straight to the link right here.

Keep Excelling (and coding!)

Barbara

Download #FormulaFriday Example Files.

[wpdm_package id=’10703′]

• Excel Rank Function – Who is The Leader Of The Pack?
• Why Is My Formula Not Auto- Completing When I Type The Equals =Sign
• Using The PROPER Excel Formula
• Formula Friday -Delete Values From Cells While Keeping Formulas
• The Unique Function In Excel.
• Setting A Future Deadline In Workdays. Formula Friday.
• Calculate The Number Of Days Between Two Dates In Excel- Extract Next Day Deliveries
• Insert The Current Filename And Path In A Cell Using the CELL Formula
• Display Slicer Selections In An Excel Report Title.
• Calculate All Combinations Using The COMBIN Function.
• Find Missing Values In Excel. Formula Friday
• Highlight Expired Dates In Your Excel Data Set.
• SUM Only NEGATIVE Numbers In An Excel Range Using The SUMIF Function.
• Add Decimal Places To An Existing Data Set – No Formulas Needed.
• Sort Your Data In Random Order – Using The RAND Function.
• Find The Missing Numbers In A Sequence. Formula Friday
• Using SUM Function Only When Cells Are Ticked
• Highlight Every 5th Row In Your Excel Data Set.
• Pivot Table Tip: Calculate Percentage Between Two Fields.
• Use VLOOKUP With a Wildcard
• How To Convert Formulas To Values- Top 4 Methods
• Generate Unique ID Numbers From Your Excel Data Set
• Add 5% to my Sales Targets Without Using Extra Columns Or Cells
• Use The EXACT Function To Force Upper Case Data Entry Into Excel
• Prevent Duplicate Data Entries With COUNTIF Formula And Data Validation
• Setting Excel To Calculate Formulas Manually
• FLOOR Function In Excel- Find Out The Decade That Song Was From
• Formula Friday – When Your Formula Is Not Calculating As You Expected? Is Excel Wrong!?!? Displaying decimals versus Rounding in Excel
• Find The Maximum Value In Your Data Set WITHOUT a Formula
• Formula Friday – Calculate Only Some Of Your Workbook’s Formulas
• Formula Friday – Two Ways To Highlight Today’s Date In Your Excel Dataset
• Totals In Excel With No Formulas!
• Combine Conditional Formatting With An Excel Formula – Identifying Duplicate Values
• Conditional Formatting Excel Cell Text When A Formula Changes To A Typed Value- Formula Friday
• Formula Friday- Increase Or Decrease A Number By A Percentage In Excel
• Using TRIMMEAN IN Excel To Ignore Outliers – Formula Friday
• Identify New Customers With Conditional Formatting Using A Formula – Formula Friday
• How To Find The Minimum Number In A Excel Data Set – Two Formula Options – Formula Friday
• How To Create A Variable Drop Down List In Excel – Formula Friday
• Can’t Remember Where Your File Is Saved?. Cell Function To The Rescue
• Automatically Highlight The Column That Is Today – Formula Friday
• A Formula To Check If You Have Extra Spaces In Your Data – Formula Friday
• Sum Cumulatively Across Rows or Down Columns Of Data – Formula Friday
• 2 Ways To Create An Ongoing Count Of Sales Orders – Excel Formula Friday Double Edition
• Calculate How Long A Task Will Take Using CONVERT Function – Formula Friday
• Formula Friday – How To Count Formula Errors On An Excel Worksheet
• Pad Numbers With Zeros Using The LEFT Excel Function – Formula Friday
• Axis Label Hack For Your Excel Charts – Include The Data Label And The Value Using The CHAR() Function – Formula Friday
• Highlight Weekend Dates In Your Data Set. Conditional Formatting Using A Formula – Formula Friday
• How To Write An Excel VLOOKUP Formula With An IF Statement – Formula Friday
• Count How Often A Value Occurs In A Data Set – Using The COUNTIF Formula – Formula Friday
• Turn Off Rounding In Excel And Use The TRUNC Function – Formula Friday
• Why Is My Formula Not Auto- Completing When I Type The Equals =Sign – Formula Friday
• Back To Basics. Understanding Excel Formula Errors – Formula Friday
• Generate A List Of Files In A Folder – Without Macros or VBA Code – Formula Friday
• MS Excel Tutorial- How To Show Formulas In Excel With A User Defined Function – Formula Friday
• How To Concatenate Numbers And Percentages – Formula Friday
• Excel Tip – Insert The Contents Of A Cell Into A Text String – Formula Friday
• How To Calculate Only Some Of Your Workbook Formulas – Formula Friday
• Formula Friday – Know Your Dates!!. Calculate The Exact Dates Reports Are Due Using WORKDAYS and EOMONTH Function.
• Excel Tip – Learn How To Generate Random Dates With RANDBETWEEN and The DATE Functions – Formula Friday
• How To Create An In Cell Bar Chart Using The REPT Function In Excel -Formula Friday
• Easily Calculate How Long A Task Will Take Using The CONVERT Function – Formula Friday
• Calculate The Number Of Days Between Two Dates In Excel- Extract Next Day Deliveries – Formula Friday
• Conditional Formatting With A Formula -Format A Cell Based On The Letter It Contains – Formula Friday
• Relative and Absolute References In Excel – Formula Friday
• Formula Friday – How To Activate The Excel Formula Bar Directly From Your Keyboard To Quickly Edit Formulas.
• Formula Friday – Calculate Only Some Of Your Workbook’s Formulas
• Formula Friday – Quickly Switch From Cell Values To View Formulas – An Excel Shortcut
• Formula Friday – SUM Only NEGATIVE Numbers In An Excel Range Using The SUMIF Function.
• Formula Friday – Count How Many Numbers In A List Are Greater Than The Average Using The COUNTIF Function.
• Formula Friday – Did You Know Excel Knew Roman?. Convert Numbers To Roman Numerals In Excel
• Formula Friday – Do You Want A FAST and FUN Way To Learn Excel Formulas?
• Formula Friday – How To Highlight All Cells Containing A Formula In Excel
• Formula Friday – Using COUNTIF Function With Data Validation To Check For Repeating Values In Excel
• Formula Friday – How To Count Formula Errors On An Excel Worksheet
• Formula Friday – How To Resize The Excel Formula Bar
• Formula Friday – How To Delete Values From Cells But Keep Your Formulas In Excel
• Formula Friday – How To Use The DAY Function In Excel With
• Examples.Formula Friday – Which Range Does My Value Fit Into – A Perfect Job For The LOOKUP Function.
• Formula Friday – Use  Search Function To Create A Search Bar In An Excel Cell
• Formula Friday – Lets Take A Left…..Excel Function…..
• Formula Friday – Shhhhh…Want To Hide Your Excel Formulas?????….
• Formula Friday – Calculate How Many People Are Working At The Same Time using the COUNTIFS Function In Excel
• Formula Friday – Formula Friday – Use The SubTotal Function To Number Rows In An Excel Table
• Formula Friday – Full Marks! Calculating Weighted Exam Percentages…For The Final Grade
• Formula Friday – Find The Missing Values In My Columns Of Data
• Formula Friday – Calculate The First And Last Occurrence Of A Value
• Formula Friday – Quickly Convert Formulas To Cell Values In Excel.
• Formula Friday – Is That Odd?.Testing A Number With ISODD Function
• Formula Friday  – Calculating The Percentage Of A Target Yet To Be Achieved
• Formula Friday – 2 Ways To Create A Dynamic Named Range In Excel
• Formula Friday – Use A VLOOKUP Across Multiple Excel Worksheets
• Formula Friday – Insert The Current Filename And Path In A Cell Using the CELL Formula
• Formula Friday – Top 3 Reasons Not To Use Hard Coding In Excel Formulas
• Formula Friday – Calculate The Date Of The Nth Weekday Of The Month
• Formula Friday – Show A Zero Not Negative Number After Calculating Stock Items – Two Methods
• Formula Friday – How To Make An Exact Copy OF An Excel Formula
• Formula Friday – Find The Date Of The Fourth Business Day Of The Next Month.
• Formula Friday – Calculating Business Days Left In A Month From Today’s Date Using The NETWORKDAYS Function
• Formula Friday – How To Quickly Identify A Circular Reference In An Excel Sheet.
• Formula Friday – How To Calculate Age From A Date Of Birth In Excel
• Formula Friday – How To Use The COUNTIF Formula To Count How Many Times A Value Appears Across Multiple Worksheets
• Formula Friday – Applying Names To Your Existing Excel Formulas.
• Formula Friday – Easily Add Symbols To Your Excel To Do List Using The IF Function
• Formula Friday – 5 Ways To Double Check Your Excel Formulas.
• Formula Friday – Tidy Your Data Quickly With A Substitution
• Formula Friday – Highlight Overdue Tasks With Conditional Formatting And A Logical Formula
• Formula Friday – Easily SUM Values From Different Excel Sheets With The Same Cell Address
• Formula Friday – Write Formulas Faster With Auto Correct In Excel
• Formula Friday – Calculating The Percent Of Year Completed And Remaining Using The YEARFRAC Function.
• Formula Friday – Why is my formula showing in a cell and not the result??
• Formula Friday – How To Use RANK In Excel But Ignore Zeros
• Formula Friday – Add Leading Zeros To Numbers In Excel Using The TEXT Function
• Formula Friday – Randomly generate words in Excel with INDEX and RANDBETWEEN.
• Formula Friday – Sum Formula Not The Best Solution? Try Subtotal!
• Formula Friday – Generate Random Interview Name Lists No Repeats In Excel
• Formula Friday – 3 Ways To Protect Your Excel Formulas
• Formula Friday – How To Calculate The Percentage Of Cells In A Range That Contain A Specific String – Using COUNTIF and COUNTA
• Formula Friday – Find And Hide All Formulas On An Excel Worksheet
• Formula Friday – 2 Ways to Switch First And Last Names In Cells In Excel
• Formula Friday – Using Keyboard Shortcuts To See Precedent or Dependent Cells In Excel
• Formula Friday – Move Your Formula Quickly Around Your Excel Worksheet Without Changing Cell References
• Formula Friday – How To See Values And Formulas On The Same Spreadsheet At The Same Time
• Formula Friday – How To Easily View Your Formulas With FORMULATEXT Function In Excel
• Formula Friday – Whats The Difference Between An Excel Formula and A Excel Function?
• Formula Friday – Paste A Name Into An Excel Formula
• Formula Friday – View All Of Your Calculated Fields And Items Contained In Your Excel Pivot Table
• Formula Friday – 3 Ways To Remove Days From A Date In Excel To Leave Just The Month And Year
• Formula Friday – Use SUMIF To Calculate Total Sales Except One Item
• Formula Friday – Use The INDEX and MATCH Functions In Excel To Calculate Distances Between US National Parks.
• Formula Friday – Auto Sum Packs A Punch With This Cool Trick
• Formula Friday – Generate Random Odd Or Even Numbers With RANDBETWEEN
• Formula Friday – 3 Reasons To Use Named Ranges In Your Excel Formulas
• Formula Friday – Using The AND Function To Highlight Cells Meeting Multiple Logical Conditions
• Formula Friday – Searching Made Easy With SEARCH Function in Excel
• Formula Friday – Easily Calculate The Number Of Days Between Dates with the DAYS() Function
• Formula Friday – Excel Rank Function – Who is The Leader Of The Pack?
• Formula Friday – Splitting Text And Number In Excel
• Formula Friday – Need To Test Your Formulas? It’s Easy Just Hit F9!
• Formula Friday – Find The Highest or Lowest Value In A Row and Return the Column
• Formula Friday – 3D References To Summarise A Data Set
• Formula Friday – Convert All Of Your Text To Upper Case Using…You Guessed It The UPPER Function
• Formula Friday – Conditionally Format An Excel Chart With IF Function
• Formula Friday- Extract A Name From An Email Address
• Formula Friday – Highlight Expired Policy Numbers With Conditional Formatting In Excel.
• Formula Friday – Using TRIM for a speedy data clean up.
• Formula Friday – Easily Identify Cells That Begins With A Specified Letter in Excel
• Formula Friday – How To Count Cells That Contain Text Using COUNTIF
• Formula Friday – Create A Dynamic Report Header Using The Concatenate Function
• Formula Friday – Speed Up Your VLOOKUPS in Larger Data Sets
• Formula Friday – Copy Formula Down When Formula Is Not Directly Next To Your Data Set
• Formula Friday – Permanently Remove A Calculated Field From Your Pivot Table
• Formula Friday – Fast Formula Fill Using An Excel Table
• Formula Friday – Find And Hide All Formulas On An Excel Worksheet
• Formula Friday – Find The Date Of The Fourth Business Day Of The Next Month
• Formula Friday – Find The Highest or Lowest Value In A Row and Return the Column Heading
• Formula Friday – Find The Minimum Value In A Range But Ignoring 0 Values
• Formula Friday – Flag Multiple Matches In Your VLOOKUP Formula
• Formula Friday – Generate Random Interview Name Lists No Repeats In Excel
• Formula Friday – Generate Random Odd Or Even Numbers With RANDBETWEEN
• Formula Friday – Highlight Expired Policy Numbers With Conditional Formatting In Excel
• Formula Friday – Easily Spot Excel Formula Errors In A Large Excel Worksheet
• Formula Friday- Using The Convert Function To Calculate How Long My Task Will Take
• Formula Friday – How Excel Calculates – The Order Of Excel Calculations
• Formula Friday- Always Add The Last 3 Values In Your Data Set Using The Offset Function
• Formula Friday- Don’t Update My Calculations…..Just Yet. Using Manual Mode In Excel
• Formula Friday – Add Operator Symbols To The QAT
• Formula Friday- Counting Names In A Contiguous Data Range
• Formula Friday- Summing Only Positive Numbers In A Data Set
• Formula Friday- 3 Ways To Enter Excel Formulas
• Formula Friday – Use Concatenate Or & To Create Usernames In Excel
• Formula Friday – Flag Multiple Matches In Your VLOOKUP Formula
• Formula Friday- Generate Unique User Names In Excel Using The COUNTIF Function
• Formula Friday -Delete Values From Cells While Keeping Formulas
• Formula Friday- Use the Watch Window As A Floating Cell To See Your Formulas From Anywhere In Your Excel Workbook
• Formula Friday- Two Ways To Create A Time Stamp In You Excel Workbook
• Formula Friday- 3 Fastest Ways To Apply A Formula To An Entire Column Or Row In Excel
• Excel Tip- Formula Friday -How To Create a drop down list for your hyperlinks in Excel
• Top 3 reasons for your Excel formula showing in a cell and not the result
• Formula Friday -Using The Workday Function To Calculate Status Of An SLA
• Formula Friday – Find The Minimum Value In A Range But Ignoring 0 Values
• Formula Friday- Use The Standard Percentage Change Formula
• Formula Friday – Use VLOOKUP With MIN Function To Find The Product That Sold For The Lowest Price
• Six Common Mistakes Made When Using VLOOKUP Function In Excel
• Formula Friday – Calculating A Rolling Or Moving Average Using The OFFSET Function
• Formula Friday- My formula is not working- top reasons your formula is showing in Excel not the results.
• Formula Friday – How Many Sales People Have Above Average Sales Using COUNTIF Formula
• Formula Friday – Use Approximate Match In VLOOKUP Apply Grading To Student Papers
• Formula Friday – Prevent The Divide By Zero Error In Excel #DIV/0!
• Formula Friday- Time For A TRIM?
• Formula Friday Using DATEDIF To Count The Number Of Months Between Two Dates
• Formula Friday- Are We There Yet? Are We There Yet How Close To Your Goal Are You?
• Formula Friday- COUNTIFS With Multiple Criteria In Excel
• Formula Friday – How To Calculate The Number Of Workdays Between Two Dates Using NETWORKDAYS
• Formula Friday – Convert A Vertical Data Range Into A Table Using The Indirect Function
• Formula Friday- Increase Or Decrease A Number By A Percentage In Excel
• Formula Friday Generate Random Dates With RANDBETWEEN