this is correct
On 5/15/09, JAYAVELU SUN wrote:
>
>
> =COUNTIF(C8:C66,C8)
>
> this is correct formula
>
>
> jayavelu
>
> On 5/14/09, Kshitij wrote:
> >
> > =COUNTIF(C8,C8:C66)
> >
> >
> > >
> >
>
> >
>
--~--~-~--~~~---~--~~
---
=COUNTIF(C8:C66,C8)
this is correct formula
jayavelu
On 5/14/09, Kshitij wrote:
>
> =COUNTIF(C8,C8:C66)
>
>
> >
>
--~--~-~--~~~---~--~~
-
Some important links for excel users:
=COUNTIF(C8,C8:C66)
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2
ly, the result if the condition is met: 1
Thirdly, the result if the condition is not met: 0
Hope this helps.
Regard - Dave.
Date: Wed, 29 Apr 2009 23:24:02 +0100
Subject: $$Excel-Macros$$ Re: !!URGENT!! Formula Required Please HELP
From: rogergov...@googlemail.com
To: excel-macros@googlegr
Hi
The formula is saying
If the value in cell C8 is not equal to the value in cell C7, then return
the value of 1, otherwise, return the value of 0.
Regards
Roger Govier
Microsoft Excel MVP
2009/4/27 Ahmedhonest
> Dear Fabio Lemos,
>
> I appreciate your solution to the Query but may i know the
Hi Mayank Patel
pl find attach solution file which is what you expect
let me know
S. Jayavelu
9941260857
On Mon, Apr 27, 2009 at 6:54 PM, Mayank Patel wrote:
> Dear Friends
>
> Please suggest the formula.
> sample file is attached.
>
> Thanks to all in Advance
>
>
>
> Regards
> Mayank
Dear Aindril,
Thanks for ur help,
but this formula is not giving desired result. please try again.
Thanks Again
Regards
Mayank Patel
ITC LTD
9822978041
9422749110
On Tue, Apr 28, 2009 at 8:55 AM, Aindril De wrote:
> Dear Mayank,
>
> You seemed to be almost on track with the formula you had wr
Really Good
shrinivas
Date: Mon, 27 Apr 2009 20:28:26 +0530
Subject: $$Excel-Macros$$ Re: !!URGENT!! Formula Required Please HELP
From: harmeet.hew...@gmail.com
To: excel-macros@googlegroups.com
CC: mkpat...@gmail.com
It was a nice query...
See attached file it has the solution
Hi,
Check the attached formula this works only if the Sub Cat is sorted
Regards
Sathish Jalendran
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Mayank Patel
Sent: 27 April 2009 06:54 pm
To: excel-macros@googlegroups.com
Subject: $$Excel-Ma
Dear Mayank,
You seemed to be almost on track with the formula you had written, however
you have to add the trick of finding duplicates on the same formula.
I have updated the formula and it seems to be working properly now.
=IF(OR(OR(AND(C8=C9,C8<>C7),AND(C8<>C9,C8<>C7)),OR(COUNTIF($B$8:B8,B8)=
Dear Friends,
I Sincerely appreciate your suggestions. But i think in both the solutions
in column C is taken in to consideration Nowhere Data in the column B is
considered. My problem is little complicated. it is not necessary that the
same values will come next to each other, and i want the resu
Dear Fabio Lemos,
I appreciate your solution to the Query but may i know the logic of this
formula how it works plzzz
*=IF(C8<>C7,1,0) <- Explain this plz*
Regards
Ahmed
On Mon, Apr 27, 2009 at 4:31 PM, Fabio Lemos wrote:
> Hi,
> You can use:
>
> =IF(C8<>C7,1,0)
>
> regar
It was a nice query...
See attached file it has the solution...
On Mon, Apr 27, 2009 at 7:01 PM, Fabio Lemos wrote:
> Hi,
> You can use:
>
> =IF(C8<>C7,1,0)
>
> regards!
>
> 2009/4/27 Mayank Patel
>
>> Dear Friends
>>
>> Please suggest the formula.
>> sample file is attached.
>>
>> Tha
Hi,
You can use:
=IF(C8<>C7,1,0)
regards!
2009/4/27 Mayank Patel
> Dear Friends
>
> Please suggest the formula.
> sample file is attached.
>
> Thanks to all in Advance
>
>
>
> Regards
> Mayank Patel
> ITC LTD
> 9822978041
> 9422749110
>
> >
>
--
Fabio L Lemos
email: flnle...@gmail.com
--~
14 matches
Mail list logo
