california

  1. F

    Dependent data validation list: non-VBA

    I've found plenty of sites talking about dependent data validation drop down lists, but none that I've been able to apply to my situation. I need three data validation lists, each dependent on the one before it - all three lists will come from the same table. It would also be nice if the user...
  2. O

    Extract only the Titles that not empty

    Hello friends, In the example I have attached, I have a list of countries where some states have data in the same column and some do not. In the table below I would like to see only a list of countries that have data. Hello friends, In the example I have attached, I have a list of countries...
  3. L

    Index Match of partial data then date drive results

    Hello Thank you for taking the time to check out my question. I searched the forum for an answer and I have found things that are in the same area, but not quite what I am looking to do. I have two sample sheets: source and location source <style type="text/css"><!--td {border: 1px solid...
  4. L

    Array Formula - Doesn't Repeat

    <tbody> I found an array formula online that helped me get a result for the 1st, 2nd, 3rd, etc. non-blank cell in a column. Formula: =INDEX(A$1:A$80,SMALL(ROW(A$1:<wbr>A$80)+(100*(A$1:A$80="")), 1))&"" (the "1" at the end of the formula determines which non-blank result to output). I used...
  5. P

    Filtering Data - Contains formula

    I have a list of internet search keywords and I want to filter out ones that have state or city in the keyword string. Is there any way to write a formula that references a list of states/cites and if any of state/city keywords appear in a keyword to have the referenced keyword appear in a...
  6. T

    not sure which formula to use for this ...

    Hello all, I'm stuck trying to figure out if this is even possible in excel. Basically what im trying to set up is a chart that will give me a yes or no answer. sounds simple enough but where i'm struggling is this. in cell A1 there will be a drop down list of all 50 states. same goes in cell...
  7. E

    A day of formulae hell

    if(E2=California),Vlookup(D2,'CA Counties'!A1:C2330,2,"") Ok - Today seems to be the day of mishaps. so I have a spreadsheet with multiple tabs: 1 - Has California Counties. I basically need to have it look up on Sheet 1 - California (If the state name= California), then I need it to look up...
  8. J

    Conditional Data Validation

    I am trying to have the drop down values of one cell dependent on the selected drop down value of another cell. What I have is: Cell a1: Value can be either Yes or No Cell a2: Value can be California, Colorado or Connecticut if a1 is Yes but if it is No then the only allowable values are...
  9. S

    Counting locations per name

    Hello! Hopefully this is an easy one.. I have a spreadsheet with a number of names in one column, and locations in another column. I'm hoping to find a formula that can tell me how many times the location shows up per person. For example: <tbody> location name Calfornia Jeff Maine Mary...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top