Reply to thread

Message: [QUOTE="Steve, post: 3799503"] Not a very good subject wording, but.... I currently have 14 postitions (days off), sorted by seniority[top Sat/Sun thru Tue/Wed]. - Current. I only need 9 [the bottom Sat/Sun thru Tue/Wed] - Proposed I want formulas in the Q col to indicate 4 different texts. Being that the top group is in seniority order, I want the upper group Q formulas to look at the lower days off, then starting at the top of the upper group, if it found a matching day off, return "match". In this first case, the Sat/Sun. Being that there is only one Sat/Sun in the below group, I want the 2nd Sat/Sun in the upper group to return "mismatch", etc. etc. I also need anything below the count of 9- in current- to result in "excess' if they don't match the proposed need, and "excess match" if they do match the proposed need. The upper Q column shows how all the results should be. I hope I explained the ok. Current P Q Sat/Sun Match Sat/Sun Mismatch Sun/Mon Match Sun/Mon Match Sun/Mon Mismatch Thu/Fri Match Thu/Fri Match Thu/Fri Match Tue/Wed Match Tue/Wed Excess-Match Tue/Wed Excess-Match Tue/Wed Excess Tue/Wed Excess Tue/Wed Excess Proposed Sat/Sun Sun/Mon Sun/Mon Thu/Fri Thu/Fri Thu/Fri Tue/Wed Tue/Wed Tue/Wed Thanks, Steve [/QUOTE]