Hi Jasmin,
Share some sample data...
*Best Regards,*
*Venkat *
*Chennai*
*
*
On Tue, Aug 30, 2011 at 10:27 PM, jasmin snband...@gmail.com 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
Hi Rajan,
Nice Array formula Sumproduct superb solution...
*Best Regards,*
*Venkat *
*Chennai*
*
*
On Tue, Aug 30, 2011 at 10:34 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
*See the attached *
* *
* *
* *
*From:* excel-macros@googlegroups.com [mailto:
You can use this :
=SUM((C3:C5=G3)*(D3:D5=H3)*(E3:E5))
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Venkat CV
Sent: Wednesday, August 31, 2011 12:26 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Vlookup with 2 criteria
Hi
-- 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
Sorry guys.
I don't want pivot table. i want like that any macro or formulas.
help me
On Tue, Aug 30, 2011 at 8:21 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
*Hi*
*See the attached ,*
*First we need to create a NameRange and need to put that in Pivot Table
dataSource ,*
* *
Excel 7
I have 60 rows, one for each of two shifts, each day of the month
Each row has 7 columns with an employee name in each column
I have one column (M) with the number of hours worked.
I have a constant field named Associate which contains the name of
one of the employees
Currently I have
I have also created thousands of functions, and PivotTables
Good :)
you're asking or you're selling web site?
I'm am sharing ;)
As Excel MVP, I have to share my knowledge for free on the web.
So when a question is in relation with one of the page of my website,
I post the related page.
--
Hi Ashish,
This is absolutely fantastic. Need your help to change the below things
1. Regional lead data is not populated in the Summary details sheet.
2. Could you pls remove the Q1 FY12 data from the from the detail sheet.
Q1 Fy12 data is already available in the Summary sheet.
Thanks a
Hi Kannan,
Look attached used formulas...
=COUNTIFS(Sheet1!$B:$B,Sheet3!$A2,Sheet1!$E:$E,Sheet3!H$1)
*Best Regards,*
*Venkat *
*Chennai*
*
*
On Wed, Aug 31, 2011 at 11:02 AM, kannan excel kannan.ex...@gmail.comwrote:
Sorry guys.
I don't want pivot table. i want like that any macro or
Hi,
See below links if helps..
http://www.cpearson.com/excel/cformatting.htm
http://www.excelforum.com/excel-general/497309-can-logical-operators-be-used-within-conditional-formatting.html
*Best Regards,*
*Venkat *
*Chennai*
*
*
On Wed, Aug 31, 2011 at 11:36 AM, zp18 irvinep...@gmail.com
Dear All
Please suggest a formula of Sumproducts
Thanking u
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our
Hi Karan,
Go to Hyperlink and try Exiting file or webpage option and selcect the word
document..
[image: image.png]
*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*
*
*
On Wed, Aug 31, 2011 at 4:24 PM, karan 1237 karan1...@gmail.com
Hi Sudhir,
Try this
*=SUMPRODUCT((B3:B7=F5)*(A3:A7=G5)*(C3:C7))*
*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*
On Thu, Sep 1, 2011 at 5:00 AM, Sudhir Kumar sudhir.ku...@lazerindia.comwrote:
Dear All
** **
Please suggest
Please refere the attached file.
Thanks
N.Sundarvelan
9600160150
On Thu, Sep 1, 2011 at 5:00 AM, Sudhir Kumar sudhir.ku...@lazerindia.comwrote:
Dear All
** **
Please suggest a formula of Sumproducts
** **
Thanking u
--
Hi
Try
=SUMPRODUCT((A3:A7=G5)*(B3:B7=F5)*(C3:C7)) *OR*
=SUMIFS(C3:C7,A3:A7,G5,B3:B7,F5)
On Wed, Aug 31, 2011 at 5:05 PM, Sundarvelan N nsund...@gmail.com wrote:
Please refere the attached file.
Thanks
N.Sundarvelan
9600160150
On Thu, Sep 1, 2011 at 5:00 AM, Sudhir Kumar
Data Table
Date
Party Name
Amount
Hi can u suggest here for Sumproduct formula
8/30/2011
Anuvanshika -Kanpur
3
8/30/2011
Kelvin Elec.
49649
Name of Parties
Date
Amt.
8/30/2011
Anand Agencies
15
Kelvin
Data Table
Date
Party Name
Amount
Hi can u suggest here for Sumproduct formula
8/30/2011
Anuvanshika -Kanpur
3
8/30/2011
Kelvin Elec.
49649
Name of Parties
Date
Amt.
8/30/2011
Anand Agencies
15
Kelvin
Hi
not sure what exactly you looking for, even if you *sort* the Party Name
column you will get results as per highlighted in yellow
thanks
Mahesh
On Thu, Sep 1, 2011 at 5:46 AM, Sudhir Kumar sudhir.ku...@lazerindia.comwrote:
*Data Table*
* *
* *
** **
** **
** **
** **
** **
Hi Sudhir,
For sumproduct we must have 2 fixed data criteria..in this scenario we cant
use
SUMPRODUCT
*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*
*
*
On Thu, Sep 1, 2011 at 5:46 AM, Sudhir Kumar sudhir.ku...@lazerindia.comwrote:
Hi Friends,
I need VBA code for copy existing sheet(s) in to a new workbook.
i.e. I needs to copy two sheets (Active sheet and previous to the active
sheet)from a workbook and the same two sheet needs to same as a new work
book In a specified location with specified name(example like Statement
Not sure of your criteria but try this
Option Explicit
Sub getonlylastvaluecolB()
Dim i As Long
For i = Cells(Rows.Count, 1).End(xlUp).Row To 1 Step -1
If Left(Cells(i + 1, 1), 4) = Left(Cells(i, 1), 4) Then Rows(i).Delete
Next i
End Sub
===
-Original Message-
From: Gaetan M
Not sure of your criteria but try this
Option Explicit
Sub getonlylastvaluecolB()
Dim i As Long
For i = Cells(Rows.Count, 1).End(xlUp).Row To 1 Step -1
If Left(Cells(i + 1, 1), 4) = Left(Cells(i, 1), 4) Then Rows(i).Delete
Next i
End Sub
-Original Message-
From: Gaetan M
Sent:
Hi Prabhu
Try
Option Explicit
Sub Mtest()
Dim sPath As String, sFname As String
sPath = ThisWorkbook.Path \
sFname = Statement as on Format(Date, mm-dd-)
With ThisWorkbook
Sheets(Array(ActiveSheet.Name, ActiveSheet.Previous.Name)).Select
Sheets(Array(ActiveSheet.Name,
ok thanks but I what i was wondering is if there is a possibility to
run a macro to remove the prior line and combine them. I have a large
amount of data and I need to compile it. So what i need to do is for
everytime 2 or more items in column E are the same, they are merged
and B2 takes the spot
You could use this as your criteria but what happens if you also have the
same amount for another 100 rows down and you sort by col E. You could get
UN intended results.
-Original Message-
From: Gaetan M
Sent: Wednesday, August 31, 2011 7:30 AM
To: MS EXCEL AND VBA MACROS
Subject:
=SUMPRODUCT((B3:B22=F5)*(A3:A22=G5)*C3:C22)
From: Sudhir Kumar
Sent: Wednesday, August 31, 2011 6:30 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Book2.xlsx
Dear All
Please suggest a formula of Sumproducts
Thanking u
--
Thank you. The criteria is the column E (RNLO)
On Aug 31, 7:50 am, dguillett1 dguille...@gmail.com wrote:
Not sure of your criteria but try this
Option Explicit
Sub getonlylastvaluecolB()
Dim i As Long
For i = Cells(Rows.Count, 1).End(xlUp).Row To 1 Step -1
If Left(Cells(i + 1, 1), 4) =
Assumes you have it sorted by col E
Option Explicit
Sub SortColE()
Dim lr As Long
lr = Cells(Rows.Count, 1).End(xlUp).Row
Range(A1:F lr).Sort Key1:=Range(E1), _
Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, _
Orientation:=xlTopToBottom
End Sub
Sub
Hi Karan,
Try This :
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
Dim WordApp As New Word.Application
WordApp.Visible = True
WordApp.Documents.Open D:\Rajan\NFA.docx
WordApp.Selection.GoTo What:=wdGoToPage, Which:=wdGoToNext,
Try sumifs()
=SUMIFS(C3:C7,A3:A7,G5,B3:B7,F5)
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Sudhir Kumar
Sent: Thursday, September 01, 2011 5:00 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Book2.xlsx
Dear All
Please suggest
Do you want to Vlookup in 2 Direction ??
Use this :
=VLOOKUP($B19,$B$1:$K$16,MATCH(D$18,$B$1:$K$1,0),0)
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Shrinivas Shevde
Sent: Wednesday, August 31, 2011 12:13 PM
To: excel-macros@googlegroups.com
Hi Anu
could you tell me do u want to apply filter on regional lead
or divisional lead.
On Wed, Aug 31, 2011 at 2:29 PM, anu gomathi anugomathi.d...@gmail.comwrote:
Hi Ashish,
This is absolutely fantastic. Need your help to change the below things
1. Regional lead data is not
Hi,
Fine. Maybe the device linked to the USB cable come with an ActiveX control
?
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Cab Boose
Envoyé : mardi 30 août 2011 05:56
À : excel-macros@googlegroups.com
Objet :
… or a driver ?
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Cab Boose
Envoyé : mardi 30 août 2011 05:56
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ Excel and Sending Digital Data (DDE ?)
Hi once again
This is totally
Hi Ashish,
I want to apply the filter on both regional lead divisional lead.
Example: Wolfgang will be in both regional lead divisional lead. It has to
lookout both bring the result.
Regards
Anu
On Wed, Aug 31, 2011 at 7:50 PM, ashish koul koul.ash...@gmail.com wrote:
Hi Anu
could you
Dear Shrinivas,
Please see attached sheet..
*=VLOOKUP(H6I6,A4:D8,4,0)*
Alternative solutions...
*{=INDEX(D4:D8,MATCH(1,(B4:B8=H6)*(C4:C8=I6),0))}
{=OFFSET(D3,MATCH(1,(B4:B8=H6)*(C4:C8=I6),0),0)}*
*=DSUM(B3:D8,D3,H5:I6)*
--
Thanks regards,
Noorain Ansari
*http://noorain-ansari.blogspot.com/*
try with D:\Reports\
On Wed, Aug 31, 2011 at 9:26 PM, Prabhu prabhugate...@gmail.com wrote:
Hi Makesh,
I am getting some runtime error1004
Actually i have given path as D:\Reports
can you help me, whether i have to do some this else?
Regards,
Prabhu
--
Hi Makesh,
I am getting some runtime error1004
Actually i have given path as D:\Reports
can you help me, whether i have to do some this else?
Regards,
Prabhu
--
--
Some important links for excel users:
1. Follow
ok thx , I understand
2011/8/31 Frederic LE GUEN - MVP Excel fleg...@gmail.com
I have also created thousands of functions, and PivotTables
Good :)
you're asking or you're selling web site?
I'm am sharing ;)
As Excel MVP, I have to share my knowledge for free on the web.
So when a
Dear john,
Please see attached sheet..
On Tue, Aug 30, 2011 at 9:39 PM, John A. Smith johnasmit...@gmail.comwrote:
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
Thank you Noorain. I appreciate your help very much.
John
On Wed, Aug 31, 2011 at 1:26 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear john,
Please see attached sheet..
On Tue, Aug 30, 2011 at 9:39 PM, John A. Smith johnasmit...@gmail.comwrote:
Your help please. I have a log of
Hi friends i have an issue, i use this do loop to fill cells with a certain
text, how i want to choose what i put in Month i want and write in columns
C until C reaches the value total, what i pretend is a inputbox where i
choose what to write.
i think i have to use dim as integer and them
Hi Ashish,
Same Run time error 1004
- Make sure the specified folder is exists
- Make sure the folder that contains the file is not read-only
- Make sure the file name does not contain any of the following
characters ? [ ] :| or *
Debug shows the below yellow mark line item.
Hi Prabhu
check path of your file
sPath = ThisWorkbook.Path D:\Reports\
*should be*
sPath = D:\Reports\
Thanks
Mahesh
On Wed, Aug 31, 2011 at 11:25 PM, Prabhu prabhugate...@gmail.com wrote:
Hi Ashish,
Same Run time error 1004
- Make sure the specified folder is exists
- Make
Hi,
I just use this
Sub speak()
Application.Speech.speak Hellow EveryOne, Look I M speaking
End Sub
On Wed, Aug 31, 2011 at 11:05 PM, Mahesh parab mahes...@gmail.com wrote:
Hi
does any one aware of Speech Recognition software for excel, below are some
link i found on net
anyone using
Thanks for sharing this mahesh and rajan
On Wed, Aug 31, 2011 at 11:36 PM, rajan verma rajanverma1...@gmail.comwrote:
Hi,
I just use this
Sub speak()
Application.Speech.speak Hellow EveryOne, Look I M speaking
End Sub
On Wed, Aug 31, 2011 at 11:05 PM, Mahesh parab mahes...@gmail.com
Hi Friends,
When i double click my Pivot table value a new sheet is appearing with the
details. But all the amount columns are showing in date format.
Can anybody help how to rectify the same.(value should show in Number format
and date should be in date format)
Plz help.
Regards,
Prabhu
I have never seen this problem (sorry)
But it looks strange
On 31 août, 21:28, Prabhu prabhugate...@gmail.com wrote:
Hi Friends,
When i double click my Pivot table value a new sheet is appearing with the
details. But all the amount columns are showing in date format.
Can anybody help how to
Thanks Ranjan
but i am aware of Application.Speech.speak. speak cell in excel 2007 its
inbuilt
i am looking for software which operate excel through Speech Recognition.
further info.
http://www.nuance.com/for-business/by-product/dragon/dragon-for-the-pc/dragon-premium/index.htm
Can you post the pivoted file plz ?
Thanks
Prasad
Sent from BlackBerry® on Airtel
-Original Message-
From: Prabhu prabhugate...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Wed, 31 Aug 2011 12:28:10
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Hi Prabhu,
Send send some sample data with pivot...
*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*
On Wed, Aug 31, 2011 at 12:28 PM, Prabhu prabhugate...@gmail.com wrote:
Hi Friends,
When i double click my Pivot table value a
HI All,
Plz find the pivot table sheet.
kindly help.
Regards,
Prabhu
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our
---
Anand Kumar wants to stay in better touch using some of Google's coolest new
products.
If you already have Gmail or Google Talk, visit:
http://mail.google.com/mail/b-60943ae763-3b0a750245-hfaE1gnqrmFYgOTVLQA-LcGRqXs
You'll
Hi Daniel
Thanks for your response. I am having a look at this
http://www.aggsoft.com/print-asdl-excel-real-time-charting-export.htm. But
I do not think it will do what I want. It goes from device to excel.
Just to explain a little more of what I am trying to do. (way out of my
range of
54 matches
Mail list logo