Re: $$Excel-Macros$$ Sum Product Sheet

Hi, Please find some more example on sum product. Regards Chethan Kumar BN On Tue, Oct 18, 2011 at 10:59 AM, ashish koul wrote: > http://www.bygsoftware.com/Excel/functions/sumproduct.htm > > http://chandoo.org/wp/2009/11/10/excel-sumproduct-formula/ > > http://www.exceluser.com/explore/sumpro

Re: $$Excel-Macros$$ conditional formatting- more than 3

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 wrote: > Hi > > I am xavier, new to this group. Please help me in conditional > formatting i us

$$Excel-Macros$$ Sum Product Sheet

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. Foll

$$Excel-Macros$$ conditional formatting- more than 3

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 ex

$$Excel-Macros$$ Excel/VBA programmer-Midtown Manhattan (Hottest Position)

** * * * 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: Ava

Re: $$Excel-Macros$$ Help

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 li

Re: $$Excel-Macros$$ Help

Here's an accurate list. Regards, Sam Mathai Chacko (GL) On Mon, Oct 17, 2011 at 8:53 PM, NOORAIN ANSARI wrote: > Dear Ankit, > > Please see attached sheet with explain > Thanks & regards, > Noorain Ansari > *http://excelmacroworld.blogspot.com/* > *http:

Re: $$Excel-Macros$$ Paste into a Named Range

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 wrote: > If you have a defined name range such as myrng

Re: $$Excel-Macros$$ Get the Unique value from pivot table in combo box

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 wrote: > Hello, > > I have a pivot table which is dynamic which is going to be change > every time whe

Re: $$Excel-Macros$$ Paste into a Named Range

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 =OFFSET(Sheet1!$A$2,0,0,MATCH("",Sheet1

Re: $$Excel-Macros$$ Paste into a Named Range

please attach example file 2011/10/17 Cab Boose > 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

Re: $$Excel-Macros$$ Toggle a Cell value

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 wrote: > I don't necessarily support this alternative, and I don't think it is > popular among the old schools either, but it is effective nonetheless. There > is a

$$Excel-Macros$$ Paste into a Named Range

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

$$Excel-Macros$$ Get the Unique value from pivot table in combo box

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

Re: $$Excel-Macros$$ Un lock the file.

That will only open the sheet / workbook password Noorain :) On Mon, Oct 17, 2011 at 9:29 PM, NOORAIN ANSARI wrote: > Dear Jay, > > Please try through below link. > http://www.straxx.com/excel/password.html > > -- > Thanks & regards, > Noorain Ansari > *http://excelmacroworld.blogspot.com/*

Re: $$Excel-Macros$$ Un lock the file.

Dear Jay, Please try through below link. http://www.straxx.com/excel/password.html -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Mon, Oct 17, 2011 at

Re: $$Excel-Macros$$ Count days in a Col

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 + Application.WorksheetFunction

Re: $$Excel-Macros$$ Quick Date Count Question

try =if(and(a1>=b1,a1-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 falls between a start and end date. For example: A1: 9/7/2011

Re: $$Excel-Macros$$ Count days in a Col

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 wrote: > 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

Re: $$Excel-Macros$$ Help

Dear Ankit, Please see attached sheet with explain Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Mon, Oct 17, 2011 at 7:06 PM, Ankit Agrawal wrote: > Hi

$$Excel-Macros$$ Count days in a Col

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. -- ---

Re: $$Excel-Macros$$ Quick Date Count Question

Hi Try this =if(and(a1c1),a1,0) Thanks and Regards, Somnath C Pardeshi Sent from my BlackBerry® Smartphone on Loop Mobile. -Original Message- From: RockyFontane Sender: excel-macros@googlegroups.com Date: Mon, 17 Oct 2011 08:08:40 To: MS EXCEL AND VBA MACROS Reply-To: excel-macros@go

Re: $$Excel-Macros$$ Quick Date Count Question

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 wrote: > I'm trying to determine if a specific dat

$$Excel-Macros$$ Quick Date Count Question

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! --

$$Excel-Macros$$ Sample Feasibility Report

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 / Out

Re: $$Excel-Macros$$ Un lock the file.

Jay, One can find algorithms freely available that can break the workbook or sheet passwords. For a file protection though, you would want a dedicated password recovery software, like AOPR. The trial versions can break passwords of up to 3 characters length. Anything beyond, and you would want a r

Re: $$Excel-Macros$$ Help

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 wrote: > Dear Surya, > > Please see attached sheet > > > -- > Thanks & regards, > Noorain Ansari > *http://excelmacroworld.blogspot.com/

$$Excel-Macros$$ Get the Unique value from pivot table in combo box

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 s

Re: $$Excel-Macros$$ auto complete feature in drop down list or combo box

Please share your worksheet with us. On Mon, Oct 17, 2011 at 6:44 AM, ajjw123 wrote: > can anybody help me with auto complete feature incorporation in drop > down list or in a combo box.thanks > > -- > > -- > Some im

Re: $$Excel-Macros$$ auto complete feature in drop down list or combo box

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

Re: $$Excel-Macros$$ Help

Dear Surya, Please see attached sheet -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Mon, Oct 17, 2011 at 4:54 PM, suryaprasad.b

$$Excel-Macros$$ Help

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 exce