# assignments

1. ### Sum if based on horizontal and vertical criteria

Hi All - any help with this issue would be greatly appreciated. I have a sheet where I make work assignments (including budgeted hours) to each employee by task by day. There can be multiple assignments and employees on any given day. The sheet outlines all assignments for a year and looks...
2. ### Create an Assignment Schedule/Plan

I would appreciate any help to create a mechanism to distribute assignments to a group of people. 10 People 22 Assignments (same assignments monthly but not repeated by any one person until has done all 22) 10 instances of each (same) assignment to be done by each person OK that people be...
3. ### Match a person's name to multiple states

always feels good to come back to Mr. Excel, feels like I'm learning something new. Anyways, I have a master sheet of accounts with a state they are located in. On another sheet I have an engineer assigned and multiple states they will cover for those accounts. Sheet 1 Company A, CA, insert...
4. ### how comparing dynamic arrays and use items from an array to fill a spreadsheet

this is a wee bit complicated so I have included the code I have already and commented all of it which hopefully will explain what I am trying to achive. I have also included examples of the worksheets I am using, the "final assignments" worksheet I have included one which is essentially "blank"...
5. ### assignments and solutions

Hi Do you know where I can find a website/files etc which has assignments and solution in different subject, school/college style? for practicing purpose. ExcelsFun has assignments but not for education purpose and I can not find what is the question is. Thank you.
6. ### If Statement Formula with 1st Character as the determining factor

i need a formula to assign a person to an assignment depending on the first letter of the customer's last name Ticket # Customer Name Employee Assignment 123 Doe, Jon 124 Smith, Robert Above is a simple version, but...
7. ### Clustering in groups, is it even possible?

Hallo :smile: I have a question about clustering in excel and I don't even know if it is even possible doing it (in excel). I will give a simple example: There are 4 teachers and 4 assignments. Everyone indicated if he/she has the right expertise to evaluate a certain assignment with (YES)...

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back