Hi,
Could you please send me the raw data file?
Nagi
On Fri, Dec 5, 2008 at 6:44 PM, Raghuveer <[EMAIL PROTECTED]> wrote:
> Dear dev,
> I used IF condition, but it works upto only 6 or 8.
>
> I had a 100s of products and I have to pick up the rate from specified
> list.(By using vlookup function
=AND((IF(D2<35,1,0)),(IF(C2="User 1",1,0)),(IF(E2>15,1,0)))
Please paste the same to evaluate each row. If you have any query, please
feel free to discuss.
Thanks,
Nag
On Wed, Dec 3, 2008 at 5:03 PM, Aindril De <[EMAIL PROTECTED]> wrote:
> you can also use SumProduct with Logical operators
>
> O
Thanks Aditya for letting me know but this is not useful when we have 1000s
of such occurrences. Could you please suggest about it?
Nagi
On Tue, Dec 2, 2008 at 12:23 PM, aDiTyA <[EMAIL PROTECTED]> wrote:
> If you have a single column where you want such date format, than select
> that column and
Hello all,
When I am trying to write text "6-5", EXCEL automatically converting it into
"5-Jun". How can I change this setting globally. As I know, using "format"
option we can change it into required text format but this not possible if
my sheet contains thousands of such values.
Please assist me
Hi Anand,
it's really great to see your reply. Could you please forward the e-books
for statistical analysis?
Thanks,
Nag
On Tue, Nov 25, 2008 at 6:15 PM, anandydr <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> If you can provide more details on what kind of ebooks you need the
> books I send would be m
