I want to find the lowest positive integer in a list of values in Excel 2002 on Windows XP.
the MIN function returns the lowest integer but does not add the constraint that it has to be positive.
for. eg. (43, 23, 11, -54, 33) should return 11 as the answer.
could you please answer how this can be solved without using special Add-Ins.
Thank you
2007-09-13 01:06:52 · 6 answers · asked by Diabolic Preacher 3 in Computers & Internet ➔ Software
nopes not homework.
a PG course like MCA doesn't expect homework assignments like these.
actually a lot of people will be thankful since the answers are publicly searchable. so even beside me, there could be many more who might benefit from it. and what's so wrong in asking here?
2007-09-13 01:30:03 · update #1
If your numbers are in columns A1 to A5, use this formula:
=IF(MAX(A1:A5)<=0,"NA",LARGE (A1:A5,COUNTIF(A1:A5,">0")))
Please remove the space between the "LARGE" and the "(" in the formula - without the space the display in Yahoo! answers was cut off as:
=IF(MAX(A1:A5)<=0,"NA",LARGE(A1:A5,COUNTIF(A1:A5,">0")))
2007-09-13 02:01:07 · answer #1 · answered by Anonymous · 1⤊ 0⤋
Here is an array formula
=MIN (IF (R36:R40>0,IF ( MOD (R36:R40,1)=0,R36:R40) ) )
Where
R36:R40 = your data range.
When confirming the formula (Enter=OK), press Shift+ctrl+Enter all keys together instead of just "Enter".
2007-09-13 06:27:34 · answer #2 · answered by voyager 6 · 1⤊ 0⤋
Check here..
http://office.microsoft.com/en-us/sharepointserver/HA101054681033.aspx
http://www.osirra.com/category/1/16
http://64.233.169.104/search?q=cache:u84AVXU-D5kJ:www.grbps.com/Excel7.pdf+find+lowest+positive+integer+in+a+list+of+values+excel&hl=en&ct=clnk&cd=6&gl=us&client=firefox-a
http://www.exceltip.com/se/functions.html
Do rate me if it hepled ya...
2007-09-13 03:17:54 · answer #3 · answered by Sridhar G 6 · 0⤊ 3⤋
So you want us to do your Homework.
2007-09-13 01:12:07 · answer #4 · answered by Don M 7 · 0⤊ 4⤋
I've got it!!Ü
2007-09-17 22:17:25 · answer #5 · answered by i a 4 · 0⤊ 3⤋
no idea
2007-09-13 01:50:09 · answer #6 · answered by Anonymous · 0⤊ 4⤋