View Full Version : Solved: MIN formula
lee2boy
02-26-2010, 05:29 PM
Chaps, can any body help with a formula, I have tried all sorts,
I'm trying to record in a cell the smallest cash figure for a number of cells in a row
i.e
a2, f2, g2 i2, k2 ,m2 etc,
but the cells may contain a zero or be blank
thanks if any body can help
Regards,
Lee
krishhi
02-26-2010, 09:28 PM
can u go more specific
lee2boy
02-27-2010, 02:48 AM
I'll try,
If cell a2 has £1.50 in it and if cell f2 is not filled in and if g2 has £163.00 and if i2 has 90p and if k2 is 0 and m2 has £6.00 i wish to record in another cell the lowest value which is i2 with 90p, but not the 0 in k2 or get a false due to f2 not being filled in .
Hope that makes sence
Thanks
Lee
Bob Phillips
02-27-2010, 02:52 AM
Try this ARRAY formula
=MIN(IF(N(OFFSET(A2,0,{0,5,6,8,10,12},1,1))<>0,N(OFFSET(A2,0,{0,5,6,8,10,12},1,1))))
lucas
02-27-2010, 10:01 AM
Very nice Bob. I'm always in awe of your solutions.
lee2boy
02-27-2010, 01:40 PM
Top Man
Thanks for that
Lee
lucas
02-27-2010, 01:59 PM
Lee, be sure to mark your thread solved using the thread tools at the top of the page.
That prevents members from reading the entire thread just to find it's been solved.
lee2boy
02-27-2010, 02:03 PM
All done steve
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.