How to return min value, but only values>1 ?
|
=MIN(values)*(MIN(values)1)
"P" wrote: |
Eg: If your range of values is A1:A7 then you could type the following
formula into a cell and press CTRL+SHIFT+ENTER to get the correct result. =MIN(IF(A1:A71,A1:A7)) "P" wrote: |
=MIN(IF(A1:A101,A1:A10))
which is an array formula, so commit with Ctrl-Shift-Enter -- HTH RP (remove nothere from the email address if mailing direct) "P" wrote in message ... |
All times are GMT +1. The time now is 01:18 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com