Q
QuantumPion
I need a function that will sum the n largest values in an array, where
the values are less then x and are not #N/A, meet a criteria in a
seperate array, and where the total of the sum is less then or equal to
y. How can I do this? Thanks.
For example, here is my data:
Code:
--------------------
name type value
alpha g 1
bravo 5
charlie g 2
delta g #N/A
echo 3
foxtrot g 7
--------------------
I want a function that will find the sum of the largest two values that
are "g" that add to 8 or less. So the output would look like:
Code:
--------------------
name value
alpha 1
charlie 2
sum: 3
the values are less then x and are not #N/A, meet a criteria in a
seperate array, and where the total of the sum is less then or equal to
y. How can I do this? Thanks.
For example, here is my data:
Code:
--------------------
name type value
alpha g 1
bravo 5
charlie g 2
delta g #N/A
echo 3
foxtrot g 7
--------------------
I want a function that will find the sum of the largest two values that
are "g" that add to 8 or less. So the output would look like:
Code:
--------------------
name value
alpha 1
charlie 2
sum: 3