Re: $$Excel-Macros$$ Need Solution Nested If Formula

2011-02-16 Thread ashish koul
use this IF(MIN(G2:K2)=0,SMALL(G2:K2,COUNTIF(G2:K2,0)+1),MIN(G2:K2)) On Wed, Feb 16, 2011 at 2:42 PM, Vj Realsaggi realsa...@gmail.com wrote: Dear Team, Kindly go through Attached Xl, In category Column i insert nested if formula, which give me minimum Column Values comparing Sum of

Re: $$Excel-Macros$$ Need Solution Nested If Formula

2011-02-16 Thread saggi
Thanks Ashish for your reply, but it no going to solve my purpose. Plz go through the excel and see wht kind of result i am looking for. Thanks in advance -- -- Some important links for excel users: 1. Follow us

Re: $$Excel-Macros$$ Need Solution Nested If Formula

2011-02-16 Thread ashish koul
hi you wanted to change the formula for incorrect option or you wanted to mark the status correct or incorrect On Wed, Feb 16, 2011 at 5:50 PM, saggi realsa...@gmail.com wrote: Thanks Ashish for your reply, but it no going to solve my purpose. Plz go through the excel and see wht kind of

Re: $$Excel-Macros$$ Need Solution Nested If Formula

2011-02-16 Thread saggi
YES ASHISH, I WANT to chnage the formula for incorrect option.where i mention incorrect there formula picking wrong values -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and

Re: $$Excel-Macros$$ Need Solution Nested If Formula

2011-02-16 Thread ashish koul
try this On Thu, Feb 17, 2011 at 9:43 AM, saggi realsa...@gmail.com wrote: YES ASHISH, I WANT to chnage the formula for incorrect option.where i mention incorrect there formula picking wrong values -- --