Dear Pankaj,
Please try it..
*=OFFSET($B12,0,COUNTA($C$11:$P$11)-4,1,5)*
see attached sheet for more clarity.
--
With Regards,
Noorain Ansari
http://
http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com
http://
Dear Neeraj,
You can use..
=EDATE(A2,6)
or
=DATE(YEAR(A2),MONTH(A2)+6,DAY(A2))
On Fri, Feb 8, 2013 at 1:35 PM, neeraj chauhan
neerajchauhan...@gmail.comwrote:
Dear Experts,
kindly find the attached sheet i want the add the 6 or 7 months in
particular date.
--
Are you =EXP(E:RT) or
thanks sir,
its working thanks again
On Fri, Feb 8, 2013 at 2:16 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Neeraj,
You can use..
=EDATE(A2,6)
or
=DATE(YEAR(A2),MONTH(A2)+6,DAY(A2))
On Fri, Feb 8, 2013 at 1:35 PM, neeraj chauhan neerajchauhan...@gmail.com
wrote:
neeraj, very bad subject and query explaination
On Fri, Feb 8, 2013 at 2:17 AM, neeraj chauhan
neerajchauhan...@gmail.comwrote:
thanks sir,
its working thanks again
On Fri, Feb 8, 2013 at 2:16 PM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
Dear Neeraj,
You can use..
=EDATE(A2,6)
: Dhaval Shah todhavals...@gmail.com
Subject: Re: $$Excel-Macros$$ query for getting external data from a website
To: excel-macros@googlegroups.com
Cc: keni...@yahoo.com
Date: Monday, December 31, 2012, 12:24 PM
Kenil
pls click the below mention link to download data of any eq series stocks
Kenil
pls click the below mention link to download data of any eq series stocks
www.nseindia.com/content/equities/scripvol/datafiles/30-09-2012-TO-28-12-2012
*TCS*EQN.csv
www.nseindia.com/content/equities/scripvol/datafiles/30-09-2012-TO-28-12-2012RELIANCE
**EQN.csv
just u have to change the
Hi Kenil,
Make changes to below code as per your requirement. If you get stuck then
let me know.
*What you need to do:*
-change cURL as per your required time period.
-change the range and sheet.
-change the query table.
Public Const cURL =
Hi
It could not be so.
Check whether you have provided correct sheet name in your project sheet
also..
Rgds//Vabs
On Wed, Oct 24, 2012 at 4:05 PM, Kenil Gala keni...@yahoo.com wrote:
Hi all,
Pls help me solve my query.
I have written my query in the attachment .
Thanks Regards.
--
Hi all,
Need help on this.
Regards,
Ankit
On Thu, Oct 18, 2012 at 5:21 PM, Ankit Agrawal
ankit.agrawal...@gmail.comwrote:
Hi Haseeb,
Thanks for your mail. this is really help me. but I have some point which
can make it more effective and efficient.
- Department code will be written
Hi Haseeb,
Thanks for your mail. this is really help me. but I have some point which
can make it more effective and efficient.
- Department code will be written automatically.
- and , another point is, If any employee salary is going in two
percentage(%) (as in sonu),we do not need to
Hello Ankit,
Attached is a one way. This is not a best one, some one will have better
options.
I have added two columns. One is Dpmt% 2nd one is No: of Dpmt, which
is return through a formula.
No:of Dpmt column, MUST NOT be empty or zero. Better to use dynamic range
or convert your range to
Hi All,
Can it be possible or I have to do same process which I am doing.
Regards,
Ankit
On Mon, Oct 15, 2012 at 12:21 PM, Ankit Agrawal
ankit.agrawal...@gmail.comwrote:
Dear All,
I have a salary sheets where there are three column i.e. Name, Department
and salary. I need department wise
David - this still showing value error.
On Sat, Sep 29, 2012 at 4:48 AM, David Grugeon da...@grugeon.com.au wrote:
Use
=SUMPRODUCT(($H$2:$H$9=$H12)*indirect((ADDRESS(MATCH($H12,$H$2:$H$9,0)+1,COLUMN(C2)
Regards
David Grugeon
On 28 September 2012 22:24, Aamir Shahzad
Hi Aamir,
Try this one.
=INDEX(C2,MATCH($H12,$H$2:$H$9,0))
Regards,
Kuldeep Singh
On Sat, Sep 29, 2012 at 2:48 PM, Aamir Shahzad aamirshahza...@gmail.comwrote:
David - this still showing value error.
On Sat, Sep 29, 2012 at 4:48 AM, David Grugeon da...@grugeon.com.auwrote:
Use
Use
=SUMPRODUCT(($H$2:$H$9=$H12)*indirect((ADDRESS(MATCH($H12,$H$2:$H$9,0)+1,COLUMN(C2)
Regards
David Grugeon
On 28 September 2012 22:24, Aamir Shahzad aamirshahza...@gmail.com wrote:
Dear Group,
When I mannualy enter the C7 into the following formula, it has no
problem,
Not getting your problem???
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Excel Vba
Sent: 13 September 2012 7:40
To: excelvbacli...@googlegroups.com
Subject: $$Excel-Macros$$ Query - Circle
Circle Invalid?
Are you refering to a Circular Reference?
I've never heard of a Circle Invalid function.
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the
I think it is excel 2010 version. When you goto Data tab, then select Data
validation drop down.
You will find second option. It automatically select the invalid data.
On Thu, Sep 13, 2012 at 8:13 PM, Paul Schreiner schreiner_p...@att.netwrote:
Circle Invalid?
Are you refering to a
@googlegroups.com
Subject: Re: $$Excel-Macros$$ Query - Circle Invalid...
I think it is excel 2010 version. When you goto Data tab, then select Data
validation drop down.
You will find second option. It automatically select the invalid data.
On Thu, Sep 13, 2012 at 8:13 PM, Paul Schreiner
Hi Hemant,
Here is a workaround. Please change it accordingly
Sub GenerateAutoNumber()
Dim lngPreviousNo as long
lngpreviousNo = 1
lngpreviousNo = lngpreviousNo + 1
MsgBox lngpreviousNo
End sub
Regards,
Hi kenil,
Pls change accordg to your data.
=MAX(IF(B1:B70,B1:B7))
=MIN(IF(A1:A70,A1:A7))
On Tue, Aug 14, 2012 at 5:24 PM, Kenil Gala keni...@yahoo.com wrote:
hi all,
i have a query for finding maximum and minimum values.
i have written my query in the excel sheet attached. pls help me
Dear Kenil,
Without using ctrl+shfit+enter
You can also use..
=SUMPRODUCT(MIN(($D2:$G20)*($D2:$G2)))
=SUMPRODUCT(MAX(($D2:$G20)*($D2:$G2)))
On Tue, Aug 14, 2012 at 5:38 PM, vijayajith VA vijayajith...@gmail.comwrote:
On Tue, Aug 14, 2012 at 5:32 PM, vijayajith VA
...@gmail.com
Subject: Re: $$Excel-Macros$$ query for finding maximum and minimum values
To: excel-macros@googlegroups.com
Date: Tuesday, August 14, 2012, 12:27 PM
Dear Kenil,
Without using ctrl+shfit+enter
You can also use..
=SUMPRODUCT(MIN(($D2:$G20)*($D2:$G2)))
=SUMPRODUCT(MAX(($D2:$G20)*($D2:$G2
with a comment in another cell again,
Thanks and Regards.
--- On *Tue, 8/14/12, NOORAIN ANSARI noorain.ans...@gmail.com* wrote:
From: NOORAIN ANSARI noorain.ans...@gmail.com
Subject: Re: $$Excel-Macros$$ query for finding maximum and minimum values
To: excel-macros@googlegroups.com
Date: Tuesday
Yes Sir,
Perfect
Thanks a Ton.
Thanks Regards,
--- On Tue, 8/14/12, dguillett1 dguille...@gmail.com wrote:
From: dguillett1 dguille...@gmail.com
Subject: Re: $$Excel-Macros$$ query for finding maximum and minimum values
To: excel-macros@googlegroups.com
Date: Tuesday, August 14, 2012, 5:05
I am available for custom excel projects at only $75 hourly .
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Kenil Gala
Sent: Tuesday, August 14, 2012 12:20 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ query for finding maximum
Dear Hemant,
Lalit solution is nice
You can also check..
http://www.ozgrid.com/forum/showthread.php?t=58969
On Fri, Jul 13, 2012 at 4:51 PM, Excel Vba excelvba.lear...@gmail.comwrote:
Hi Group,
How can i declare a global variable for below mentioned.
Private sub abc()
dim sh as
Dear
If you want a variabler such that it will works for all the procedure
in a module use below.
dim sh as worksheet
dim rng as range
Private sub abc()
set sh = Thisworkbook.Sheets(Sheet1)
set rng = sh.range(a1:csh.range(crows.count).end(xlup).row)
End sub
or else If you want it access
NEI
Not enough information
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Excel Vba
Sent: Tuesday, July 10, 2012 8:42 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Query - AutoNumber
Hi Group,
I am trying to get a automatically generate a
can u give a idea
On Tue, Jul 10, 2012 at 7:52 PM, dguillett1 dguille...@gmail.com wrote:
NEI
Not enough information
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
*From:* Excel Vba excelvba.lear...@gmail.com
*Sent:* Tuesday, July 10, 2012 8:42 AM
Sorry, not enough info.
WHERE do you have the numbers?
how do you tell what the last number used was?
are the numbers actual NUMBERS or are they ALPHAnumeric? (like: A123456)
For instance,
if the numbers are all in column A,
AND THEY'RE NUMERIC
then you can use:
NextNo =
Thnaks Paul.
-
On Tue, Jul 10, 2012 at 8:00 PM, Paul Schreiner schreiner_p...@att.netwrote:
Sorry, not enough info.
WHERE do you have the numbers?
how do you tell what the last number used was?
are the numbers actual NUMBERS or are they ALPHAnumeric? (like:
*Someone please help me on this its important*
On Sun, Jul 1, 2012 at 10:17 PM, ashwani agnihotri
ashwani.agniho...@gmail.com wrote:
i just want to send a mail with a subject plz check to the email address
in column C for the rows in column B which i mark as done.
On Sun, Jul 1, 2012 at
assuming you have table in sheet1 like
name status email sham done a koul.ash...@gmail.com rahim done
bkoul.ash...@gmail.com
Abdul done c koul.ash...@gmail.com
nAME IN cOL A
status in col B
email in Col C
also visit http://www.rondebruin.nl/tips.htm to know more about oulook
automation
thank you very much for the help ashish [?]
On Mon, Jul 2, 2012 at 8:52 PM, ashish koul koul.ash...@gmail.com wrote:
assuming you have table in sheet1 like
name status email sham done a koul.ash...@gmail.com rahim done
bkoul.ash...@gmail.com
Abdul done c koul.ash...@gmail.com
nAME IN
What do you want to send in mail??
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ashwani agnihotri
Sent: 01 July 2012 9:49
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Query on Email
i just want to send a mail with a subject plz check to the email address in
column C for the rows in column B which i mark as done.
On Sun, Jul 1, 2012 at 10:02 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
What do you want to send in mail??b
** **
* *
*Regards*
*Rajan verma*
Dear Rakesh,
Can you provide a sample sheet.
Thanks Regards,
Prajakt Pande
+971551388482
**
On Mon, May 14, 2012 at 10:19 AM, Rakesh Kumar Sharma
rakeshks@gmail.com wrote:
Hi,
Plz suggest me how i can merge two excel files data to single sheet using
command prompt.
--
Thanks
Dear Rakesh,
you can use following code
Sub CommandButton1()
Sheets(your sheet name).Select 'first sheet from you will copy the data
Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select
Selection.Copy
Sheets(your sheet name).Select ' where you want to paste
Selection.PasteSpecial
May 2012 12:32
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Query for Merging two excel sheets using
Command Prompt
Dear Rakesh,
you can use following code
Sub CommandButton1()
Sheets(your sheet name).Select 'first sheet from you will copy the data
Range(Selection
Hi Aamir,
You can use SUBTOTAL formula accordingly.
for ex.:
Sum of visible cells :- =SUBTOTAL(A1:A100,109)
Regards,
Lalit Mohan
https://www.facebook.com/buzinesstransformation
On Sat, May 12, 2012 at 8:39 PM, Aamir Shahzad aamirshahza...@gmail.com wrote:
Dear Group,
How to pick the
CLTL+G
ALT+S
K
Enter
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Aamir Shahzad
Sent: 12 May 2012 8:40
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ query
Dear Group,
How
pick the values by vlookup or sumif only on visible cells.
On Sat, May 12, 2012 at 8:19 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
CLTL+G
ALT+S
K
Enter
* *
*Regards*
*Rajan verma*
*+91 7838100659 [IM-Gtalk]*
*From:* excel-macros@googlegroups.com [mailto:
Your desire is not clear. Provide a file with a complete explanation and
examples.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Aamir Shahzad
Sent: Saturday, May 12, 2012 10:31 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ query
pick
aamirshahza...@gmail.com
*Sent:* Saturday, May 12, 2012 10:31 AM
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ query
pick the values by vlookup or sumif only on visible cells.
On Sat, May 12, 2012 at 8:19 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
CLTL+G
ALT+S
K
@googlegroups.com
Subject: Re: $$Excel-Macros$$ query
Example file is attached.
On Sat, May 12, 2012 at 9:04 PM, dguillett1 dguille...@gmail.com wrote:
Your desire is not clear. Provide a file with a complete explanation and
examples.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille
]
On Behalf Of Aamir Shahzad
Sent: Saturday, May 12, 2012 10:31 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ query
Example file is attached.
On Sat, May 12, 2012 at 9:04 PM, dguillett1 dguille...@gmail.com wrote:
Your desire is not clear. Provide a file
Of Shaik Waheed
Sent: 01 May 2012 12:25
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Query.
Hi,
PFA
On Tue, May 1, 2012 at 11:53 AM, Pramod Kumar kumar.pramod03i...@gmail.com
wrote:
Hi Experts,
PLease solve my query.
I need age betbeen in two dated like as 2
Hi,
PFA
On Tue, May 1, 2012 at 11:53 AM, Pramod Kumar
kumar.pramod03i...@gmail.comwrote:
Hi Experts,
PLease solve my query.
I need age betbeen in two dated like as 2 year 3 Month)
--
Regards,
Pramod Kumar
Technocare Solution(TCS)
Rudrapur
+91 9927033573
Thanks...
On Tue, May 1, 2012 at 12:25 PM, Shaik Waheed waheedb...@gmail.com wrote:
Hi,
PFA
On Tue, May 1, 2012 at 11:53 AM, Pramod Kumar
kumar.pramod03i...@gmail.com wrote:
Hi Experts,
PLease solve my query.
I need age betbeen in two dated like as 2 year 3 Month)
--
Regards,
Go to data- remove duplicates
Krishnan
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Karan Singh karan1...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Mon, 19 Mar 2012 13:07:52
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject:
Dear Karan,
Please use below code..
Dim i, j As Integer
Application.ScreenUpdating = False
For i = 1 To Range(A65536).End(xlUp).Row
For j = 1 To Range(B65536).End(xlUp).Row
If Range(A i).Value = Range(B j).Value Then
Range(B j).Delete Shift:=xlUp
End If
Next j
Next i
Hi Karan,
Try Advanced filter and select Unique records..And you can Copy and paste
it in New Column..
[image: Inline image 1]
*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*
On Mon, Mar 19, 2012 at 1:07 PM, Karan Singh
=IF(B2SUMPRODUCT(MAX($B$2:$B$31*(($A$2:$A$31=A2)*($C$2:$C$31=main,Greater
than Main,)
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Aamir Shahzad
Sent: Saturday, March 10, 2012 11:31 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Query
Dear
=IF(B2SUMPRODUCT(MAX($B$2:$B$31*(($A$2:$A$31=A2)*($C$2:$C$31=main,Greater
than Main,)
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Aamir Shahzad
Sent: Sunday, March 11, 2012 1:27 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Query
could wrap it in an IF like I used above:
=IF($C2MAIN,formula,)
Asa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Aamir Shahzad
Sent: Saturday, March 10, 2012 11:28 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Query
Thanks Asa
Asa, My formula tested fine without the proposed change.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Asa Rossoff
Sent: Sunday, March 11, 2012 11:28 AM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Query
Hi Aamir,
You're welcome
No main will ever be than maximum main of course, but it will save
calculation time.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of dguillett1
Sent: Sunday, March 11, 2012 10:26 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Query
Hi Aamir,
Should there be only one main per ID? ID 1 has two mains.
This formula will give your desired result based on the sum of the MAINs for
a given ID:
=IF($C2MAIN,IF($B2SUMIFS($B$2:$B$16,$A$2:$A$16,$A2,$C$2:$C$16,MAIN),
Greater than Main,),)
This will use the average of the MAINs
Try this :
Sub Transformdata()
Dim rngCEll As Range
Dim rngRange As Range
Dim wksOutput As Worksheet
Set wksOutput = ThisWorkbook.Worksheets.Add
Set rngRange = ThisWorkbook.Worksheets(Query).Rows(1)
For Each rngCEll In rngRange.Cells
Application.ScreenUpdating =
Thanks Noorain Ansari Ji for the solution but it works is working with
this sheet only i.e if the column headings are having two same titles.
If I have to transform three or four columns to first three or four
columns then this macro will not work there. Please suggest any
formula or user form
Dear Mukesh,
Can you provide that worksheet, where macro is not running...
Please share workbook with group..
On Tue, Jan 31, 2012 at 7:17 PM, Mukesh Kumar mukeshka...@gmail.com wrote:
Thanks Noorain Ansari Ji for the solution but it works is working with
this sheet only i.e if the column
Try
Option Explicit
Sub copycolumstorowsSAS()
Dim i As Long
For i = 1 To Cells(1, Columns.Count).End(xlToLeft).Column Step 2
Cells(2, i).Resize(6, 2).Copy Cells(Rows.Count, 1).End(xlUp).Offset(1)
Next i
End Sub
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
@ Don Guillett
Dear sir, your macro after running giving wrong results, please check.
@ Noorain Ansari
Sir, macro after running showing error compile error. Sub or function not
defined.
Please note, i am having different workbooks in which some workbooks
contains 2 columns similar, some 3
Subject: Re: $$Excel-Macros$$ Query continuous copy paste
@ Don Guillett
Dear sir, your macro after running giving wrong results, please check.
@ Noorain Ansari
Sir, macro after running showing error compile error. Sub or function not
defined.
Please note, i am having different workbooks
Sub kTest()
Dim x, ka, k(), i As Long, n As Long, c As Long, j As Long, p As Long
With Worksheets(Query)
ka = .Range(a1).CurrentRegion
End With
With CreateObject(scripting.dictionary)
.comparemode = 1
For c = 1 To UBound(ka, 2)
If
Dear Kris,
Following error is coming after macro execution
Run time error '9':
Subscript out of range.
Please correct it.
Regards,
Mukesh kumar
On Tue, Jan 31, 2012 at 10:00 PM, Kris krishnak...@gmail.com wrote:
Sub kTest()
Dim x, ka, k(), i As Long, n As Long, c As Long, j As Long,
Sub Consolidator()
Dim rngSource As Range
Dim lngCols As Long, lngRows As Long
Set rngSource = Range(A1).CurrentRegion
lngRows = rngSource.CurrentRegion.Rows.Count - 1
For lngCols = 3 To rngSource.Columns.Count - 1 Step 2
rngSource.Cells(2, lngCols).Resize(lngRows,
Here's the working model. Have given a button for ease.
Sam Mathai Chacko
On Tue, Jan 31, 2012 at 10:21 PM, Sam Mathai Chacko samde...@gmail.comwrote:
Sub Consolidator()
Dim rngSource As Range
Dim lngCols As Long, lngRows As Long
Set rngSource = Range(A1).CurrentRegion
One of the header is 'No' instead of 'No.'
Correct the headers, it should work
Kris
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
Thanks a lot for solving my queries Ansari ji. But still one problem
knocking my mind that these macroes are suitable for respective problems i
have given i.e for two similar headers separate code for three similar
headers another coding is required so on.
Can u give common macro irrespective
Thanks very very much Sam Mathai Chacko sir. This was the resultant code i
was looking for. You are marvellous in excel sir.
Thanks again.
Regards,
Mukesh Kumar
On Wed, Feb 1, 2012 at 12:01 AM, Sam Mathai Chacko samde...@gmail.comwrote:
The code I gave was exactly for assigning any number of
Hello group,
there is other way to translate.
Anil
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may
Dear Anil,
Attached file format is same as you posted previous. All Fonts are in Hindi.
--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/
On Fri, Jan 20, 2012
Yes sir, this same file, How can i do plz tell me.
I have to translate that data in english
Anil
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need
Do you want to translate data or just want to change format ??
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of anil kumar
Sent: Jan/Fri/2012 04:23
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ query about translate
Yes sir
I want to translate all name and add. in english
anil
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or
Dear Noorain
Anil want to do like under written
Jh yksds'k dqekj vxzoky to Shri Lokesh Kumar Aggarwal
From: NOORAIN ANSARI noorain.ans...@gmail.com
To: excel-macros@googlegroups.com
Sent: Friday, 20 January 2012 2:13 PM
Subject: Re: $$Excel
I think no way in excel without use of any other software
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of anil kumar
Sent: Jan/Fri/2012 06:12
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ query about translate
I want
Of *anil kumar
*Sent:* Jan/Fri/2012 06:12
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ query about translate
** **
I want to translate all name and add. in english
anil
--
FORUM RULES (986+ members already BANNED for violation
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Alberto
Sent: Monday, January 02, 2012 8:32 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Query from URL
Hi,
I use VBA to retrieve wheather data.
This work:
With
Thanks Sam,
I think my problem is solved.
Regards,
Suyog
On Wed, Nov 16, 2011 at 12:01 AM, Sam Mathai Chacko samde...@gmail.comwrote:
=IF(IFERROR(DATE(YEAR(G23),MONTH(G23),DAY(G23))=G23,0),MONTH(G23)-IF(DAY(G23)=1,0,DAY(G23)),G23)
Regards,
Sam Mathai Chacko
On Tue, Nov 15, 2011 at 3:28
Hello Noorain,
Thanks for quick response but I've added two problems in same excel.
Please review advice.
Suyog
On Tue, Nov 15, 2011 at 3:14 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Suyog,
Please see attached sheet.
--
Thanks regards,
Noorain Ansari
=IF(IFERROR(DATE(YEAR(G23),MONTH(G23),DAY(G23))=G23,0),MONTH(G23)-IF(DAY(G23)=1,0,DAY(G23)),G23)
Regards,
Sam Mathai Chacko
On Tue, Nov 15, 2011 at 3:28 PM, Suyog Kulkarni suyog.kulka...@yahoo.comwrote:
Hello Noorain,
Thanks for quick response but I've added two problems in same excel.
Dear Mr. Modi,
Attached is the soln. pl chk if this is ok.
Regards,
Andy
On Sat, Nov 12, 2011 at 12:09 PM, L.K. Modi ca.mod...@gmail.com wrote:
Dear All members,
I am attaching herewith a file regarding tds and the requirement is
mention in that file related to subtotal and conditions.
HI Ankit,
Find the attachment.
On Tue, Oct 25, 2011 at 9:42 AM, Ankit Agrawal
ankit.agrawal...@gmail.comwrote:
Dear Expert,
Plz solve out attached query.
Regards,
Ankit
--
--
Some important links for
Dear Ankit,
Please try below formula...
=LIQ/EE/INV/1112/SUMPRODUCT(--($C$5:C5=C5))
=LIQ/EE/INV/1112/COUNTIF($C$5:C5,C5)
--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/*
SUBSTITUTE(F1TEXT(G1,ddmmyyy), ,)
On Thu, Jul 28, 2011 at 5:13 PM, Hari harisha.prabha...@gmail.com wrote:
dear members,
can any one solve my query with help of formula, i am very poor in MS
excel.
find the attachement, reply at the earliest.
Thanks in advance,
have a nice day.
--
Thanks a lot dear
On 28 July 2011 18:32, ashish koul koul.ash...@gmail.com wrote:
SUBSTITUTE(F1TEXT(G1,ddmmyyy), ,)
On Thu, Jul 28, 2011 at 5:13 PM, Hari harisha.prabha...@gmail.com wrote:
dear members,
can any one solve my query with help of formula, i am very poor in MS
excel.
find
=*LOOKUP*
(D16,{3001,5001,6001,7001,8001,9001,15001,25001,40001},{30,40,45,50,60,110,130,150,200})
or..
=*VLOOKUP*(D16,$A$1:$B$9,2,TRUE)
the above VLookUp fungtion refers to a table
*tabel A1:B9*
* 3001 30 *
* 5001 40 *
* 6001 45 *
* 7001 50*
* 8001 60*
* 9001 110*
*15001 130*
You can use Vlookup formula as shown in attachment.
Regards,
Modh
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Kal xcel
Sent: Wednesday, July 06, 2011 4:56 PM
To: excel-macros@googlegroups.com
Cc: Dave Bonallack; NOORAIN ANSARI; Ashish Koul
Subject:
Ww
NOORAIN ANSARI noorain.ans...@gmail.com escreveu:
Dear Experts..
Please find attached query sheet...I want to add a seperate row after every
semicolon..
Please see attached sheet..
--
Thanks regards,
Noorain Ansari
--
There is no attachment
On Thu, Feb 24, 2011 at 6:33 PM, Joao Matoso jcmat...@gmail.com wrote:
Ww
NOORAIN ANSARI noorain.ans...@gmail.com escreveu:
Dear Experts..
Please find attached query sheet...I want to add a seperate row after
every
semicolon..
Please see attached sheet..
--
Thanks Ashish, Its nice, please explain how this formula is working
On Thu, Feb 17, 2011 at 5:29 AM, ashish koul koul.ash...@gmail.com wrote:
Maximum 4 classifications
1) Regular
2) Substandard
3) Doubtful
4) Loss
On Tue, Feb 15, 2011 at 8:34 PM, ashish koul koul.ash...@gmail.com wrote:
will it be these three classifications only
On Tue, Feb 15, 2011 at 8:35 PM, Aamir Shahzad
aamirshahza...@gmail.comwrote:
Thanks *Ashish *for
Thanks *Ashish *for reply but can you please provide formula without pivot.
Condition you have understand that if sum of any classification is grater
then others,it shows that value.
On Tue, Feb 15, 2011 at 8:14 AM, ashish koul koul.ash...@gmail.com wrote:
On Tue, Feb 15, 2011 at 12:16 AM,
will it be these three classifications only
On Tue, Feb 15, 2011 at 8:35 PM, Aamir Shahzad aamirshahza...@gmail.comwrote:
Thanks *Ashish *for reply but can you please provide formula without
pivot. Condition you have understand that if sum of any classification is
grater then others,it shows
On Tue, Feb 15, 2011 at 12:16 AM, Aamir Shahzad aamirshahza...@gmail.comwrote:
Hi all experts,
Please resolve my query by formula. sheet attached.
Regards,
Aamir Shahzad
--
--
Some important links for
Hi Thamu,
I don't know what is the need for the comparison of 2003 2007 excel column
versions since the query is not very much related to the 2003 column issue.
I agree that the column will be the issue in Excel 2003 when the repetition
of UNIQUE IDNO goes beyond 127 times then we could not
101 - 200 of 218 matches
Mail list logo