states

Hello! I have one table with states on the left hand side going down and odd numbers on the top going across. I have another tables with states on the left hand side going down and even numbers on the top going across. It looks like: 1 3 5 7 ... AK x...

Happy Friday! Looking to see if there's a way to do a conditional format of a column of states that have mixed in non-US locations Currently I have a list of employees and the states they cover John Smith, MD, WY, TN Arron Smith, OK, TX, FL Each of these is a separate column. I then have a...

Here is the data I am working with... <tbody> MultiEmployees English (United States)-> Polish (Poland) Afaf Steiert (Afaf Translations) Chinese (China)-> English (United States) [SN0017] Future Trans English (United States)-> Slovene (Slovenia) [SN0017] ES Localization & Translation...

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

I am trying to rank states according to specific criteria. I am using the formula below to rank each state but I have many states with the same ranking. They are displayed as #N/A. Can anyone suggest a way to show all duplicates with the same ranking...

Is there a way I can get some text from a webpage? The page in question is an internal intranet page, so I can't paste the URL, but it has text which states 'Current Version:' and I need to get the text after that phrase if it's possible.

let's say you have 2 sheets with identical data Was thinking of a way, for tracking changes made in sheet. Was thinking column z on source sheet could contain a formula that states something like =if(PreservedSheet!A1:V1 <> SourceSheet!A1:V1, "1","") Any ideas how to make that formula work; I'm...

Hi All, I have the following formula to dictate a conditional formatting rule: =AND(OR($E3=TODAY(),$E3=TODAY()+1,$E3=TODAY()+2,$E3=TODAY()+3),$F3="Date not Found")) I would like to format dates in column E, which are coming up in the next three days, but they should only be highlighted if the...

Hello, I have a pivot table that I am struggling with. The back story is that I use Microsoft Dynamics GP and Excel Report Builder. The excel report is a refresh able report. This report is used to capture our EFT and Check information so we can submit it to our bank (so they can send out our...

Hi, I have a sheet with a table with two columns: the first column says countries and the second column says fruits. Countries Fruits South Korea China United States Russia Australia Singapore If I enter values on some of the fruits for some countries and leave the...

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

I inherited a spreadsheet that has a conditional format in cell C18 that states =XFC18<C18 and it turns the text red when I put a value in the cell. How do I interpret this? Thanks

Hi Guys, I am trying to write a formulae that will calculate the working hours between two date + time stamps formatted "dd/mm/yyyy hh:mm:ss", but I also need it to factor in the schedule type of the entree, of which I have three located further along the row: - 24/7 (where all hours are...

So I've been researching all day on how to do this, and I'm a bit confused on how to proceed. I need to create multiple top 5 list of States from a data series. I've included a screenshot to help better understand what it I'm trying to achieve. In short, I need excel to auto calculate the top 5...

Hi, I am writing a VBA code to automatically clean up some excel reports I run on a regular basis and I have a situation where I am stuck. Column J of my data contains Country Names and column K of my data has State Names. Here's what I need: If the values in column J are not equal to either...

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