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
can u go more specific
Happiness keeps u sweet, trials keep u strong, sorrow keeps u human, failure keeps u humble, success keeps u glowing, but only God keeps u going
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
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))))
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Very nice Bob. I'm always in awe of your solutions.
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
Top Man
Thanks for that
Lee
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.
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
All done steve
Posting Permissions
Reply With Quote
