UncleBajubjubs
Board Regular
- Joined
- Jul 11, 2017
- Messages
- 111
- Office Version
- 2010
Hello, I am looking for a formula to add 100% of the largest number or sets of that number with 50% of the second largest number or sets of that number.
For instance, the following numbers may be in cells
12
35
14
14
6
14
So the formula will first see 35 is the biggest number, and there is only one of it, and then it will see there are three 14s, the second biggest number. So it will take 100% of the largest number or set of the largest number (there is one 35, so 35) and add it to 50% of the second largest number or set of the second largest number (there are three 14s, so 50% of 14*3=21) so it will output 56 (35+21). I hope I explained that well enough, thanks!
For instance, the following numbers may be in cells
12
35
14
14
6
14
So the formula will first see 35 is the biggest number, and there is only one of it, and then it will see there are three 14s, the second biggest number. So it will take 100% of the largest number or set of the largest number (there is one 35, so 35) and add it to 50% of the second largest number or set of the second largest number (there are three 14s, so 50% of 14*3=21) so it will output 56 (35+21). I hope I explained that well enough, thanks!
