state

  1. S

    transpose rows in columns

    I have a table with cells compiled in rows and I would like to create a table that transposes the rows of the previous table in columns. These are the parameters to be taken into account: 1) the name of the file that will be created will be equal to the status symbol (column "E" of the "state"...
  2. A

    Pulling info from a table based off store number

    Hello, I am struggling with this formula. I was using index function, maybe I shouldn't be. I have an online form that people can put their store numbers in and submit commissary issues. I want to keep that form short. So on the back end, I want to fill in the City, State etc. columns by...
  3. A

    If N/A then look up first 3 digits of different cell and value from a table.

    <tbody> A B C D 1 Zip 54032 2 License #N/A 3 4 </tbody> <colgroup><col><col><col span="2"><col><col></colgroup><tbody> </tbody> I want a formula that only populates D2 if B2 is #N/A. Formula will look at the first three digits B1 and and look-up the...
  4. Mikec1012

    Easy way to capitalize state abbreviations in a cell

    Hello all. Working with an in-depth spreadsheet. I have one cell that contain CITY STATE ZIP and I canny split. I’m running a macro that will proper case my cells. However, on the cell with City State Zip - my state abbreviation goes from FL to Fl. Is there a macro I can run again to change the...
  5. B

    Formula to exclude items in a range of cells

    I have a number of cells that I want to concatenate into one cell (merge multiple records into one record). However, I would like to exclude cells that start with the words State or Service Center since these have to be placed into a separate field in the record. Column A has all the member...
  6. B

    VBA - Smallest number in range (greater than -1)

    How would I state the following in VBA? ... If ActiveCell.Offset(0, 1) > -1 AND _ ActiveCell.Offset(0, 2) > -1 Then ActiveCell.Offset(1, 0) Else Below is my question on how to state in VBA. Would go right after "Else" in the above code" ... Thanks for any help everyone
  7. C

    Sequential Numbering

    Hello Magical Excel Guru's! I am trying to determine if there is a way that I can use either a formula or vba to auto assign sequential numbering based on text. Basically we have the united states split into 5 zones. There are multiple states in each zone. Each customer will be assign a site...
  8. A

    Excel Macro for moving whole row according to column value

    Hi,I am very new to macros and in need of solution please. So I have over 140,000 rows of data in which column "C" has specific keyword(s). I would like to create a macro in which find if it does contain these keywords it would copy it to another spreadsheet. Example: Column C might say...
  9. W

    Column Matching for state abbreviation.

    Hello. I have column H filled with state names in full. I would like to quickly change all state names into a 2 letter abbreviation. I'm assuming I can do a "VLOOKUP" formula? I do have a separate spreadsheet which has state names in column A and state abbreviation in column B. This is an...
  10. B

    Validation and Index/Match

    Hello, first this is an old version of Excel, it is 2003 SP3 but, I have never needed more than it can do, so I never upgraded it, so please keep that in mind, as I know options change from revision to revision I have a chart I am working on with one sheet called data and it is just a big...
  11. J

    index - match - 1 value - 3 possible matches

    I am currently trying to look up 1 value - which is a state and could have up to 3 matches with that state, where there are up to 3 different zip codes that I would like to return in order to do other formulas based on the 1-3 results. I would like to reference the look value on 1 tab and have...
  12. S

    VBA: If cell <> More then move to Next I

    Hello, I've written a macro with a rule that if a value is not equal to MORE then exit sub. That's working fine, but instead, I'd like it to state that if Value is not equal to MORE then go to Next record (Next I) Code I have to end the sub is as follows. If xlsheet.Cells(i, 26).Value <>...
  13. B

    using an if statement to reference a collumn

    Hello, I am trying to create a large loop that will reference my column called cities. I want the loop to refernce cities and put the state of these locations in a new column with the header state. My table is below. I have 5 different cities Memphis, Sand Diego, Seatle, Portland, and Charlotte...
  14. H

    How to use a VLOOKUP across multiple columns?

    Hi all, I'm hoping someone has an answer to this issue that I am am running in to. I am working with a not so eloquently designed spreadsheet to begin with, but hopefully that won't bog down what I am trying to do. Here is a simplified version: Table 1 <tbody> Defect ID (Column A) State 1...
  15. D

    Find state by city name

    Hey friends, Can someone help me to create a sheet where I can get the State name by entering city name. For eg; When I put Barwon Downs(city) in column A, column B should reflect Victoria (state). Attached is the sheet with data.
  16. H

    Help with Cross-Criteria in Multiple Columns

    Hi all, I'm hoping there is a simple answer to this that I just haven't been able to think of. I simplified my issue into the two tables below, the first being my raw data table and the second being the basic reporting dashboard that I am building out. Raw Data Table: <tbody> Unique ID State...
  17. K

    PLEASE SHOW ME HOW TO Separate full address INTO COLUMS ADDRESS, CITY, STATE, ZIP

    I NEED :help:TO SEPARATE FULL ADDRESS IN DIFFERENT COLUMS OR COMMAS: Example: THE WAY I HAVE THE DATA IS LIKE THIS: <tbody> <tbody> THIS IS THE WAY HAVE THE LARGE DATA ADDRESS CITY STATE ZIP 9737 NW 41 ST SUITE 182 DORAL, FL 33178 <tbody> 19737 Carabana st. Fort Myers, FL 33901...
  18. S

    Finding State Only

    Hi, I have a list of addresses (Australian) in column B on my worksheet. I want to extract the state only. Note that some states have two characters and others have 3, what is the best formula for this? Example of the address is as follows. For this I would just want to return "NSW" as the...
  19. M

    Convert Lat/Long to address.

    I have excel and MapPoint...in excel I have lat/long and want to convert to get the city, state, zip in different cells. Is this possible? How have found options to convert city, state, zip into lat/long but not reverse. Thanks for any help! M
  20. D

    Capture Autofilter state

    Hi, I use Excel 2007 and I have a spreadsheet with data in column a thru O and 300 rows with Autofilter turned on for all columns and buttons with code behind them. I'm trying to capture the state of Autofilter to be able to revert back to it. In more details here is what I do: I use...

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