whats the easiest way to get the data (which is pulled in from 2 other workbooks) into regional tabs ?
SO from the table below if the region column = 'Auckland' then move the entire row to the Auckland tab and so forth for all the other regional tabs.
once the data is in the regions i...
Im working in Excel 2016. I am looking to find out if it is possible to designate different sum ranges for one specific criteria in a sumproduct formula while the rest of the conditions apply to both.
I have a datasheet and i want result in second sheet based on week numbers.
Main columns are as i mentioned below,
week numbers (Weeknum)
status (In-process, ready to ship, shipped)
in second sheet using same columns and i want...
Alright guys, I feel a bit embarrased to ask help for conditional formating, but I have tried and tried to make this work out myself but I cant accomplish anything. I am just stuck.
I need to do some multiple condition formating here. I have categories which take part of a material inventory...
I am currently struggling to set up a macro to transpose arrays of records based on conditions.
I am quite new to VBA, so any tips and advice on how best to achieve this will be very much appreciated.
Below is the format of my 'raw' data in Excel (Version 16.0.6741.2056)
The below is not so simple as you may think of.
Here is example of table. Initial has 80K of records and many columns.
-- removed inline image ---
I would like to sumporduct to count items from table but is not standard easy sumproduct I want.
Basically I want to sumproduct to count 4...
Hi...I need help on how to accomplish this problem. The array formula
SUM(IF(FREQUENCY(IF(D14:D26 >= 90,MATCH(C14:C26,C14:C26,0)),ROW(C14:C26)-ROW(C15)+1),1)) only works for 1 condition but for multiple conditions like if the Training Index is <=89.99 and >=80, it doesn't work.
In my second...
Hi, I need a field (DepField) that depends on seven other fields (Let's say the fields are named 1-7). All fields (including the dependent field can be either "Red", "Yellow" or "Green"
There are different conditions for the dependent field (DepField):
If either field: 1, 3 or 4 = "Red", then...
HELLO Excel Experts!
Goal = Return a value "0" if cell value is blank or "1" if value matches same one on other sheet.
I feel I'm close but can't figure this out. I think I need if statement to set conditions of "1" TRUE or "0" FALSE & vlookup to match values on two different worksheets. I...
Objective: To have no more of 10 specialties per name. The 10 specialties must be the same each time I run it even if there is an introduction of a new specialty next time I run it. Whatever is greater than 10 specialties with the same name should have it's entire row deleted.
Problem: I have...
This is the issue I have ( I am calculating school grades)
Originally I wanted to use only the 1st character in a cell to make a calculation so for example rather than using "A+" or "A-" I used "A". The foruma for this =LEFT(A1,1)
However I now realise that I need to make calculations...