Re: $$Excel-Macros$$ Vlookup with 2 criteria

Hi Srinivas, Try the formula...and look attached sample... *=SUMPRODUCT(($C$3:$C$5=G3)*($D$3:$D$5=H3)*($E$3:$E$5))* On Tue, Aug 30, 2011 at 11:43 PM, Shrinivas Shevde wrote: > Dear all > Can I use Vlookup with 2 criteria? > If Yes please let me know > > > -- > Shrini > > -- > > --

Re: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 2003

Hi Rajan, Nice Array formula & Sumproduct superb solution... *Best Regards,* *Venkat * *Chennai* * * On Tue, Aug 30, 2011 at 10:34 PM, Rajan_Verma wrote: > *See the attached * > > * * > > * * > > * * > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf

Re: $$Excel-Macros$$ stock on hand report generate

Hi Jasmin, Share some sample data... *Best Regards,* *Venkat * *Chennai* * * On Tue, Aug 30, 2011 at 10:27 PM, jasmin wrote: > Hi all experts > > i have a small store which contains 300 products( MEDICINES).in a > quarter i reviced the items once or twice.But i issue items to various > dept tw

RE: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 2003

See the attached From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Venkat CV Sent: Wednesday, August 31, 2011 7:33 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 2003 Hi Amit

$$Excel-Macros$$ stock on hand report generate

Hi all experts i have a small store which contains 300 products( MEDICINES).in a quarter i reviced the items once or twice.But i issue items to various dept twice in a week or thrice in fortnight.My requirement is 1.on item recieved to my store i enter all items in reciept colum.The qty should ad

RE: $$Excel-Macros$$ How to use Multiple criteria in DSUM function...

Sir ji EK sample file attached Kar do .. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of B Sharma Sent: Wednesday, August 31, 2011 9:24 AM To: MS EXCEL AND VBA MACROS Subject: Re: $$Excel-Macros$$ How to use Multiple criteria in DS

RE: $$Excel-Macros$$ Decimal greater than 0.5

You can also use this : =MROUND(B5,1) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Venkat CV Sent: Wednesday, August 31, 2011 10:07 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Decimal greater than 0.5 Hi, try Round fo

RE: $$Excel-Macros$$ Combox List in Userform

See attached file.. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Mr Excellent Sent: Wednesday, August 31, 2011 10:20 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Combox List in Userform Hi All, Attached is the sheet where i ne

$$Excel-Macros$$ Combox List in Userform

Hi All, Attached is the sheet where i need the data to be loaded Combo box of the userform given, i need a VBA Code which picks the data from the excel spread sheet and provides them in the combo box as a drop down list..please help Thanks Prasad. -- ---

Re: $$Excel-Macros$$ Decimal greater than 0.5

Hi, try Round formula Example Below =ROUND(A1,0) *Best Regards,* *Venkat * *Chennai* * * On Tue, Aug 30, 2011 at 10:54 PM, Skanda wrote: > Hi All, > How to convert the numbers in a column based on following: > example: > 13.45 should be displayed as 13 > 13.5 or 13.51(decimal equal or great

Re: $$Excel-Macros$$ Attach file for discussion

Hi, In your G mail Just click Compose Mail and attach and write your query and send it to *excel-macros@googlegroups.com* *Best Regards,* *Venkat * *Chennai* On Wed, Aug 31, 2011 at 2:47 AM, Tripp wrote: > How can I attach a spreadsheet for review? > > -- > > --

Re: $$Excel-Macros$$ Macro to remove repeats and merge

Hi, You can try Remove duplicate's option in Excel 2007 or 2010 use ALT+A+T *Best Regards,* *Venkat * *Chennai* On Wed, Aug 31, 2011 at 2:44 AM, Gaetan M wrote: > I have the following: > > Column A B C D > E F > 12722 12722 51.

$$Excel-Macros$$ Decimal greater than 0.5

Hi All, How to convert the numbers in a column based on following: example: 13.45 should be displayed as 13 13.5 or 13.51(decimal equal or greater than .5) should be 14. -- -- Some important links for excel users: 1

$$Excel-Macros$$ Attach file for discussion

How can I attach a spreadsheet for review? -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.link

$$Excel-Macros$$ Macro to remove repeats and merge

I have the following: Column A B C D E F 12722 12722 51.564.89 RNLOX 12723 12723 51.564.89 RNLOX Would you have the solution to replace B1 by B2 and delete row 2 once completed since they have been

Re: $$Excel-Macros$$ How to use Multiple criteria in DSUM function...

Yes Rajan, You are right I am using the same for the time being... but I wanted to use this through Dsum... anyways ... thanks for your time... On Aug 30, 7:32 pm, "Rajan_Verma" wrote: > Hi Bajrang, > You can use sumifs() Function for this I think, or attached a sample file to > better

Re: $$Excel-Macros$$ Calculate Product Sold To Date by Product

Hi john, Try the Below... =SUMIF($B$2:$B$8,B2,$D$2:$D$8) *Best Regards,* *Venkat * *Chennai* * * On Tue, Aug 30, 2011 at 9:39 PM, John A. Smith wrote: > Your help please. I have a log of product sold and need to calculate the > different product sold to date, like a running accumulation field

Re: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 2003

Hi Amit See below link for Sumifs in 2003 http://chandoo.org/forums/topic/converting-sumifs-to-excel-2003 -- *Best Regards,* *Venkat * *Chennai* * * On Tue, Aug 30, 2011 at 9:54 PM, Amit Desai (MERU) wrote: > Dear All, > > ** ** > > Do we have any option for countifs & Sumifs formula in M

Re: $$Excel-Macros$$ User form

Hi Surya, Try the Below... *Private Sub Workbook_Open()* *UserForm1.show* *End Sub* *Best Regards,* *Venkat * *Chennai* * * On Tue, Aug 30, 2011 at 9:00 PM, Suryaprasad wrote: > Hi Venkat, > > Sorry for the wrong attachment, here is the updated one. > > What i need is when i open the spread

Re: $$Excel-Macros$$ Re: Need macro to split the files

I have also created thousands of functions, and PivotTables you're asking or you're selling web site? 2011/8/30 Frederic LE GUEN - MVP Excel > Hi > I have written today a page about the way to create a worksheet > function of a criteria > http://www.excel-exercice.com/en/2074/creation-of-work

$$Excel-Macros$$ Re: Need macro to split the files

Hi I have written today a page about the way to create a worksheet function of a criteria http://www.excel-exercice.com/en/2074/creation-of-worksheets-by-criteria I'm sure that this tip will help you ;) On 30 août, 06:52, anu gomathi wrote: > Hi Experts, > > I am very new to this forum. > > Atta

Re: $$Excel-Macros$$ Re: Need macro to split the files

Please attach file 2011/8/30 anu gomathi > Hi, > > Can u pls explain me the steps. Any way i need the summary in the detail > sheet. > > Regards > Anu > > On Tue, Aug 30, 2011 at 2:52 PM, Frederic LE GUEN - MVP Excel < > fleg...@gmail.com> wrote: > >> Why don't you use a pivot table with the

Re: $$Excel-Macros$$ Calculate Product Sold To Date by Product

Thank you very much for your quick response, your patience and your help. John On Tue, Aug 30, 2011 at 12:37 PM, dguillett1 wrote: > in d2 copied down > =SUMIF($B$2:B2,B2,$C$2:C2) > > *From:* John A. Smith > *Sent:* Tuesday, August 30, 2011 11:09 AM > *To:* excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 2003

TRY it!!! From: Amit Desai (MERU) Sent: Tuesday, August 30, 2011 12:18 PM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 2003 But what if I need a count (& not sum)of numbers in a cell? Best Regards, Amit Desai From: ex

Re: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 2003

Amit =sumproduct((a2:a22=1)*(b2:b22<>"")) This is the easiest way to do this. Sent on my BlackBerry® from Vodafone Thanks & Regards. Kiran -Original Message- From: "Amit Desai (MERU)" Sender: excel-macros@googlegroups.com Date: Tue, 30 Aug 2011 22:48:06 To: Reply-To: excel-macros@go

RE: $$Excel-Macros$$ How to load data into Combo box in user form

See the attached Sheet.. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rakesh Joshi Sent: Tuesday, August 30, 2011 9:29 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ How to load data into Combo box in user form Go to Property of

RE: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 2003

But what if I need a count (& not sum)of numbers in a cell? Best Regards, Amit Desai From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1 Sent: Tuesday, August 30, 2011 10:41 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Option f

Re: $$Excel-Macros$$ How to load data into Combo box in user form

Hi Rajan, Thanks for the attachment, but my requirement is to add the list in the Userform provided in excel sheet not on the excel spread sheet. Note : The Combo box should be enabled once the data is entered in Text Box given above of Combo box. Please do the needfull. Thanks Prasad On Tue,

Re: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 2003

=sumproduct((a2:a22=1)*(b2:b22)) From: Amit Desai (MERU) Sent: Tuesday, August 30, 2011 12:03 PM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 2003 What about option for countifS? Best Regards, Amit Desai From: excel-m

RE: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 2003

What about option for countifS? Best Regards, Amit Desai From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1 Sent: Tuesday, August 30, 2011 10:04 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Option for countifs & Sumifs formula

Re: $$Excel-Macros$$ Calculate Product Sold To Date by Product

in d2 copied down =SUMIF($B$2:B2,B2,$C$2:C2) From: John A. Smith Sent: Tuesday, August 30, 2011 11:09 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Calculate Product Sold To Date by Product Your help please. I have a log of product sold and need to calculate the

Re: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 2003

=sumproduct((a2:a22=1)*b2:b22) From: Amit Desai (MERU) Sent: Tuesday, August 30, 2011 11:24 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 2003 Dear All, Do we have any option for countifs & Sumifs formula in MS Excel 2003?

$$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 2003

Dear All, Do we have any option for countifs & Sumifs formula in MS Excel 2003? Best Regards, Amit Desai Disclaimer: This message and its attachments contain confidential information and may also contain legally privileged information. This message is intended

$$Excel-Macros$$ Calculate Product Sold To Date by Product

Your help please. I have a log of product sold and need to calculate the different product sold to date, like a running accumulation field specific to product listed in column B. Please see my attached spreadsheet. Thanking you in advance for all your great help. John -- -

RE: $$Excel-Macros$$ How to load data into Combo box in user form

See the attached From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rakesh Joshi Sent: Tuesday, August 30, 2011 9:29 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ How to load data into Combo box in user form Go to Property of Combo

Re: $$Excel-Macros$$ How to load data into Combo box in user form

Go to Property of Combo box type the Range under the row source of Combobox.: On Tue, Aug 30, 2011 at 9:09 PM, Suryaprasad wrote: > Hi All, > > Attached is the sheet where i need the list of the countries to be added to > the combo box > > Note : The Combo box should be enabled once the data is e

$$Excel-Macros$$ How to load data into Combo box in user form

Hi All, Attached is the sheet where i need the list of the countries to be added to the combo box Note : The Combo box should be enabled once the data is entered in Text Box given above of Combo box. Please do the needfull. Thanks Prasad --

Re: $$Excel-Macros$$ User form

Dear surya, Please see attached sheet.. On Tue, Aug 30, 2011 at 9:00 PM, Suryaprasad wrote: > Hi Venkat, > > Sorry for the wrong attachment, here is the updated one. > > What i need is when i open the spread sheet the form should POP > automatically. > > Thanks > Prasad. > > > On Tue, Aug 30, 2

Re: $$Excel-Macros$$ User form

Hi Venkat, Sorry for the wrong attachment, here is the updated one. What i need is when i open the spread sheet the form should POP automatically. Thanks Prasad. On Tue, Aug 30, 2011 at 7:36 PM, Venkat CV wrote: > Hi Surya, > > Your excel sheet is empty..Please check.. > > *Best Regards,* >

Re: $$Excel-Macros$$ help

Dear Vijay, if your Word in one cell you can use... =PROPER(Trim(SUBSTITUTE(D4," ",""))) On Tue, Aug 30, 2011 at 7:26 PM, vijayajith VA wrote: > Hi, > > i have four words and i need to combine using trim and proper functions. > > Please can you provide me formula > > Thank you > > -- >

Re: $$Excel-Macros$$ any short key to remove double add.

Hi Kannan, In Excel 2007(or)2010 version Having Advanced filter option you can get a unique records by using *Filter the list-List range-Criteria range-Unique Records only * * * *This Option will be used for removing duplicates and unique records viewing Purpuse..* *Best Regards,* *Venkat * *Ch

Re: $$Excel-Macros$$ any short key to remove double add.

Hi NOORAIN ANSARI, Pls tell wat is this.?? if you feel free explain me. Regards V. Kannan Aircel Limited Chennai On Mon, Aug 29, 2011 at 3:38 PM, NOORAIN ANSARI wrote: > Dear Anil, > > Use Alt+A Q for Advance filter.. > Choose *Filter the list-List range-Criteria range-Unique Records only > > *

RE: $$Excel-Macros$$ How to use Multiple criteria in DSUM function...

Hi Bajrang, You can use sumifs() Function for this I think, or attached a sample file to better understand your Query, Rajan. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of B Sharma Sent: Tuesday, August 16, 2011 12:53 PM To: MS

Re: $$Excel-Macros$$ Named Range to Dynamic with VBA

You can put this in a regular sub or this worksheet double click event Right click sheet tab>view code>insert this>double click any cell to name range Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) For Each N In ActiveWorkbook.Names If InStr(1, N.RefersTo, Ac

RE: $$Excel-Macros$$ help

Use Concatenate =Concatenate(Proper(Trim(YourWord)), Proper(Trim(YourWord)) Or & Sign Proper(Trim(YourWord)) & " " & Proper(Trim(YourWord)) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of vijayajith VA Sent: Tuesday, August 30, 2011 7:27

Fwd: $$Excel-Macros$$ User form

Hi Surya, Your excel sheet is empty..Please check..and resend it back...and please Elaborate more about your query. *Best Regards,* *Venkat * *Chennai* * * * * On Tue, Aug 30, 2011 at 7:26 PM, Suryaprasad wrote: > Hi , > > Please see my excel spread sheet i need the userform as POP see the cha

Re: $$Excel-Macros$$ help

Hi vijay, Please send some sample data...for your requirement.. *Best Regards,* *Venkat * *Chennai* On Tue, Aug 30, 2011 at 7:26 PM, vijayajith VA wrote: > Hi, > > i have four words and i need to combine using trim and proper functions. > > Please can you provide me formula > > Thank you > >

Re: $$Excel-Macros$$ User form

Hi Surya, Your excel sheet is empty..Please check.. *Best Regards,* *Venkat * *Chennai* * * * * On Tue, Aug 30, 2011 at 7:26 PM, Suryaprasad wrote: > Hi , > > Please see my excel spread sheet i need the userform as POP see the chail > mail > > Thanks > Prasad > On Tue, Aug 30, 2011 at 6:39 P

Re: $$Excel-Macros$$ User form

Hi , Please see my excel spread sheet i need the userform as POP see the chail mail Thanks Prasad On Tue, Aug 30, 2011 at 6:39 PM, dguillett1 wrote: > What userform? Put this in the ThisWorkbook module > > Private Sub Workbook_Open() > nameofyouruserformhere.Show > End Sub > > *From:* Suryap

Re: $$Excel-Macros$$ User form

What userform? Put this in the ThisWorkbook module Private Sub Workbook_Open() nameofyouruserformhere.Show End Sub From: Suryaprasad Sent: Tuesday, August 30, 2011 7:42 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ User form Hi All, Need a small help , i need to get a pop

Re: $$Excel-Macros$$ User form

Hi Prasad, Look attached below... If you want to create some VBA Coding in background of userforms..You have to save the file has a .XLS or XLSM because XLSX wont support Macro Language.. *Best Regards,* *Venkat * *Chennai* On Tue, Aug 30, 2011 at 6:12 PM, Suryaprasad wrote: > Hi All, > > Ne

$$Excel-Macros$$ User form

Hi All, Need a small help , i need to get a pop up of the user form when my excel is opened, see the attachment Thanks Prasad. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and

Re: $$Excel-Macros$$ Re: Need macro to split the files

Hi, Can u pls explain me the steps. Any way i need the summary in the detail sheet. Regards Anu On Tue, Aug 30, 2011 at 2:52 PM, Frederic LE GUEN - MVP Excel < fleg...@gmail.com> wrote: > Why don't you use a pivot table with the table option to split your > document by Division and Regional lea

RE: $$Excel-Macros$$ Named Range to Dynamic with VBA

Hi, Be cautious with this macro and keep a copy of your workbook. Look at the attached workbook in which there is an example of error. Sub test() Dim N As Name, Var As String, Tabl As Variant For Each N In ActiveWorkbook.Names If LCase(Left(N.RefersTo, 7)) <> "=offset" Th

$$Excel-Macros$$ Re: Excel and Sending Digital Data (DDE ?)

On Aug 30, 4:55 am, Cab Boose wrote: > Hi once again > > This is totally new subject.   I have model railroads.   I would like to > control from Excel.    (there are some other software available but I would > like to use Excel) > > I want to send from Excel to a bus wire digital information showi

$$Excel-Macros$$ Re: Need macro to split the files

Why don't you use a pivot table with the table option to split your document by Division and Regional lead ? On 30 août, 06:52, anu gomathi wrote: > Hi Experts, > > I am very new to this forum. > > Attached the details report & the out put file. I need a macro to split the > workbook as per the

Re: $$Excel-Macros$$ xls to Pdf in VBA error

Hi Noorian, How it will automatically save PDF Format in 2003 Version...is it available.. -- *Best Regards,* *Venkat * *Chennai* * * On Tue, Aug 30, 2011 at 2:16 PM, NOORAIN ANSARI wrote: > Dear Sajid, > > Please change blue color path as per your system.. > This code is working fine in my sys

Re: $$Excel-Macros$$ xls to Pdf in VBA error

Dear Sajid, Please change blue color path as per your system.. This code is working fine in my systems.. *Once again.try..* ** *Private Sub CommandButton1_Click() Dim wrknm As String wrknm = ActiveWorkbook.Name wrknm = Left(wrknm, InStr(1, wrknm, ".") - 1)* *ActiveWorkbook.ExportAsFixedFor

$$Excel-Macros$$ Fwd: Opening for SQl Developer in Chennai with Ramco Systems

- Original message From:"Magna Infotech Pvt Ltd"< car...@magna.in > Date: 30 Aug 11 12:28:42 Subject: Opening for SQl Developer in Chennai with Ramco Systems To: The sender of this email is registered with Naukri.com as Magna Infotech Pvt Ltd Experience required for the Job: 3 - 7

$$Excel-Macros$$ Fwd:Job

- Original message From:""Teamware Solutions (quantum leap consulting)""< sw...@twsol.com > Date: 30 Aug 11 12:43:07 Subject: Urgent Requirment for MS SQL server 2005/2008Developers for TCS, Kochi To: The sender of this email is registered with Naukri.com as Teamware Solutions (q

RE: $$Excel-Macros$$ Sumproduct using VBA

Hello, Use : a = "SUMPRODUCT(--(" & rng1 & "=""" & "BEL" & """),--(" & rng2 & "=""" & "AAO" & """),--(" & rng4 & "))" HTH Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Chandra Shekar Envoyé : lundi 29 août 2011 16:37 À : excel-mac

Re: $$Excel-Macros$$ Stock Sheets x 2 to equal each other

Dear Cab, Process to add Add-Ins in Excel Ribbon Excel Option->Add-Ins->Manage->Excel Add-Ins->Go->Ok You can see below link.. http://www.lytebyte.com/2009/01/08/how-to-add-and-remove-excel-add-in-or-plugins/ -- Thanks & regards, Noorain Ansari *http://noorain-ansari.blogspot.com/*

Re: $$Excel-Macros$$ Stock Sheets x 2 to equal each other

Hi Noorain Thanks for that. It does not show in the add-in at the moment. Have opened Excel and then opened the file you sent. Is there a process that I should foolw ? Thankyou Charlie On Tue, Aug 30, 2011 at 7:43 PM, NOORAIN ANSARI wrote: > Dear Cab, > > Actually it is Add-In file when you

Re: $$Excel-Macros$$ Stock Sheets x 2 to equal each other

Dear Cab, Actually it is Add-In file when you click on this, it will be Show in Add-in Menu bar when you need it can be use.. -- Thanks & regards, Noorain Ansari *http://noorain-ansari.blogspot.com/* On Tue, Aug 30, 2011 at 12:10 PM, Cab Boose wrote: >