Hi, Please can someone help me. i am creating a spread sheet that automatically shares work load between 3 people.
i have two types of work work "FISH" AND "DOG"
I receive a list of 30 jobs a day for example FISH,FISH,DOG,DOG,FISH,DOG,FISH,FISH,FISH,DOG,DOG
i paste this work load into column A. 3 staff work down the list. one of the staff could always end up with Job DOG. IS there away to sort the data so DOG is split across all 3, so add/sort into a sequence Dog,fish,dog,fish,dog,fish,dog,fish
FISH
DOG
DOG
FISH
FISH
DOG
FISH
I hope that makes sense, how do i sort the data into a certain sequence
i have two types of work work "FISH" AND "DOG"
I receive a list of 30 jobs a day for example FISH,FISH,DOG,DOG,FISH,DOG,FISH,FISH,FISH,DOG,DOG
i paste this work load into column A. 3 staff work down the list. one of the staff could always end up with Job DOG. IS there away to sort the data so DOG is split across all 3, so add/sort into a sequence Dog,fish,dog,fish,dog,fish,dog,fish
FISH
DOG
DOG
FISH
FISH
DOG
FISH
I hope that makes sense, how do i sort the data into a certain sequence