state

  1. C

    Worksheet Macros and Combining Them to 1

    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 =...
  2. hardeep.kanwar

    If Function with multiple criteria for tax calculation

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

    Separate names, addresses

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

    Alternative to If Statement...

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

    SUMIFS getting too big - is there a better way?

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

    Looking for a formula to accomplish the following...

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

    Using Concatenate and If Statement... Help Needed...

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

    address validation automation

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

    Random sampling

    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?
  10. T

    Need help finding a result in a table (array? maybe simpler?)...

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

    Contact List Segmentation:

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

    How to link two columns in Excel

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

    use and if state to find cells with just text and not text and numbers

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

    Vba: searching value and reporting them in another sheet

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

    Macro To Insert Rows

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

    Match a person's name to multiple states

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

    Need help with duplicate information showing #N/A.

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

    Return corresponding values based off of Data Validation List

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

    help me with coding this statement

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

    Change ribbon toggle button state

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

Some videos you may like

This Week's Hot Topics

Top