3 registered members (Edinburgh, Stuart, RichG),
206
guests, and 4
spiders. |
Key:
Admin,
Global Mod,
Mod
|
|
Forums69
Topics113,624
Posts1,341,354
Members1,807
|
Most Online731 Jan 14th, 2020
|
|
|
Re: Excel help request
[Re: srm6]
#1503448
18/08/2014 09:55
18/08/2014 09:55
|
Joined: Dec 2005
Posts: 12,546 Northumberland
AndrewR
I AM a Coop
|
I AM a Coop
Joined: Dec 2005
Posts: 12,546
Northumberland
|
If your range is, say, A1:A10 then:
=MIN(IF(IFERROR(A1:A10,0)>0,A1:A10))
Has to be entered using Ctrl-Shift-Enter, not just Enter and you have to be on Excel 2007 or later.
Dear monos, a secret truth.
|
|
|
Re: Excel help request
[Re: srm6]
#1503491
18/08/2014 15:18
18/08/2014 15:18
|
Joined: Dec 2005
Posts: 12,546 Northumberland
AndrewR
I AM a Coop
|
I AM a Coop
Joined: Dec 2005
Posts: 12,546
Northumberland
|
There is a non-array way of doing it:
=SMALL(A1:A10,COUNTIF(A1:A10,0)+1)
But it throws an error if any of the cells contain an error or if none of the cells are >0.
Dear monos, a secret truth.
|
|
|
Re: Excel help request
[Re: srm6]
#1503615
19/08/2014 10:50
19/08/2014 10:50
|
Joined: Dec 2005
Posts: 12,546 Northumberland
AndrewR
I AM a Coop
|
I AM a Coop
Joined: Dec 2005
Posts: 12,546
Northumberland
|
I've been checking in here every once in a while, but there don't seem to have been many fights debates for me to take part in.
Anyway, I'm down with the kids now - so if anybody wants to know what I'm up to I'd recommend checking out my brilliant and witty Twitter feed - @excelpope
Dear monos, a secret truth.
|
|
|
|