• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. G

    Validate for one of multiple criteria in a row

    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...
  2. G

    Data validation list > multiple criteria

    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...
  3. G

    Uber-dynamic data validation menu - possible?

    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...
  4. G

    Calculations across columns vs. single column

    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...
  5. G

    How to extract data from a table based on multiple criteria

    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...
  6. G

    Nested Index Match with multiple criteria - possible?

    Hi - I have posted a sample file here: https://docs.google.com/file/d/0B2V4Nkca2ASFby1vcDMtNWN4UjA/edit?usp=sharing Suppose I have a budget with a list of tasks that will be worked on. Each month, costs related to this list of tasks come in. Is there a way to roll-up the costs associated with...
  7. G

    Search text for pattern and return numeric value - IF formula?

    Suppose in column A I have text of various lengths like the following ... A 1: ... ... B 3: ... ... F 9: ... ... D 1: ... ... C 2: ... ... A 4: ... In column B I would like to display the numeric value before the ":" only if I find A, B, or C prior to the numeric value. D and F would...
  8. G

    Display all values that meet certain criteria only - not pivot table

    Hi - I have posted a sample file here: https://docs.google.com/open?id=0B2V4Nkca2ASFSXlQWWdFWm0zV2c I have a table in the second worksheet with misc values. In the first worksheet I would like to list all the values from the second that meet certain criteria - like a cross tab query. For...
  9. G

    Display certain values in table

    If I have 4 columns of data, see example below, is it possible to reference values within this data that meet certain requirements? For example, show in a column values from Course (Col1) that are from Term BBB (Col2) and Year YYY (Col3). I have tried index + match but without success. Col1...
  10. G

    Advanced Data Validation > dynamic list menu

    Is it possible to have a dynamic drop down list menu that displays criteria based on a cell reference? For example: Col1_____Col2_____Col3 A________1________Based on A2, menu would display 1,2,3 (A values from Col2) A________2________Based on A3, menu would display 1,2,3 (A values from Col2)...
  11. G

    Conditional Formatting based on content used with a Gantt Chart

    I have a standard generic Excel Gantt chart that works perfectly fine that I would like to show different colored bars based on a name in one of the cells. Can anyone help. A1, B1, C1, xx, 8/1/2011, 8/15/2011 yy, 8/2/2011, 8/10/2011 If xx then show red bar, if yy then show blue bar...
Back
Top