How can you find the last "P" on a line, without an Array formula or Code? (Excel 2000)
JA Regional Rosters work in progress.xls | |||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | |||
1 | Names | Hours | 8:30AM | 8:45AM | 9:00AM | 9:15AM | 9:30AM | 9:45AM | 10:00AM | 10:15AM | 10:30AM | 10:45AM | 11:00AM | 11:15AM | 11:30AM | 11:45AM | 12:00PM | 12:15PM | 12:30PM | 12:45PM | 1:00PM | 1:15PM | 1:30PM | 1:45PM | 2:00PM | ||
2 | Tom | 900-530 | P | P | P | P | P | L | L | P | P | B1 | P | P | C | C | P | P | P | P | C | C | C | ||||
3 | **** | 0 | p | p | p | p | p | L | L | L | c | c | c | B1 | c | c | |||||||||||
4 | Harry | 900-500 | p | p | p | B1 | L | L | L | c | c | ||||||||||||||||
5 | Fred | 900-500 | |||||||||||||||||||||||||
WEEK 1 |