B1 - B100 = NAMES OF PEOPLE (RANGE IS NAMED AS NAMES)
D1 - D100 = DAYS THEY STARTED (RANGE IS NAMED AS DATES)
Formula above ranks them in order 1- 100, and if they started on the same day then it will rank the one whose surname is first.
It works great...
However I now need to modify it so it looks at Column N (Named as MODE) if this mode contains A or B then we RANK them, if its anything else then its not included.
But I tried lots of ways and cannot get it to work, any ideas? Thanx