california

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

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

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

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

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

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

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

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

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