state

Can someone help me with combining the following two macros? I cannot seem to figure out what I need to change/update. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Cells.Count > 1 Then Exit Sub If Target.Address <> "$B$3" Then Exit Sub Application.EnableEvents =...

Hi Everyone I need help on "If" function I have multiple State codes, Tax rate, Amount and Tax applied i.e. IGST ,CGST,SGST,What i need if State code is not Equal to "DLH" Than tax should be IGST,if State code is equal to DLH than tax should be CGST AND SGST. <tbody> <tbody> State Code...

<tbody> Joe & Sue Smith 123 Main St Chicago, IL 60601 Lets say I have a large column of data in this exact format. Any way I can separate this out quickly in excel into a name, then address, then city, state, zip formats? </tbody>

Hey guys, I have a huge excel file that I'm trying to get to run faster and make the file size smaller. There are about 150k rows of data. One formula that I feel is really slowing this thing down is a nested if statement. Can you tell me if there's a more concise formula than the one below...

Situation - there is a tally sheet where an employee tallies things that are missing based on States and Trucks run in a state. Each State "owns" a cell in the Sheet. If the Full State is missing, the employee types the State abbreviation in that State's cell. If a partial number is missing...

Hi, I'm currently working on a worksheet and need to find a way to classify the following: Below is a snapshot of some rankings by state for a measure I'm looking at. What I need to do is classify them on a Red (Top 25%)/Orange/Yellow/Green (Lowest 25%) scale. The problem I'm having though...

I have this formula currently. =CONCATENATE("Scheduled to Ship"," ",TEXT(V2,"m/d/yy")) However, Column V also has values that state "No Match". How can I get No Match as my return value instead of my current return of Scheduled to Ship No Match? Thanks in Advance! Kevin

Hi Team, i need to validation the zip code, locality name and state. currently i am keying the data and validating manually with address data base available in excel while validating i am following bellow procedure... 1st Priority is ZIP if zip code found then search for locality name and...

I have a worksheet that has column A (state) and column B (individual ID #). I need to review 100% of AZ, FL, IA, TX. But only a random 15% for every other state (i.e. 15% of HI, 15% of NY, 15% of TN, not an overall 15% if the remaining states). Can someone help me to write a formula for this?

For Worksheet_1, I have the following table below across columns A to G and on rows 1 to 15 in excel. As you can see, it shows which person owns which segment (SMB, ENT, GROWTH, COM) based on their state. So for example the person that owns ENT in MT is Kelly (cell G3) or the person that owns...

I am wanting to segment a contact list by creating a Segmented list name Column. I would like to segment the list by every 2000 contacts per state. I was thinking of having the column name be TX -1, TX -2, etc. for every 2000 contacts. But once a new state is presented then it should start back...

I have an Excel sheet which contains the following parameters: 1. Country 2.State 3.Site 4. Shifts 5.Experience I have another sheet in which I have the following 1. Country 2. State 3. Site 4. Vertical I want a seperate Excel Sheet which contains the following columns: 1. Country 2. State 3...

Hi I have a spreed sheet that has names and address on it. A1 has a name A2 has a number and a street A3 has a city, state, and zip code (which is a number) A4 is empty A5 is empty A6 has a name A7 has a number and a street A8 has a city, state, and zip code (which is a...

Hello everybody. I'm coping with the following situation. I have to report values from sheet2 to sheet1. The condition are as follows: 1) not consider data that in sheet2 are in state open (column B); 2) if the state is closed (column B, sheet2), then report in sheet1 on the row...

Hello All, I have an interesting problem that I am trying to solve. Lets say I have a lot of data. In one column (Column T) it shows multiple states in the following format: *AK*AR*CO*LA... I would like to write a macro that will read the values in this column and insert a row based on how...

always feels good to come back to Mr. Excel, feels like I'm learning something new. Anyways, I have a master sheet of accounts with a state they are located in. On another sheet I have an engineer assigned and multiple states they will cover for those accounts. Sheet 1 Company A, CA, insert...

I am trying to display all states names that are duplicates. With the formula I am using below, it only shows the first state with a specific ranking and all other with the same rank show #N/A. =INDEX($A$5:$A$58,MATCH(ROWS(B$2:$C17),$C$2:$C$17,0)) The data is in columns A through C. The...

Hello. I want to have a drop-down list with selections and based off of the selection in that list, other cells will populate the corresponding row values associated with that selection. For example, if I select Virginia, the table will return all data for that selection. Raw data: <tbody>...

hello everyone, i have a table like below picture: i want to give specific amount of number from user ( the amount of number is based on unique values in state field- for example in above picture we have 5 unique state then we should give 5 number from user) with inputbox and paste the number...

Hello I have a toggle button added to the ribbon (xml way) and I have the following code: Sub ribbonbutton1(control As IRibbonControl, ByRef cancelDefault) If Sheets("Database").Range("I2") = "Yes" Then 'check if master If Sheets("Database").Range("I4") <> "Yes" Then...