Hi,
Since you have xl2007, try:
=COUNTIFS(A2:A100,">1/4/2010",B2:B100,"<>Jumpstart")
Regards - Dave
From: asheeshinsura...@gmail.com
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Kndly Solve my Problem
Date: Sun, 2 May 2010 08:47:21 +0530
Dear All,
Please help,
Dear All,
Please help,
In column A:A dates are there
In column B:B Condition are there
In column C:C Clubbing of the two is there
Now I want to countif() who had cleared jumpstart >=01-04-2010
Asheesh Arora
--
--
Hi Vijay,
Please try the following option:
File--> Permissions --> Do Not Distribute... Once you try this option, excel
will prompt you to download IRM (Information Rights Management) helps
preventing sensitive documents from being forwarded or copied
by unauthorized persons.
However, you can do
You're welcome. I have found the Contextures site very helpful for lots of
tasks.
Regards - Dave.
Date: Sat, 1 May 2010 06:11:26 -0500
Subject: Re: $$Excel-Macros$$ Using an "if" formula in data validation
From: tanner@gmail.com
To: excel-macros@googlegroups.com
Dave, thank you very muc
Hi karthikeyan
Before you adding the column code Field:=3, Criteria1:="=100"
it will filter Column C where Amount it equal to 100
but when you add the column between A & B your Amount column will shift to
column D
this time code will be Field:=4, Criteria1:="=100"
On Sat, May 1, 2010 at 1:21 PM,
Thanxs dear.,
i 'll try this , if i will tell u if i get nay problem
thanxs
god bless u
On Sat, May 1, 2010 at 9:35 AM, Harpreet Singh Gujral <
harpreetguj...@gmail.com> wrote:
> Sudhir,
>
> I am sorry, but i did not get your point.
>
> Even if you add a row in between the data, it will analyse d
Dave, thank you very much. Great instructions at contextures.
On Fri, Apr 30, 2010 at 4:53 PM, LJWarren wrote:
> I have 5 major categories defined, and depending on which category is
> chosen, up to 20 sub-categories. How do I embed an "if" statement into
> my data validation? Thank you.
>
> --
Hi,
Try this address:
http://www.contextures.com/tiptech.html
Then go to Data Validation, dependent drop-downs. There are several methods.
Regards - Dave
_
If It Exists, You'll Find it on
Hi All,
I have create a filter through macro.Crietiria=100,Filed=3
Example:-
col-"A" col-"B" col-"C"
NameId Amt
X 1 100
Y 2 200
Z
hi priyan,,,aamir here,,
priyan,
I recently downloaded this file encrpytion program :
http://priyanr.somee.com/downloads/folderprotect.zip
It was working good until a few weeks later when suddenly all my locked
folders changed into a control panel icon.
Usually to unlock it, i would just have to
Hi,
Plz share a sample file.
Regards,
Deepak
On Sat, May 1, 2010 at 3:23 AM, LJWarren wrote:
> I have 5 major categories defined, and depending on which category is
> chosen, up to 20 sub-categories. How do I embed an "if" statement into
> my data validation? Thank you.
>
> --
>
> ---
Sudhir,
I am sorry, but i did not get your point.
Even if you add a row in between the data, it will analyse data upto
Row 200/ or more if you plan to do so
One presumption is that the data will not be repeated i.e. Compartment
Name will not repeat.
Let me know, if you face further problems
Ha
12 matches
Mail list logo
