Search results

For anyone wondering, it looks like this approach will do the trick: http://forums.techguy.org/business-applications/731243-solved-excel-how-use-wildcards.html For instance, if you download the attachment, you can enter B, Bo, or Bob and it will fetch any results that include each of the...

Bob - thanks for your help, again. The drop-down you suggested won't work due to the vast scope of the possible inputs. So, I can't go that route (i'd have to put hundreds of options into the drop down list). A formula that I found that gets me part of the way there is...

Bob - got it. However, what if instead of having a drop down, I have a free text field where the user types in 'Tia', but does not type in 'Flores, Tia'. Then, the lookup doesn't work, correct? That's the issue I'm having. Individuals will not always type in the same uniform name, nor will...

Bob - I like the example, thanks much! I guess my issue with yours would be that the VLOOKUP has to find the exact name of the sales person (i.e. Flores, Tia). But what if you wanted it to find any transaction where a sales person whose name contained Tia as involved (in case, for example...

In a separate thread, Hui posted a response to a similar question regarding arrays that basically says search for anything in the first column with the specified letters (in this case 'E5510') and bring back the sum of those items. Another posted indicated you can use SEARCH to avoid the case...

Hi all - I've found a number of similar queries, but nothing that does exactly what I think I need (unless I just don't know the terms, which is possible). Anyway, I have a list of fixed assets and I need a user to enter a term and see if that asset already exists. I.e. let's say I want to...

Faseeh - First off, I always love seeing the ideas of others - especially when they're willing to share them. I think the overall effect of your work is great, but I do agree with the suggestions above, specifically: - the concentration report ('heat map' as you referred to it) is...

So, I've got a basic pivot chart tied to a pivot table with some data in it (in this case, project revenue and cost). I have a drop down on the pivot table with the project in it (i.e. Project 1, project 2, etc.). When I filter the pivot table on Project X, the data in the pivot chart should...

Luke - apologies, you're right. When I restarted, it appears to work now. Do you know how I can add a 'range' to the formula? In other words, I only want the macro to run when I highlight cells A1:F99 or something of the like? That way if they click on a blank cell outside the range of...

Luke - thanks for the quick response. When I do this, nothing shows up in the cell (Z1 in your formula). Do I need to put a formula in the destination cell, like =MyCell() or something like that? And would this automatically run each time I select a new cell, or would I need to run a macro...

I think this is VERY simple, but can't seem to figure it out. Let's say I have 40 cells with various values in them. In another cell on the same sheet, I want to return the value of whatever cell is selected. Ex. I put my cursor on cell B3, and in B3 it says "JACK" - in a designated...