Max value with min collect
I know this is need of a combination of things, but I cant figure it out unless I use a range of cells. I would prefer to search the collective column to perform the task.
I want to return the name of the Visit Provider who has the greatest number of SumCompSched for each Phase & Clinic.
I appreciate the help in advance.
Help Article Resources
Check out the Formula Handbook template!