west

After a solution to a problem I'm having with generating a list that is populated with entries that are defined from a separate table. So I need to generate a list that looks like this <tbody> North East South South South South South West West From a table that is...

Hello, I was hoping that someone could point me in the right direction. I am decent with macros, but creating them from scratch is where I struggle. I enjoy learning how to adapt code that I find on this forum and making then work for my needs. This time, I have a situation where I have two...

I have 2 spreadsheets. I need a way to compare the entire row from sheet 1 and if that row matches any row in sheet 2 then copy all of that information to a 3rd sheet. Or if it is easier to just highlight the entire row in the 2nd sheet because it is a duplicate from the first sheet. Sheet 1...

Good Afternoon all Is there a way to utilize Sumifs with a range/Array of values. Example - Instead of entering each value select a range of cells sum(sumifs(A2:A100,B2:B100, {"West","East","South"}))) I have many more Regions, too many to type & the regions will change.

Hi all I have a reporting hierarchy which is laid out like below: <tbody> North East Sunderland A North East Sunderland B North East Newcastle C North East Newcastle D North West Preston E North West Preston F </tbody> I need a macro to convert it to the below: A B Sunderland...

I need to separate addresses that are in one cell into address,city,state,zip cells. There isn't a consistent deliminator and I can only get ad far as pulling out the state and zip. Below is a sample of the info that I need to be separated. I think I've sprouted my first grey hair from this...

I am trying to work out how to look in a cell and then look up to the top of the sheet in than column how many cells have the same value and sum the corresponding cells next to them data example below <colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody> A B C...

Hi Here I am looking to highlight (the entire row) the lowest sales by region in VBA. Thanks <tbody> ID Region Sales 100 East 1000 102 East 1100 103 East 1200 104 West 1000 105 West 1100 106 West 1200 107 North 1000 108 North 1100 109 North 1200 110 South 1000 111...

Hi Guys, Need help building a graph, here is my sample Data NAME | Region Joe | WEST Joe | WEST Joe | EAST Bill | EAST Bill | EUROPE Bill | Mid-West now I want a Graph that would show the total number on the Y axis and...

<tbody> DATE REGION LOWER: 1/14/2016 1/11/2016 WEST UPPER: 1/20/2016 1/12/2016 EAST unique values 1/13/2016 WEST REGION 1/14/2016 NORTH NORTH WEST 1/12/2016 SOUTH NORTH WEST 1/16/2016 NORTH NORTH WEST 1/17/2016 NORTH EAST WEST 1/13/2016 SOUTH WEST WEST...

Can't understand where this formula is going wrong. =SUM(SUMIFS(A:A,B:B,{"bob","tim"},C:C,{"North","West"})) If I amend all entries in col C to west it returns for tim and if I amend all to North it returns for bob. I need it to return for both bob and tim irrespective if north or west.

I have the following information: <colgroup><col><col><col><col></colgroup><tbody> Depart Time Time Zone My Time My Time Zone 7:00 AM ET FALSE CT 8:00 AM ET MT 9:15 AM ET PT </tbody> How do I get Excel to tell what time it is in my time zone? I will need this to work east to west and...