Recent content by gwstudent

Xiq - that worked too. Two totally different solutions but with the same result. I never would have thought to use either approach. Thank you for your input.

Chirayu - You are a champion and a scholar. Thank you very much!

This seems so simple yet my formula isn't working - so I must be going about this the wrong way. I have a row of data from column B to column Z: A, B, C, D, E, F, G, H... If the row contains an "A" or an "H" (or any other value) I would like to simply show a "1" in the current cell - A1. My...

Scratch that. I got it. Thanks Azumi - you rule!

Azumi - This works if the data is on the same page. I can't get this to work if the data is on two separate worksheets. For example, the Part = 3 and Code = A information is on one worksheet and the description is on another. I get an #N/A message. I'm using named ranges also. Any ideas?

Hi experts - Is it possible to display a data validation list based on multiple (2) criteria? Using the data below as an example, suppose I want to display a data validation list based on Part = 3 and Code = A. The resulting data validation list should be cat, dog, cow. Similarly, if Part = 4...

Is it possible to create dynamic data validation menus without named ranges? Here's my situation: I have a data-connection from SharePoint that provides me with certain data on one worksheet. ProgramID, Program Name, Program Description, etc. On another worksheet, I have a second set of related...

That's brilliant. Thank you so much!

Hui - First of all that's genius and that works if I want to sum all of the columns but is there a way to get *exclusive* results? So, if the VC1 column is true then display 1 OR if VC2 column is true then display 2 OR if VC3 column is true then display 3? Again, I realize there are...

Hi - Yes. This spreadsheet is a mod of the vacation tracker that I have re-purposed. On the Tracking worksheet, Column P, row 60 there is a SUMIFS formula which works fine enough but it also needs to to check all the values in columns N and O (not just M) and populate the respective field...

Hi - There is a great posting of a vacation dashboard here: http://chandoo.org/wp/2013/01/24/employee-vacations-tracker-dashboard/ This solution stores all of the vacation information in a single column, that is the vacation type, start date, and end date are in their own respective single...

A formula - not VBA. Essentially, I am looking hoping to just have a page that has all the data without the need to filter anything. I intend to create a page that has divisions by state.

That's a nice option. Can you think of a programmatic method?

Hi - I have posted a sample file here: https://docs.google.com/file/d/0B2V4Nkca2ASFUkV5TVBxSzlLaVU/edit?usp=sharing Suppose I have 3 columns of data. ColA = City ColB = State (50 U.S. States) ColC = Name How would I get ALL of the names, from ColC, based on required criteria of B and...

Jai - Thanks! That was way more easy than I thought it would be. Awesome.