I'm really hoping someone can help with a formula I need to return the site address, but it needs to be the top 5 highest KWH sites for a specific managers name and his open sites.
I feel like I've tried everything and am getting nowhere.
Column A is Site names
Column C is Managers names
Column D is Open/closed
Column E is KWH
Thank you loads
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…