Top 10 Excel Formulas for any situation
Excel has hundreds of formulas. But as a new learner or user, you may want to just focus on top 10 formulas to get the most out of it. Assuming you already know the basics (check out Beginner Excel page if you are complete newbie), here is a list of top 10 Excel formulas for you.
Can you extract numbers from text – homework
Here is a quick homework to keep you busy this weekend.
Can you extract number of days from below text.
Nov15 PUTS (23 days)
March15 TIKS (3 days)
March1 TIKS (25 days)
June11 TIKS (10 days)
Assume the data is from cell A1.
Your solution should return the following:
23
3
25
10
Post your answers (formulas, VBA code or Power Query M code) in the comments.
Formula Challenge 001 – Return everything from a string after the first block of numbers (Part 3.)
Welcome back to yet another gripping episode of “When good formulas go GREAT”. We’re working up the singles charts to the number one hit “Formula Challenge 001 – Return everything in string after first block of numbers” By way of a quick refresher, this formula challenge calls for a formula to return a substring from […]
Formula Forensic No. 021 – Find the 4th Slash !
No, Not that Slash !
How do I find the 4th Slash in a text string?
Today at Formula Forensics we take a look at 4 different methods.
Become a Comparison Ninja – Compare 2 Lists in Excel and Highlight Matches
Comparison of lists of data is something that we do all the time. Today, lets learn a few tricks that you can apply immediately to compare 2 lists using Excel. This post discusses how to compare two lists with formula based rules. If you just want to quickly highlight common values, click here. If you […]
Excel Tips Submitted by You [Part 2]
In today’s installment of “your week @ PHD” we will learn how to use array formulas to refine text search, a bunch of very useful keyboard shortcuts, and a very simple tip on how to get ready when you want to make a chart. All really juicy tips, so read on.
Search a Spreadsheet Full of Data using Conditional Formatting
Many of us use spreadsheets to manage huge lists of data, like customer data bases, salesperson data bases etc. Today we will learn a little conditional formatting trick that you can use to search a worksheet full of data and highlight the matching cells.