north

I have a list of data that consists of 3 columns Col A consists of values T1-T4 Col B consists of a region name (North American, Europe, etc) Col c consists of a numeric value I need to create a formula that will rank the above based on their value within their region with all T1 values being...

Dear All, I do have a sample data-set across A1:F6 as follows:- <tbody> Region Vendor Name String Lead Time PO Count % Mix-PO Count Desired Result North James Associate NorthJames Associate 2 4 20% North James Associate NorthJames Associate 4 10 50% 4 North James Associate NorthJames...

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

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

HI I'm looking for some help with a rank issue I'm having. I need a formula that will rank based on a criteria (Area) and uses 2 tie breaks. So for example if the are 2 scores of that match in Central England then %1 would determine the highest rank, if the score and %1 match the %2 would...

Hi all, i'm working on a works project but cant get my head around a problem. in the Training, sick, working and holiday cells, where I want to count the number of staff I use the below formula, which al works well. However, when I filter the regions into Scotland or another region, the countIF...

Hello - I have a spreadsheet that has VBA to sum the final row. Range("B" & LastRow + 1).Formula = "=(SUM(B10:B" & LastRow & "))" This worked perfectly until areas of responsibility subtotals were added to the report. For example Oncology 20...

Hi, Could we use COUNTIF function of filtered data, like we use subtotal for sum and average etc., Scenario:- like I have columns Area in column A, and Sales in column B, and when I filter in column A like "north" then I want to count sales, that how many sales are greater than 500, and when...

I am trying to find unique crop rotations over 5 years. A scaled down version of what I have isA B C DJ North Corn Hay BarleyM North Hay Barley CornN North Barley Corn CornJ South Corn Corn CornM South Barley...

Hello - this site has always been a great source of help once again i am looking for VB code that will select from cell H4 out to the last column/last cell then with that selection perform two functions find null values and replace with NR copy the conditional formatting of H4 and paint brush to...