Searching in the Board

Searching in the Board

It turns out that online help is not for wimps, nor is searching online help. The forums at MrExcel.com are not only interactive Q&A forums, but also serve as a searchable Database of problem/solution sets.

Knowing how to search for a problem/solution set might lead you to an array of potential solutions without even having to ask a question!

There are two main methods of searching the forums.

Google Search

It’s fast and robust. The trick is to make the search site specific, you can do this by adding site:mrexcel.com at the beginning of your search. Here’s the starting point:

And here are your ‘Advanced Search’ options:

And note, the domain is populated for you, here.

Google Search Tips:

  • If searching for phrases, include them in "double quotes"
  • Words that must be included in search results should be preceded by a + sign. eg +formula
  • Words that must be excluded from search results should be preceded by a - sign. eg -macro

Now, we’ll look at a few examples.

First, here’s a general Google search on the Forums, here, on conditional formatting, (this is how you would enter the search in the Google search bar):

  • site:mrexcel.com "conditional formatting" "more than 3 colors"

In this example, we have searched MrExcel.com for the phrases "conditional formatting" and "more than 3 colors". Click here to see the search results.

Second, we’ll look at a user-specific search. In Google, search on:

  • site:mrexcel.com NateO Byte Ubound

In this example, we have searched MrExcel.com for NateO, Byte and Ubound. Click here to see the search results.

Also note that signatures work as well, e.g., Nate Oliver is a viable search, as seen in the following example:

  • site:mrexcel.com Nate Oliver Byte Ubound

There are at least two possible limitations to this:

  • Google might not have cached a useful post, yet.
  • The search results don’t appear to be sorted, in any way, let alone by date. For this, we’ll turn to the built-in search functionality.

Built-in Forum Search

Click Search button on the top right corner of the page to make a search.

Or you can use Advanced Search for more options.

Once on that page you should find lots of options to help refine your search.


Sent by NateO (Legend) on Nov 20th, 2005

Some videos you may like

This Week's Hot Topics

  • Importing multiple excel files into one spreadsheet
    Hi, I'm trying to import multiple excel files (with the same format into a single spreadsheet) so that each day's file is listed underneath the...
  • find many based on a certain criteria
    good evening, I hope someone can help me? I have a workbook sheet 2 contains lots of data.... I would like to be able to find anything on sheet...
  • How to copy multiple rows using If
    Hi all, I'm very new to VBA and have written this simple code to copy certain cells if a certain cell within that row contains any data. I need...
  • VBA If statement
    Dear All, I have two dates, where I'd like a message box to pop, if the dates are between this criteria. [CODE] sDate1 = #10/1/2019#...
  • Text Format
    I have a sheet for user to keyin the data. The format of the data can be 451 / 1903, 0012 / 9908 or 00287 / 0099. The number after the "/" is...
  • Macro to copy values across rows and transposing them and add the user id
    [FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=Calibri][SIZE=3][COLOR=#000000]Hi,[/COLOR][/SIZE][/FONT] [FONT=Times New...
Top