Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Find min value 1
- Thread starter ersatz
- Start date
DaleWatson123321
Programmer
You didn't mention the type of array.
If your array is in a range of cells, then you could simply use the =MIN function.
If your array is an "array constant" - i.e. NOT in cells, then I'm sure others can help. I don't happen to be "up" on the use of array constants.
Hope this helps.
Please advise as to how you make out.
Regards, ...Dale Watson dwatson@bsi.gov.mb.ca
If your array is in a range of cells, then you could simply use the =MIN function.
If your array is an "array constant" - i.e. NOT in cells, then I'm sure others can help. I don't happen to be "up" on the use of array constants.
Hope this helps.
Please advise as to how you make out.Regards, ...Dale Watson dwatson@bsi.gov.mb.ca
function MinArrVal()
minVal = arrayName(0)
for i = 0 to ubound(arrayName())
if arrayName(i)<minVal then
minVal = arrayName(i)
else
end if
next i
MinarrVal = minVal
end function
Your array would need to be "Public" for this to work as a function Rgds
~Geoff~
minVal = arrayName(0)
for i = 0 to ubound(arrayName())
if arrayName(i)<minVal then
minVal = arrayName(i)
else
end if
next i
MinarrVal = minVal
end function
Your array would need to be "Public" for this to work as a function Rgds
~Geoff~
-
1
- Thread starter
- #4
DaleWatson123321
Programmer
ersatz,
Pssssssssssssssst. ...the "proper" way of showing appreciation to Geoff, is to "award him a STAR".
This is done by simply clicking on the "*Mark this post as a helpful/expert post!" - located in the lower-left-corner of the contributor's posting.
Being relatively new to Tek-Tips, I'm sure you weren't yet aware of this accepted method of showing appreciation.
Regards, ...Dale Watson dwatson@bsi.gov.mb.ca
Pssssssssssssssst. ...the "proper" way of showing appreciation to Geoff, is to "award him a STAR".
This is done by simply clicking on the "*Mark this post as a helpful/expert post!" - located in the lower-left-corner of the contributor's posting.
Being relatively new to Tek-Tips, I'm sure you weren't yet aware of this accepted method of showing appreciation.
Regards, ...Dale Watson dwatson@bsi.gov.mb.ca
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
