troubleshooting Question

Adapt following formula to exclude certain info from count

Avatar of MirageSF
MirageSF asked on
Microsoft ExcelMicrosoft Office
3 Comments1 Solution86 ViewsLast Modified:
=RANK(D1,DATES,1)+COUNTIFS(DATES,D1,NAMES,"<"&B1)


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
ASKER CERTIFIED SOLUTION
Ejgil Hedegaard

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros