Hello,
I am trying and not succeeding with this case.. need your help please
I am generating calculator for PV plant and I need to make inverter selection according to calculated power.
For example, if calculated power is 75,1 kW, I need to find two different size inverters that would be closest to that 75,1 value. But those found values has to be maximum values.
I have such inverter sizes:
10
12
15
17
20
30
36
40
50
My goal is to find nearest values to 75,1. So in this case it would be 50 and 20. It would be not good if excel suggest to chose lot of smaller values.. And I do not need to sum them. Those found values should be somewhere in other sheet, in separate cells, or in the same sheet but marked with X or something.
Maybe anyone has similar example or could explain how could I reach that functionallity?
WOuld aprecciate any help.
Thanks in advance