Dear Seraj,
Please check attached sheet, There is no solution in it.
On Thu, Jul 12, 2012 at 9:51 AM, joseph camill joseph.cam...@gmail.comwrote:
Hi Seraj,
Attached is the reference sheet.
Thanks,
Joseph
On Thu, Jul 12, 2012 at 9:15 AM, Seraj Alam seraj.ala...@gmail.comwrote:
Hi,
Dear Joseph,
Please try it..
Sub Unique_List_Creater()
Dim i As Long
Dim col As Long
Dim rw As Long
Dim sh As Worksheet
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
Set sh = ThisWorkbook.Sheets(3)
sh.Range(F2:F sh.Cells(Rows.Count, F).End(xlUp).Row).
Hi Don,
Thanks a lot for this,
Regards,
Pawel
From: dguillett1 dguille...@gmail.com
To: excel-macros@googlegroups.com
Sent: Wednesday, July 11, 2012 1:13 PM
Subject: Re: $$Excel-Macros$$ switch on anf off calculation
sub
yourmacro()
Dear Ashish,
You can also use..
*=ROUND(A2/5,0)*5
*
--
Thanks regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Thu, Jul 12, 2012 at 9:35 AM, Ashish Bhalara
ashishbhalar...@gmail.comwrote:
Dear experts,
I want to round the value in following condition.
If
Hi Expert,
Can any one provide me currency name with symbol.
Divaker
--
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
Dear all,
Can you please help me to find out the total number of boy and girl ? I
used countif for their grade and it worked. However, for girl and boy
seggregation it isnot working.
Thank you very much for the support you all have been providing.
sunita
--
FORUM RULES (986+ members already
i learn lot of command, thanks noorainansarihttp://www.noorainansari.com/
sir.
On Thu, Jul 12, 2012 at 1:28 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Ashish,
You can also use..
*=ROUND(A2/5,0)*5
*
--
Thanks regards,
Noorain Ansari
www.noorainansari.com
Dear Sunita,
Find the attached sheet.
Regards,
Kuldeep Singh
naukrikuld...@gmail.com || www.naukri.com
*Please* *Consider the environment. Please don't print this e-mail unless
you really need to.*
On Thu, Jul 12, 2012 at 2:59 PM, सुनिता पौडेल tosune...@gmail.com wrote:
wow thnx...
is there
You can use COUNTIFS function.
Regards,
Krishnaraddi V Madolli.
Data Analytics Team
Sedgwick Claims Management Services, Inc.
Xchanging Towers, SJR iPark,
EPIP Area, Whitefield
Bangalore - 560 066. India.
Direct Line: +1.800.920.9657 Extn 1915
Switchboard: +90-(0)80-3054 Extn 1915
Email:
Hi Sunita,
You can also *try..
=SUMPRODUCT(--($E$10:E49=GIRL))*
On Thu, Jul 12, 2012 at 2:54 PM, सुनिता पौडेल tosune...@gmail.com wrote:
Dear all,
Can you please help me to find out the total number of boy and girl ? I
used countif for their grade and it worked. However, for girl and boy
You Can also use..
*=DCOUNTA($E$9:$E$49,E9,G1:G2)*
See attached sheet.
On Thu, Jul 12, 2012 at 3:04 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Hi Sunita,
You can also *try..
=SUMPRODUCT(--($E$10:E49=GIRL))*
On Thu, Jul 12, 2012 at 2:54 PM, सुनिता पौडेल tosune...@gmail.com wrote:
It's only my pleasure,
On Thu, Jul 12, 2012 at 3:00 PM, jmothilal gjmothi...@gmail.com wrote:
i learn lot of command, thanks noorainansarihttp://www.noorainansari.com/
sir.
On Thu, Jul 12, 2012 at 1:28 PM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
Dear Ashish,
You can also use..
wohoo so may options thnx guys ..it really worked out
thank you so much
Sunita
On Thu, Jul 12, 2012 at 3:25 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
You Can also use..
*=DCOUNTA($E$9:$E$49,E9,G1:G2)*
See attached sheet.
On Thu, Jul 12, 2012 at 3:04 PM, NOORAIN ANSARI
Dear friends,
I want to call a function/formula here that show me the sum of the each
item separately from the given descriptions.
Regards,
Muneer,
CC.
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like
PFA
On Thu, Jul 12, 2012 at 3:53 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
see attached sheet.
On Thu, Jul 12, 2012 at 3:53 PM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
Dear Muneer,
Please use below formula
=SUMPRODUCT((A2:A8=D5)*(B2:B8))
or
=Sumif(A2:A8,d5,B2:B8)
Hi Friends,
Could you please help in counting the name in a column.
Thanks
N.Sundarvelan
9600160150
--
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
Dear Sundar,
Please use..
=*COUNTIF(B:B,*C2*)*
On Thu, Jul 12, 2012 at 4:12 PM, Sundarvelan N nsund...@gmail.com wrote:
Hi Friends,
Could you please help in counting the name in a column.
Thanks
N.Sundarvelan
9600160150
--
FORUM RULES (986+ members already BANNED for violation)
1)
Dear Prashant,
Please use
=INDEX($A$2:$A$4,1)
or
=OFFSET($A$1,1,0)
see attached sheet.
On Thu, Jul 12, 2012 at 4:50 PM, Prashant Pawle ppawle.ex...@gmail.comwrote:
Dear All,
Need a formula for getting first text in the Range, in particular cell ,
sample file attached
Regards,
Dear noor,
Please let me know the formula if first cell is empty Then it shd take next
cell in array
Regards,
Prashant
On Thu, Jul 12, 2012 at 3:23 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Prashant,
Please use
=INDEX($A$2:$A$4,1)
or
=OFFSET($A$1,1,0)
see attached
Dear Prashant,
You can try..
*=OFFSET($A$1,COUNTIF($A$2:$A$4,),0)*
On Thu, Jul 12, 2012 at 5:04 PM, Prashant Pawle ppawle.ex...@gmail.comwrote:
Dear noor,
Please let me know the formula if first cell is empty Then it shd take
next cell in array
Regards,
Prashant
On Thu, Jul 12, 2012
Thanx Noor for this also,
But I need to change the description in same cell to get individual
total.
Sewage/Sweet/Garbage all this totals from one cell.
Hope u understand this time.
Regards,
Muneer,
CC...
see attached sheet.
On Thu, Jul 12, 2012 at 3:53 PM, NOORAIN ANSARI
Thanks noorain jee, its working fine! Please make me sure about crireria
field why should we put c2.
Regards,
@Suman
Send on the move with Galexy y.
On Jul 12, 2012 4:15 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote:
Dear Sundar,
Please use..
=*COUNTIF(B:B,*C2*)*
On Thu, Jul 12, 2012
Dear Nitin,
you can join group through below link...
http://groups.google.com/group/excel-macros/subscribe
On Thu, Jul 12, 2012 at 5:32 PM, Nitin Updhyay
nitinupadhyay2...@gmail.comwrote:
Hi,
Please add my mail id in your group
nitin.upadh...@in.aegisglobal.com
--
FORUM RULES (986+
Dear Suman,
Please see attached sheet,
Cell C2 is criteria Field
On Thu, Jul 12, 2012 at 5:30 PM, Suman ksuman1...@gmail.com wrote:
Thanks noorain jee, its working fine! Please make me sure about crireria
field why should we put c2.
Regards,
@Suman
Send on the move with Galexy y.
On Jul
Thanks Guru jee its great!
On Thu, Jul 12, 2012 at 4:25 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Group,
Please find attached screen shot, We can remove 0 from whole workbook
without using any function or any Macro.
See technique and revert.
--
Thanks regards,
Noorain
Hi, Noorain
I am not able to do this.. Link not working for new ID.. Please add my
outlook id as well
nitin.upadh...@in.aegisglobal.com
On Thu, Jul 12, 2012 at 5:33 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Nitin,
you can join group through below link...
Why not just elect in advanced options to NOT show zeros for the workbook?
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: NOORAIN ANSARI
Sent: Thursday, July 12, 2012 5:55 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Remove 0 from Whole
Dear Nitin,
Send a mail to group Manager Mr. Ayush Jain
Email ID is :jainayus...@gmail.com
nitin.upadh...@in.aegisglobal.com
On Thu, Jul 12, 2012 at 5:39 PM, Nitin Updhyay
nitinupadhyay2...@gmail.comwrote:
Hi, Noorain
I am not able to do this.. Link not working for new ID.. Please add
So exactly what you are looking for? A drop down list to show the total in
adjacent column?
I have created a dropdown, if you looking for somthing else, then please
explain a bit more
On Thu, Jul 12, 2012 at 5:21 PM, Mohammed Muneer mmun...@ccc.com.qa wrote:
Thanx *Noor *for this also,
Hi Noorain,
Thanks for resolving the query. Now i got the correct result.
Regards
Lokesh.M
On Thu, Jul 12, 2012 at 9:04 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Lokesh,
Please find the attached sheet, Hope it will help to you.
--
Thanks regards,
Noorain Ansari
What type of solution are you looking for? (VBA macro, Excel function)
What is the source of the list? (text file, excel sheet)
What do you want to do with the result? (use in macro, output to
Excel worksheet)
Paul
-
“Do all the good you can,
By all the
I received a spreadsheet that is using the R1C1 reference formula. If I
turn turn off the R1C1 to apply the A1 reference will that then change how
the formula works?
Thanks !
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread
I implemented this now
Private Sub corrermac()
Sheets(Datas).Select
If Range(B1).Value = Range(C1).Value Then
Call julho
ElseIf Range(B2).Value = Range(C2).Value Then
Call agosto
End Sub
Sub julho()
Sheets(Dias acidente).Select
Range(B2:B32).Select
Selection.ClearContents
Sheets(Dias
How about a macro
Sub GetMaxPerCategory()
Columns(e:f).ClearContents
For Each c In Range(a2:a8)
Name = Split(c, /)(0) / Split(c, /)(1)
n = Split(c, /)(2)
Set mf = Columns(e).Find(What:=Name, LookIn:=xlValues, _
LookAt:=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext)
If Not mf
Try it
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Sunnie
Sent: Thursday, July 12, 2012 8:43 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ R1C1
I received a spreadsheet that is using the R1C1 reference formula. If I turn
turn off the
Sunnie, Can you share spreadsheet with group as a sample.
--
Thanks regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Thu, Jul 12, 2012 at 7:13 PM, Sunnie sunni...@gmail.com wrote:
I received a spreadsheet that is using the R1C1 reference formula. If I
Hi,
Use this array formula to get 1st filled cell value in a range.hope it will
help you
=INDEX($A$1:$A$5,LARGE(--(A1:A5)*ROW(A1:A5),SUM(--(A1:A5))),1)
Priti verma
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of NOORAIN ANSARI
Sent: 12
Dear any one
I am using sheet1 worksheet column a to n , Column width is differents
based on datas. same data format different places up 20 sheets.
i want align sheet 2 to 20 column width based on sheet1.
Thanks with
--
*J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex
Hi Mothi,
Please attach your workbook, your question is not clear.
regards
prince
On Thursday, 12 July 2012 20:48:49 UTC+5:30, mothi wrote:
Dear any one
I am using sheet1 worksheet column a to n , Column width is differents
based on datas. same data format different places up 20 sheets.
Thanks Noorain,
Can you give me a formula to retrieve this.
Thanks,
Joseph
Sent on my BlackBerry® from Vodafone
-Original Message-
From: NOORAIN ANSARI noorain.ans...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Thu, 12 Jul 2012 11:47:55
To: excel-macros@googlegroups.com
hi Prashant,
Use this
=INDEX(A2:A4,MATCH(TRUE,LEN(A2:A4)0,0),1) with Ctrl+shift+enter
regards
prince dubey
On Thursday, 12 July 2012 16:50:22 UTC+5:30, ppawle.excel wrote:
Dear All,
Need a formula for getting first text in the Range, in particular cell ,
sample file attached
Regards,
=SUMPRODUCT((TRIM(A2:A22)={sewage,sweet,garbage})*(B2:B22))
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Mohammed Muneer
Sent: Thursday, July 12, 2012 6:51 AM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Sumif / Sumproduct formula
Dear Mothi,
Please share sample workbook with group
On Thu, Jul 12, 2012 at 9:37 PM, Prince Dubey prince141...@gmail.comwrote:
Hi Mothi,
Please attach your workbook, your question is not clear.
regards
prince
On Thursday, 12 July 2012 20:48:49 UTC+5:30, mothi wrote:
Dear any one
I
You can get this done by changing language regional settings of your PC.
Thanks,
Joseph
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Dileep Kumar deepuk...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Thu, 12 Jul 2012 19:30:18
To: excel-macros@googlegroups.com
Are you wanting to do this manually?
or with a macro?
To do it manually,
1. Select the sheets you want updated.
2. Select Sheet1
3. Right-click on the first column to change
4. Select Column Width from the menu
5. Hit OK (or change the ## and hit OK)
Repeat steps 3-5 for all columns...
45 matches
Mail list logo
