region

Hi All, I have a column of date/time in (1/2/2018 1:00:00 PM) format, and in next column I want to have Region (APAC/EMEA/US) basis on below calculation. Please suggest the formula. APAC 8pm-6am EMEA 3am-12am US 9am-8pm Thanks in advance.

Hello, I am trying to create an Excel workbook where users must select an original value from a drop down listing, and then fill out remaining information using additional drop down listings that are dependent upon the original drop down listing. There is one catch. The dependent drop down...

Hello, I am trying to create a shared spreadsheet where users can select an original value from a drop down listing, and then fill out remaining information using additional drop down listings that are dependent upon the original drop down listing. There is one catch. The dependent drop down...

Hi all, first post on here.</SPAN> I’m having trouble cracking the VBA code I need to allow a user to select a region name from a drop-down list on Sheet1 that will filter results (based on their selection) in 9 other named worksheets (Week36 through to Week44). </SPAN> The drop-down list is...

I have a manual table which will be updated with new countries/states every 6 months or so. Once we update the countries/states, it will auto update a dashboard and the formulas associated with it. Example: <tbody> Region 1 APAC Region 2 US Region 3 EMEA Country 1 Japan Country 1 Florida...

Hello All- I have a dataset that I need to utilize the transpose function. Dataset I currently have: Mary Smith Region 1 Dr. A Mary Smith Region 1 Dr. B Mary Smith Region 1 Dr. C Mary Smith Region 2 Dr. E Below is what I need the data to be: Mary Smith Region 1 Dr. A Dr. B Dr. C...

Good day, I thought this would be easy but I'm having a devil of a time, I hope someone can please help! I've tried writing this in a table; within PowerPivot; and as a measure but nothing seems to elicit what I'm after. (I'm new to PowerPivot, so I may be overlooking something obvious.) I'm...

Hello, I'm hoping this is a silly question with an easy answer. I'm attempting to make pivot tables represent monthly percentages based on yes/no data. My ideal output looks like this: <tbody> Row Labels Region 1 Region 2 Region 3 Region 4 Jul 20% 30% 9% 50% Aug 3.5% 7% 25% 2% Sep 80%...

So I found plenty of help online about shading the region between two lines and successfully got it working for my data (specifically using this website: https://peltiertech.com/fill-under-between-series-in-excel-chart/ ) Well - now I need to only have a shaded region if one of the lines is...

Can a macro REPLACE all the numerical values in columns D through L (there will be at least 5,000 rows) with a value from column C? The value in each cell in columns D through L matches one of the unique values in A2:A155. The value in column C on that same row as the match in column A...

Hi folks, I'm trying to figure out a formula which will do a lookup of a region to find cities to sum sales in an associated table. I can manually do this by hard coding SUMIFS statements. However this is not scalable and will be too difficult to maintain before long. Any ideas on how I might...

Hi, I need a formula that will sum a range based on three criteria: 1) Project Code (D7:D17) 2) Region (C7:C17) 3) Period (E5:P5) I tried a Sumproduct but it freaked out with three criteria :/ - I need this to obviously look at all three corresponding columns (dependent on whether it's Q1...

I have various sheets from sheet 5 onwards based on the unique region name in Col A on sheet1. Have a macro to create these sheet names I have region names in Col A on sheet1 ("customers") from row 12 onwards and headings in row 11 I have a macro to copy all the data from row12 onwards based...

I have two similarly formatted lists on different worksheets in the same workbook. List A is my master list. List B, which changes weekly, has some values that exist on List A along with completely new values. Each list has about 2,300 rows. I must compare these two lists and find the new...

Hi folks, I have a list of 5 products and each of the 5 products are produced in 2 different cities, with sales in each city (the cities aren't really important for the solution, just FYI). 5 of the cities (or 50% of the cities) are in a column called Region 1 and the remaining 50% are in...

In my sheet I import dates in the format dd-mmm-yyyy which is the english region format. My problem is that my Windows is set up to Danish region format (dd-mmm-åååå). This causes the DATEDIF() function to fail. The DATEDIF() function works if I go to the Windows region settings and change to...

Excel is not adding the North region into chart. Chart data range is =Test1!$B$5:$D$9,Test1!$F$5:$H$9 Could someone advise please?

I'm trying to create a customised dropdownlist with Validation and I'm theorising and want to know if this is possible In the red highlight box FLEALLSTAFF I'm wanting to combine all the values where Region = FLE or Region = ALL I'm trying to do this by using a For Loop and comparing each...

Hello all I have made some basic code in VBA to generate 2 pivot tables. This works :-) I have then converted the pivots to values in order to consolidate into one report. However, I want name the ranges or at the very least in the data consolidate box allow for it to pick up the current...

Hi I'm trying to import data regarding AWS pricing for London region from #000000[/URL] ]ec2instances.info website using VBA, but I always get data as if it was Northern Virginia region. I tried the following: <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Menlo...