### Welcome To The Full Collection Of Formula Friday Excel Tips.

My **Formula Friday Excel Tips** blog post series has been running for 2 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 and Google+

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.

**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****Formula Friday – Use VLOOKUP With a Wildcard****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- Prevent Duplicate Data Entries With COUNTIF Formula And Data Validation****Formula Friday Generate Random Dates With RANDBETWEEN**