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
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
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
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
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
--
--