Formula populates correct info on original sheet & incorrect info on duplicate 2nd sheet.

if you click on sequoia and look in the formula starting in column "W" you can see it is simply a formula for populated names alphabetized by last name. This has worked for me countless times before however now it seems to mess up if there are not enough values to fill the entire array I have specified - for picking up all names associated with the letter "S" in column "R" on the "Census Sheet", and it works perfectly...as long as there are six names to fill in the array that I specify in the formula - "U2:U9" and "V2:V9". I need the formula to cover those 8 cells because that station "Sequoia" can have up to 8 patients, and I want them to always be alphabetized. You can see there are not 8 patients so the formula decides to populate "Car Bumper" twice. How can I get it to not do this?

round2forum3.xlsm

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Thanks for the title change