-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
counties
-
S
Autopopulate column after dropdown?
I have a list of states and their counties. I'm looking for a method to choose a state from a dropdown and a column of their associated counties appears. Or, if the user types in the 2 letter state name and it auto populates the counties. I've played around with dropdowns and v/h lookups with...- sammipd
- Thread
- autopopulate column counties dropdown state
- Replies: 5
- Forum: Excel Questions
-
K
Find and Replace Multiple Values
Hi all, I have 20 different tables (which are quite sizeable 100,000 records each) that relate to 50 unique counties. Unfortunately, the tables come from different data sources so the exact spelling of each of the counties is different. In an effort to create a relationship between all the...- karlitob
- Thread
- counties data multiple tables unique
- Replies: 9
- Forum: Excel Questions
-
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...- excelsos
- Thread
- california counties current day sheet
- Replies: 3
- Forum: Excel Questions
-
V
Multiple Drop Down lists off of one primary drop down list
Hi, Is there any way to create a 2 dependent drop-down lists off of one primary drop-down list? I have States, Counties, and Products as the columns. Products are the same across all counties in the same state. I've create a name range linking States and Counties. How do I link up the...- vik2slick
- Thread
- counties create drop-down products states
- Replies: 0
- Forum: Excel Questions
-
List of Job Assignments
How can I have Excel return a list of job assignments based on a particular location? Employees assigned to a particular airport in Texas have to do research in all the adjacent counties to that airport (there are over 250 counties in Texas). For example lets say Jack is assigned to do work...- thetank
- Thread
- adjacent assigned counties employee list
- Replies: 0
- Forum: Excel Questions
-
T
VBA Help
I don't know much about how to write VBA code but I had a situation I wanted a statement to appear if certain counties were in AR. I had the states in column W17:W130 and the counties X17:X130 on the spreadsheet. Function ArkansasWind(myRange As Range) As String Dim i As Long Dim...- Tennisguuy
- Thread
- counties countiesi dim mycount myrange.offset0
- Replies: 6
- Forum: Excel Questions
-
K
Applying sample weights and calculating frequencies based on various conditions
Hello, I abandoned SPSS a few months ago and have been using excel to do most of my thesis analysis. The one thing I can't work worked out how to replicate in Excel is apply sample weights before running frequencies/counts. Can they be calculated within a COUNTIFS formula using a SUMPRODUCT...- KatK6
- Thread
- counties sample weights summit
- Replies: 0
- Forum: Excel Questions
