locations

Hello, I am struggling with COUNTIF and COUNTIFS formulas so I’m hoping I may be able to get some help here? I have two columns of data; column A contains a list of locations and column B contains either Yes, No or is blank. There are 33 unique locations and each location appears multiple...

So I have, what I think, is a somewhat complicated scenario that I need to solve. I have bits and pieces but can't seem to get it to all come together in to the end result I am seeking. I have a single workbook. Two worksheets. Sheet 1: ItemNames in column A and Locations in column B. There...

A21:A30 are locations C32:C2000 has names of locations G32:G2000 has a dollar amount H32:H2000 has a dollar amount I need B21 to only count locations in C32:C2000 that correspond to A21 and have a value in either G21 or H21. Example C32 is "Home". The formula sees that A21 is "Home", but also...

Wise people of the forum.. I need help. How do I Conditional Format each row separately to show the locations that exceeds the average of all locations in the row? Once it set up for the first row how do I copy it down to the remaining rows? <tbody> Location 1 Location 2 Location 3...

Hello, this great, I am so lost.. I have the following inquiry... I have rather large report that I need to glean data from each morning. Below is a sample. What I would like to do is.. run a macro every morning that automatically selects certain locations from the report and creates a new...

I'm looking for a solution to save a workbook to two locations. Location 1 is a folder on my local hard drive. Location 2 will be on either my OneDrive or one of the other cloud drives I use (not sure which, but probably the OneDrive). Would like the routine/macro to run from a custom button...

Hello, I am trying to work on a way to automatically fill in a schedule for where someone should be. What I have so far is in my 1st sheet I have a table of cells I want to fill, across the columns i have dates, and down the rows I have the locations. In my 2nd sheet I have the dates of when...

I am trying to setup a table that sums the dollar amount for specific locations during a certain month. I am getting the #value when trying the following =SUMIFS(F2:F100,C33:C51,">9/1/2017",C33:C51,"<9/30/2017") but I don't know how to add the location. I want the sum of F2 when C2 is between...

I have a file that uses an active x control box to save the file into two locations. The code is as follows: Code<<Sub SaveToLocations()'UpdateByExtendoffice20160623 ActiveWorkbook.SaveCopyAs "A:\PAULA & RUTH\CAPITAL ASSETS" + ActiveWorkbook.Name ActiveWorkbook.SaveCopyAs "P:\Rail Car...

I've been trying to get either to work on a website and I can't seem to get either to work. I don't understand the source of the webpages very well, if someone could help that is familiar The website: http://www.sportsline.com/nfl/odds/ I've tried this as well as other index locations and...

I'm quite newish to excel but here goes. Below is an example of the data I'm working with: <tbody> Location ID Units A1-01-01 2356487 2 A1-01-02 2356487 5 A1-01-03 7656732 7 B1-01-01 7656732 10 B1-01-02 2356487 10 </tbody> The B1 locations hold IDs which already exist in A1...

I have a sheet of information that I would like to graph. See the sample below. You can see that there are results for different locations, different dates. There are very few common dates. I need the ability to create either a stacked bar of the 10 variables, a bar chart of the total, a line...

I want to average data in various cell locations(diff rows, diff columns) not including cells with values of zero. should I be using AverageA or AverageIF, What should the formula be???

Hello Excel world! Here is my situation: I am basically "mapping" locations on an excel sheet... Headers: Name | Lattitude | Longitude | ZIP code I have another list of US ZIP Codes, that also have the longitute and latitude data. What i need is, when a user enters in the zip code...

Hello everyone, I am relatively new at macros but I have been able to build a macro to create a series of monthly cost reports to be distributed to different managers. The workbook consists of two tabs a distribution tab (who gets what report) and the report itself which is linked to our BI...

Is it possible to set up tusted locations in excel 2000 & Excel 2003. I have a few users that i need to give access to a particular spreadsheet without lowering the security settings. It's simple on ecel 2007 but i can't find the solution for 2000 & 20003 versions. any help much appreciated. Lee.