ChetShannon
Board Regular
- Joined
- Jul 27, 2007
- Messages
- 133
- Office Version
- 365
- Platform
- Windows
Anyone know how to create a formula for the kth largest element of say two different ranges? Preferably done via an Excel formula instead of VBA? In other words I have two ranges and I want to find the k-th largest element between those two ranges. I don't think the LARGE command will allow more than one range to my knowledge.
Thanks! Chet
Thanks! Chet