I am ranking (column AH) the points for a group of members based on if they meet all percentages greater than or equal 100. My problem is when the point total (column AG) for a non-qualified member is greater than the qualified member. I cannot figure out how to exclude the non-qualified member from the formula. I've attached my spreadsheet and my formula is:
Got it. I played with it and came across an issue if there is a tie. I would like to break the tie based on the point with the larger amount in column J. Can you help?
Thank you both!! I really liked the VBA usage and can use it in other spreadsheets. Subodh, thank you for your efforts too and making me think differently.