All articles with 'search' Tag

Can you extract numbers from text – homework

Published on Oct 30, 2015 in Excel Challenges, Learn Excel

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.

Continue »

Formula Challenge 001 – Return everything from a string after the first block of numbers (Part 3.)

Published on Jul 19, 2013 in Formula Challenges, Posts by Jeff
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 […]

Continue »

Formula Forensic No. 021 – Find the 4th Slash !

Published on May 17, 2012 in Formula Forensics, Huis, Posts by Hui
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.

Continue »

Become a Comparison Ninja – Compare 2 Lists in Excel and Highlight Matches

Published on Jun 17, 2010 in Excel Howtos, Featured, Learn Excel
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. We will learn how to compare 2 lists of data in 3 + 1 different ways. (click on links to jump to that section of […]

Continue »

Excel Tips Submitted by You [Part 2]

Published on May 12, 2009 in Charts and Graphs, Learn Excel

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.

Continue »

Search a Spreadsheet Full of Data using Conditional Formatting

Published on Mar 31, 2009 in Learn Excel
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.

Continue »

“I am feeling lucky” Firefox Search plug-in

Published on Jun 5, 2008 in hacks, ideas, technology

While trying to understand how the Mozilla firefox search plug-ins work [ more ] I got curious and wrote a search plug-in that will take you to the first Google search result directly instead of displaying the results pages, ie mimicking the “I am feeling lucky” searches. Feel free to download and install it. 1. […]

Continue »

Pointy growth inside nose and other such meaningless junk

Published on Jan 14, 2008 in blogging, Humor, wonder why

I get immense pleasure out of watching search phrase that point to my little blog. Recently some really weird search queries found their way to my blog, see for yourself, pointy growth inside nose, really? search breast enhancer in asian sky shop, no comments what is special in iim mba passout well, nothing except that […]

Continue »