try this
On Thu, Feb 17, 2011 at 9:43 AM, saggi wrote:
> YES ASHISH, I WANT to chnage the formula for incorrect
> option.where i mention incorrect there formula picking wrong values
>
> --
>
> --
> Some important
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 li
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 wrote:
>
> 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
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 on
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 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 Quantity " To 5 o
