Hi All,
Can anyone help me on this by using index function.
I have a drop down where i click on the required and i need to get the
subset details of those drop down
Thanks
Prasad
--
--
Some important links for
Dear Surya,
Please see attached sheet
--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/
On Mon, Oct 17, 2011 at 4:54 PM, suryaprasad.bv
You can tie to a worksheet_change event in the sheet module. More info
and/or share a file
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: ajjw123
Sent: Sunday, October 16, 2011 8:14 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ auto complete
Please share your worksheet with us.
On Mon, Oct 17, 2011 at 6:44 AM, ajjw123 ajjw...@gmail.com wrote:
can anybody help me with auto complete feature incorporation in drop
down list or in a combo box.thanks
--
Hello,
I have a pivot table which is dynamic which is going to be change
every time when i open the workbook
i want to get the unique value from pivot table field in combo box add
item.
lets example :
my pivot table field is Agent name there are several agent who work
repetedly till 4 rows
Hi Noorain,
Could you plz make me understand how has it been done?
Thanks
Regards,
Ankit
On Mon, Oct 17, 2011 at 5:27 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Surya,
Please see attached sheet
--
Thanks regards,
Noorain Ansari
Hi Excel Group Members,
I was hoping if anyone can share project feasibility report (sample)
specifically for real estate in Indian Context. I have to work on
feasibility study of a township project.
This may carry following details -
1. Profitability Statement (Feasibility)
2. Cash Inflow /
I'm trying to determine if a specific date falls between a start and
end date. For example:
A1: 9/7/2011
B1: 9/28/2011
C1: 11/2/2011
If A1 is between B1 and C1, then return a 1 if not, then return a
zero.
Seems like it would be easy, but been scratching my head on this too
long.
Thanks!
Since you have only specified between B1, and C1, and not whether B1 will
always be lesser than C1, here's a generic formula.
=IF(AND(A1=MIN(B1,C1),A1=MAX(B1,C1)),1,0)
Regards,
Sam Mathai Chacko
On Mon, Oct 17, 2011 at 8:38 PM, RockyFontane vtorral...@gmail.com wrote:
I'm trying to determine
Hi
Try this
=if(and(a1b1,a1c1),a1,0)
Thanks and Regards,
Somnath C Pardeshi
Sent from my BlackBerry® Smartphone on Loop Mobile.
-Original Message-
From: RockyFontane vtorral...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Mon, 17 Oct 2011 08:08:40
To: MS EXCEL AND VBA
Hi All,
I have three different dates in a Column A , suppose say in Col A i have A1
as 1- Dec -2010, A2 as 11- Jan-2011,A3 as 1- Mar -2011 then i need a count
of number days as *3* in the cell A4 any idea?
Thanks
Prasad.
--
Dear Ankit,
Please see attached sheet with explain
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/
On Mon, Oct 17, 2011 at 7:06 PM, Ankit Agrawal
Unless I'm mistaken, is this what you are looking for?
=COUNT(A1:A3)
Regards,
Sam Mathai Chacko (GL)
On Mon, Oct 17, 2011 at 8:50 PM, Mr Excellent suryaprasad...@gmail.comwrote:
Hi All,
I have three different dates in a Column A , suppose say in Col A i have A1
as 1- Dec -2010, A2 as 11-
try
=if(and(a1=b1,a1c1),1,)
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: RockyFontane
Sent: Monday, October 17, 2011 10:08 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Quick Date Count Question
I'm trying to determine if a specific date
Dear Surya,
SAM is right
but If you want to Count only Date
Please try it and see attached sheet..i hope it will help to u
Function Countonly_date(rng As Range)
For Each abc In rng
If IsDate(abc) Then
Countonly_date = Countonly_date +
Dear Jay,
Please try through below link.
http://www.straxx.com/excel/password.html
--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/
On Mon, Oct 17, 2011 at
That will only open the sheet / workbook password Noorain :)
On Mon, Oct 17, 2011 at 9:29 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Jay,
Please try through below link.
http://www.straxx.com/excel/password.html
--
Thanks regards,
Noorain Ansari
Hello,
I have a pivot table which is dynamic which is going to be change
every time when i open the workbook
i want to get the unique value from pivot table field in combo box
add
item.
lets example :
my pivot table field is Agent name there are several agent who work
repetedly till 4
Hi
I have a 2 cells in a row that I want to copy into a named range (say
'serialNo') also only 2 columns.
Do I have to do the vba xcell up routine ? or should I be able to paste
into 'serialno' and it will go into next available row. I have tried
recording copy/paste, select 'serialno' but
Hi Sam
Works very well. Thankyou Sam and Don for your inputs.
REgards
Charlie
On Sun, Oct 16, 2011 at 9:55 PM, Sam Mathai Chacko samde...@gmail.comwrote:
I don't necessarily support this alternative, and I don't think it is
popular among the old schools either, but it is effective
please attach example file
2011/10/17 Cab Boose swch...@gmail.com
Hi
I have a 2 cells in a row that I want to copy into a named range (say
'serialNo') also only 2 columns.
Do I have to do the vba xcell up routine ? or should I be able to paste
into 'serialno' and it will go into next
If you have a defined name range such as myrng defined using this, then if you
drag to col A it will extend the named range to accommodate the new data.
assumes numbers. If numbers in col A, use 99 or any number greater than you
might use
Hi,
http://datapigtechnologies.com/blog/index.php/recordset-tricks-in-excel-1-filling-a-combobox-with-unique-values/
Hope these link help u better.
On Mon, Oct 17, 2011 at 11:03 PM, ICWAI Help icwai.answ...@gmail.comwrote:
Hello,
I have a pivot table which is dynamic which is going to be
Hi Don and ChilExcel
Thanks for info. Don like earlier I have not put enough info. I should learn
from this.
See attached workbook with comments.
Thanks, apologies and regards
Charlie Harris
On Tue, Oct 18, 2011 at 12:29 PM, dguillett1 dguille...@gmail.com wrote:
If you have a defined name
Here's an accurate list.
Regards,
Sam Mathai Chacko (GL)
On Mon, Oct 17, 2011 at 8:53 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Ankit,
Please see attached sheet with explain
Thanks regards,
Noorain Ansari
Hello Surya;
If your data is sorted by Country in Ascending order, use the file
sorted_by_Country. The other one will work with sorted or unsorted data.
Also used dynamic range.
HTH
Haseeb
--
--
Some important
**
* *
*
Hi Friends,
Hope you are doing well today.
Please find the job description below and send me the updated resume at
ASAP. Here is an Immediate interview for the position.
(Please send resumes to vi...@addonusa.com)
Name:
Contact:
E-Mail:
Location:
Re-Location:
Visa:
Hi
I am xavier, new to this group. Please help me in conditional
formatting i use excel 2003 and it does not allow more than 3
conditions. Someone can help please
Many Thanks
Xavier
--
--
Some important links for
Dear Sirs,
Please provide me sumproduct functions sheet which having different example
in it.
@Noorain Ansari sir, Looking your help also.
Thanks Regards,
Ankit
--
--
Some important links for excel users:
1.
http://chandoo.org/wp/2008/10/14/more-than-3-conditional-formats-in-excel/
http://en.kioskea.net/forum/affich-21716-conditional-formatting-more-than-3-in-excel
On Tue, Oct 18, 2011 at 9:04 AM, Kuts xavierj...@gmail.com wrote:
Hi
I am xavier, new to this group. Please help me in conditional
30 matches
Mail list logo