Allocating workload - best function?

[hollyhillcourt]

Not sure how to perform this operation or even explain it properly so please bear with me: I have a spreadsheet with about 5500 rows of data. When the data was exported into excel, one column (F) contains employee names. Of the data in this column there are 'blank' fields where a name should be. I need to assign employee names to these blank cells to balance a workload.....how should I do this?

I created a pivot table to view more easily. There are 245 blanks. There are 18 employees.

Thoughts?

[newdoverman]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[hollyhillcourt]

[QUOTE=newdoverman;3863174]Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

Thanks. I have scrubbed the data and put the instructions on tab 1. Upload for online viewing.xlsxHope I uploaded properly....

[Farida]

Hi,
I don't think you attached file you are expecting help in! There is no data I see in D, E, F etc., as you mentioned above names in column F...

[hollyhillcourt]

Sorry - I should have clarified once that I uploaded. The above is the correct spreadsheet. The data is now in column C (I deleted the unnecessary data).....

[shg]

I don't see any blanks cells, and if I did, still wouldn't understand what the result should look like and why.

[hollyhillcourt]

THanks for the response. I am making this more difficult. So sorry for not providing more details.

I changed the blank fields to UA for unassigned.

I'm trying to figure out how to assign tech numbers existing in column C to the UA to balance the work load.

For whatever reason when the data is exported there are multiple jobs being performed but no tech assigned to them.

So I'm wondering if there is a function in excel where I can take the existing tech numbers in column C (C929:C5376) NASSVO4 - NATSV01 and apply to (C5377:5622) UA. Does that help?

[newdoverman]

I created a new worksheet, Sheet1 and copied the technician numbers into column A and then used Remove Duplicates. Then I numbered the technicians from 1 to 17 in column B.

In Customer Data!C5337 I entered this formula and copied down after changing the format from TEXT to GENERAL:

Please Login or Register  to view this content.

This spread out the remaining jobs amongst the technicians as evenly as possible.

[hollyhillcourt]

THANK YOU!!!! Makes total sense. Was making this way more complicated than I had to.

[newdoverman]

Thank you for giving feedback.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.