Dear Noorain Sir,
Thanks for your valuable support.
Thanks
Ashish Kumar
On Thursday, January 10, 2013 1:13:59 PM UTC+5:30, NOORAIN ANSARI wrote:
Dear Ashish,
You can try,,
For date
=date(year(a1),month(a1),day(a1)
and press ctrl+shift+#
For time
=date(Hour(a1),minute(a1),second(a1)
Dear Senior,
Thanks for your reply support. I'll keep this in my mind for better
future assistance.
Thanks
Ashish kumar
On Thursday, January 10, 2013 1:03:01 PM UTC+5:30, Ms-Exl-Learner wrote:
Please make it in an excel workbook and send it to us for our better
understanding of your
With Array you can also use..
*=MAX(IF($A$4:$A$9567=A4,$B$4:$B$9567,))*
press ctrl+shift+Enter
On Thu, Jan 10, 2013 at 12:17 PM, ravinder negi ravi_colw...@yahoo.comwrote:
you can use =DMAX(database,field,criteria)
--- On *Thu, 1/10/13, Ms-Exl-Learner ms.exl.lear...@gmail.com* wrote:
Dear Kasper,
You can also use below code for Ms. Excel All version (2003+)
Sub Remove_Duplicates()
With Sheet2
.Range(A1:A .Cells(Rows.Count, A).End(xlUp).Row).AdvancedFilter
Action:=xlFilterCopy, copytoRange:=.Range(C1), unique:=True
End With
End Sub
--
With Regards,
Noorain Ansari
http://
Dear Karthik,
your query is solvedpls check it.
Thanks
Ashish Kumar
On Wednesday, January 9, 2013 8:07:11 PM UTC+5:30, karthik n wrote:
Dear Help
Please help for below attached file.
--
*Regards*
--
Join official Facebook page of this forum @
Hi,
PFA the file which shows distance in KMS between different places.
First Table 'Data' mentions the kms from one place to another and total kms
from starting place to ending place.
Is it possible to get all probabilities of places in the second table with
the kms derived from the first table
Hi Team,
I need to write a macro on the attached template Cartogram where I can
adjust a value and the size of countries in a map of the world changes (but
their vague position stays the same)...
Thanks a ton for the help!
Sri
--
Join official Facebook page of this forum @
Hi,
Can any one help on this
-- Forwarded message --
From: Smitha S R sperdwo...@gmail.com
Date: Thu, Jan 10, 2013 at 2:52 PM
Subject: $$Excel-Macros$$ Probability
To: excel-macros@googlegroups.com
Hi,
PFA the file which shows distance in KMS between different places.
First
Are you sure about the output you mentioned in attached file. or output
will be
Starting Place A
Starting place B
Starting place C
Starting place D
Starting place Ending Place
A B
A C
A D
B A
B C
B D
B Ending Place
C A
C B
C D
C Ending Place
D A
D B
D C
D Ending Place
Regards,
Lalit Mohan
Hi Experts,
In the attached, i have a list of items, some are repetitive in the list,
if i want to find the relative position of each item what formula can be
helpful, the normal match will for instance if an item appears twice in
different positions will only give me the position of the first
Dear excel guru,
I want to copy only the 2nd sheet of the all workbooks from a particular
folder. Please accordingly rectify the below mentioned code which I also got
this forum.
Option Explicit
'32-bit API declarations
DeclareFunction SHGetPathFromIDList Lib shell32.dll _Alias
=MAX(IF(A1:A8=D1,ROW(A1:A8),))
with CSE
On Thu, Jan 10, 2013 at 4:41 PM, Hilary Lomotey resp...@gmail.com wrote:
Hi Experts,
In the attached, i have a list of items, some are repetitive in the list,
if i want to find the relative position of each item what formula can be
helpful, the normal
Don't use differnt mails.
REgards,
Pankaj
On Thu, Jan 10, 2013 at 2:22 PM, Prabhakar S H prabakar.k...@gmail.comwrote:
Hi Prince,
Its not working.
Can you send me example with this formula.
Rgds,
Prabhakar
On Sunday, January 6, 2013 9:33:55 AM UTC+5:30, Prince wrote:
yes it is
I have not received any answer.
Regards,
Pankaj
On Tue, Jan 8, 2013 at 7:56 PM, pankaj gmail account
pankaji...@gmail.comwrote:
Dear Prince and Lalit Thanks for response.
what i wanted in a excel file:-
Student ID Class SubjectMarks(Mandatory)
123
Dear Champs,
i need one excel formula help tat with conditional format formula.
i tried if and if error but mistake but exact values are not received.
plz any one help me
please find the example sheet.
need urgent any one plz help me.
--
Regards,
Shiva
--
Join official Facebook page
Ok Pankaj
i can only reply in evening.
regards
Prince
On Thursday, January 10, 2013 5:02:06 PM UTC+5:30, Pankaj wrote:
Don't use differnt mails.
REgards,
Pankaj
On Thu, Jan 10, 2013 at 2:22 PM, Prabhakar S H
prabak...@gmail.comjavascript:
wrote:
Hi Prince,
Its not working.
Thanks Viper
This is not what i require, i will try and explain again sorry if i didnt
explain properly, your formula only produces the max ordinal position,
assuming Moda is in the first , fifth and tenth row, and in the data
validation drop down i select say Moda in the first row, i expect the
Hi Hilary,
I hope this will may help you
=MAX(SUM((A1:A8=D1)*1)) with CSE (:
Regards
Prince
On Thursday, January 10, 2013 4:41:12 PM UTC+5:30, hilary lomotey wrote:
Hi Experts,
In the attached, i have a list of items, some are repetitive in the list,
if i want to find the relative
Hi,
I need mix of all the places with the kms derived from the data table
for eg:
Data is:
A to B is 15
B to C is 2
C to D is 3
A to D is 20
I require:
A to B 15
B to A 15
B to C 2
C to B 2
C to D 3
D to C 3
B to D 5
D to B 5
C to A 17
A to C 17
A to D 17
D to A 17
On Thu, Jan 10, 2013 at 4:40
*In F1 cell *- _*Non Array formula *_
*=LOOKUP(2,1/(A1:A8=D1),ROW(A1:A8))*
OR
*=SUMPRODUCT((MAX((A1:A8=D1)*ROW(A1:A8*
On 10-01-2013 4:41 PM, Hilary Lomotey wrote:
Hi Experts,
In the attached, i have a list of items, some are repetitive in the
list, if i want to find the relative
Very Graeful Prince
But i guess i didnt explain myself properly, i will try and again
Assuming Moda appears in the First, Fifth and tenth Row, if i select Moda
from the the data validation drop down ie the first moda, i expect to see
1, if i select Moda from the fifth row, i expect to see 5 and
This is a rather rudimentary conversion of Roman numerals into Arabic
(inverse of ROMAN function in Excel 2010)
Just copy the code and paste it into a new module. then in excel cell, type
= Arabic(xxx) where xxx is the Roman numeral (e.g. MMDX)
--
Join official Facebook page of this forum @
This is a rudimentary (and not thoroughly checked) graphical representation
of data as a boxplot. It does not check the outliers using Grubb's test
however shows outliers that are farther than 1.5 IQR.
Looking for ideas on improving it.
Copy and paste the code into a new module and run the
Forgot to say:
You need to select at least one column with at least 5 rows, excluding the
title row (which also needs to be selected)
On Thursday, January 10, 2013 12:57:01 PM UTC+1, Adrian Teodorescu wrote:
This is a rudimentary (and not thoroughly checked) graphical
representation of data
Very Grateful Exl. learner
But i guess i didnt explain myself properly, i will try and again
Assuming Moda appears in the First, Fifth and tenth Row, if i select Moda
from the the data validation drop down ie the first moda, i expect to see
1, if i select Moda from the fifth row, i expect to see
Hi Hilary,
See attached sheet, Hope it will help to you..
--
With Regards,
Noorain Ansari
http://
http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com
http://
http://www.excelvbaclinic.blogspot.comexcelvbaclinic.comhttp://www.excelvbaclinic.blogspot.com
On Thu, Jan 10,
Thanks Noorain,
for what am trying to do, i need a formula instead. But that is the exact
principle of what i was explaining. thanks
On Thu, Jan 10, 2013 at 12:03 PM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
Hi Hilary,
See attached sheet, Hope it will help to you..
--
With Regards,
What you're asking is not possible without helper column.
here is my openior. PFA
On Thu, Jan 10, 2013 at 5:39 PM, Hilary Lomotey resp...@gmail.com wrote:
Thanks Noorain,
for what am trying to do, i need a formula instead. But that is the exact
principle of what i was explaining. thanks
Hi Noorain
Can you please help me on this.
-- Forwarded message --
From: Smitha S R sperdwo...@gmail.com
Date: Thu, Jan 10, 2013 at 5:18 PM
Subject: Re: $$Excel-Macros$$ Probability
To: excel-macros@googlegroups.com
Hi,
I need mix of all the places with the kms derived from
Thanks Viper i thinks its a good idea, i can do some modification and see
what happens but its a great step for me, thanks to every one who assisted.
thanks so much
On Thu, Jan 10, 2013 at 12:30 PM, The Viper viper@gmail.com wrote:
[image: Boxbe] https://www.boxbe.com/overview This message
Hi All... Thanks a lot for the reply. :)
Regards
Karan
On Wednesday, 9 January 2013 15:35:50 UTC+5:30, karan wrote:
Hi
Can anyone pls let me know how do i get the max value or date (using a
formula and not pivot) from the database that i have.
Attached is the database.
Thanks.
plz provide any one this solution.
On Thu, Jan 10, 2013 at 11:39 AM, Shiva Prasad shivaprasad1...@gmail.comwrote:
Dear Champs,
i need one excel formula help tat with conditional format formula.
i tried if and if error but mistake but exact values are not received.
plz any one help me
Hi Group,
Can you please share the consolidated Excel tips. I need to educate some
users who are new to excel. Required tips on Basic Excel Advanced Excel.
With Regards,
PMadaiah
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use
Dear shiva,
Please explain more.we are bit confuse in
TAT Complete and before TAT but not complete.
On Thu, Jan 10, 2013 at 9:06 PM, Shiva Prasad shivaprasad1...@gmail.comwrote:
plz provide any one this solution.
On Thu, Jan 10, 2013 at 11:39 AM, Shiva Prasad
Dear Harshad,
Please try..
--
With Regards,
Noorain Ansari
http://
http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com
http://
http://www.excelvbaclinic.blogspot.comexcelvbaclinic.comhttp://www.excelvbaclinic.blogspot.com
On Fri, Jan 4, 2013 at 2:52 PM, Prince
Congratulations Prince Kumar
Congratulations on receiving a certificate of honorary awards help to
members in the professional forum through excel. I really appreciate
your knowledge.
2013/1/11, Ayush Jain jainayus...@gmail.com:
Dear members,
Prince Kumar has been selected as 'Most Helpful
Congrates chief keep it up
On Jan 10, 2013 7:58 PM, Bé Trần Văn betnmtdongna...@gmail.com wrote:
[image: Boxbe] https://www.boxbe.com/overview This message is eligible
for Automatic Cleanup! (betnmtdongna...@gmail.com) Add cleanup
Congrats Pricekeep helping man...
On Thursday, 10 January 2013 22:19:58 UTC+5:30, Ayush Jain wrote:
Dear members,
Prince Kumar has been selected as 'Most Helpful Member' for the month of
Dec'12. He has posted 92 posts last month and helped forum members through
his excel expertise.
I
Many congratulations to u Prince...
Sent from my BlackBerry® smartphone from !DEA
-Original Message-
From: Ayush Jain jainayus...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Thu, 10 Jan 2013 22:19:58
To: excel-macrosexcel-macros@googlegroups.com
Reply-To:
Congrats Prince
On Fri, Jan 11, 2013 at 9:19 AM, p.dhamsa...@gmail.com wrote:
**
Many congratulations to u Prince...
Sent from my BlackBerry® smartphone from !DEA
--
*From: * Ayush Jain jainayus...@gmail.com
*Sender: * excel-macros@googlegroups.com
Hi Myself Harish,
I am from INDIA,
i am a civil engineer
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and
Hi Shiva,
I guess you need to explain the problem with an example as it is not clear
to us what actually we needs to do.
Regards
prince
On Thursday, January 10, 2013 5:09:20 PM UTC+5:30, shivapr...@gmail.com
wrote:
Dear Champs,
i need one excel formula help tat with conditional format
Welcome Harish (:
regards
Prince
On Friday, January 11, 2013 9:57:39 AM UTC+5:30, harish.yog...@gmail.com
wrote:
Hi Myself Harish,
I am from INDIA,
i am a civil engineer
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use
Hi Hilary,
What i think is instead of just validation list box you should pick
combobox of form control and then link its itm index with a cell that give
you ur expected output.
so please follow the below mentioned steps.
Goto developer tab-Insert-Select Combobox Control-Draw it on ur
Hi Sir,
Myself sundar from chennai, First i would appreciate on your brief
explanation for MIS role, it is very clear to understand.
i have been working as HR for past 3 Years, but my role as HR is not
satisfying me. I was looking for a change where i don't interact with
people much, and so i
Nice Stuff Noorain Bhai.
On Thursday, January 10, 2013 11:35:01 PM UTC+5:30, NOORAIN ANSARI wrote:
Dear Putta,
See attachments, Hope it will help to you.
--
With Regards,
Noorain Ansari
http://
http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com
http://
Hi,
How to merge data in two excel worksheets to another work sheet
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code
Congrats Prince Babu...
--
With Regards,
Noorain Ansari
http://
http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com
http://
http://www.excelvbaclinic.blogspot.comexcelvbaclinic.comhttp://www.excelvbaclinic.blogspot.com
On Thu, Jan 10, 2013 at 10:19 PM,
Hi Smitha,
can share a sample with group.
On Fri, Jan 11, 2013 at 11:04 AM, Smitha S R sperdwo...@gmail.com wrote:
Hi,
How to merge data in two excel worksheets to another work sheet
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1)
HI,
Data for the first jan is in one sheet and data for second jan is another
sheet.
I have to get data in another worksheet for both dates.
On Fri, Jan 11, 2013 at 11:05 AM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
Hi Smitha,
can share a sample with group.
On Fri, Jan 11, 2013 at
Try this
Sub merge1()
Dim i As Long, z As Long
' add new sheet at last and name it merge
Sheets.Add After:=Sheets(Sheets.Count)
Sheets(Sheets.Count).Name = Merge
For i = 1 To Sheets.Count - 1
' add headers from first sheet
If i = 1 Then
' find last filled row in the sheet
z =
@S R try this one
Sub merge1()
Dim i As Long, z As Long
' add new sheet at last and name it merge
Sheets.Add After:=Sheets(Sheets.Count)
Sheets(Sheets.Count).Name = Merge
For i = 1 To Sheets.Count - 1
' add headers from first sheet
If i = 1 Then
' find last filled row in the sheet
z =
HI,
Is this possible without macros
On Fri, Jan 11, 2013 at 11:12 AM, ashish koul koul.ash...@gmail.com wrote:
Try this
Sub merge1()
Dim i As Long, z As Long
' add new sheet at last and name it merge
Sheets.Add After:=Sheets(Sheets.Count)
Sheets(Sheets.Count).Name = Merge
For i = 1 To
Hi Jai,
I m not able to understand ur requirments. Please provide us at least on
example to what we needs to do.
Regards
Prince
On Friday, January 11, 2013 10:57:48 AM UTC+5:30, Jai Bhati wrote:
HI GUROPS MEMBER ,
PLEASE HELP REGARDING THIS SHEET .
--
Join official Facebook page of
Hi,
Please help
On Fri, Jan 11, 2013 at 11:14 AM, Smitha S R sperdwo...@gmail.com wrote:
HI,
Is this possible without macros
On Fri, Jan 11, 2013 at 11:12 AM, ashish koul koul.ash...@gmail.comwrote:
Try this
Sub merge1()
Dim i As Long, z As Long
' add new sheet at last and name it
heartly congratulations prince.
Warm Regards,
Gawli Anil
On Fri, Jan 11, 2013 at 11:04 AM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
Congrats Prince Babu...
--
With Regards,
Noorain Ansari
http://
http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com
Pl provide a meaningfull subject.
Warm Regards,
Gawli Anil
On Fri, Jan 11, 2013 at 10:57 AM, joginder kumar jaihumtu...@gmail.comwrote:
HI GUROPS MEMBER ,
PLEASE HELP REGARDING THIS SHEET .
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM
Hi Sandeep.
May be if this code help you.
Public Sub GetRawDataInWorkBook()
Dim objFso As Object: Dim objFolder As
Object
Dim objFileAs Object: Dim wbkSrcContact As
Workbook
Dim wbkSrcTarget As Workbook: Dim
Dear Satendrakumar,
use this =CONCATENATE(A1,B1,C1,D1)
if u want , in between.
or else share the workbook wit us.
Warm Regards,
Gawli Anil
On Fri, Jan 11, 2013 at 11:45 AM, Satendra kumar
satendrakuma...@gmail.comwrote:
Dear Expert,
Solve this query..i want automate colored range. if
HI,
is this possible..
On Fri, Jan 11, 2013 at 11:28 AM, Smitha S R sperdwo...@gmail.com wrote:
Hi,
Please help
On Fri, Jan 11, 2013 at 11:14 AM, Smitha S R sperdwo...@gmail.com wrote:
HI,
Is this possible without macros
On Fri, Jan 11, 2013 at 11:12 AM, ashish koul
dear
have you seen that lik i have provided
On Friday, January 11, 2013 11:58:33 AM UTC+5:30, Smitha S R wrote:
HI,
is this possible..
On Fri, Jan 11, 2013 at 11:28 AM, Smitha S R sperd...@gmail.comjavascript:
wrote:
Hi,
Please help
On Fri, Jan 11, 2013 at 11:14 AM, Smitha S R
NO,PLEASE send it once more
On Fri, Jan 11, 2013 at 12:14 PM, Prince prince141...@gmail.com wrote:
dear
have you seen that lik i have provided
On Friday, January 11, 2013 11:58:33 AM UTC+5:30, Smitha S R wrote:
HI,
is this possible..
On Fri, Jan 11, 2013 at 11:28 AM, Smitha S R
https://groups.google.com/forum/?hl=enfromgroups=#!searchin/excel-macros/merge/excel-macros/8T3EPECvA10/Y3vwNk6wM-YJ
On Friday, January 11, 2013 12:20:39 PM UTC+5:30, Smitha S R wrote:
NO,PLEASE send it once more
On Fri, Jan 11, 2013 at 12:14 PM, Prince prince...@gmail.comjavascript:
wrote:
Dear Anil,
i have large database so how to define colored range??
=IF(COUNTIF($I$2:I2,I2)=1,IF(T2=T3,CONCATENATE(O2,,,O3,,,O4,,,O5
),),)
On Fri, Jan 11, 2013 at 11:50 AM, अनिल नारायण गवली
gawlianil8...@gmail.comwrote:
Dear Satendrakumar,
use this =CONCATENATE(A1,B1,C1,D1)
if u want ,
Hi,
Any one please help me in combining the data in two different work sheets
in to another worksheet.
Its really urgent.
On Fri, Jan 11, 2013 at 12:30 PM, Smitha S R sperdwo...@gmail.com wrote:
It not working, run time error 1004 appears
On Fri, Jan 11, 2013 at 12:23 PM, Prince
It not working, run time error 1004 appears
On Fri, Jan 11, 2013 at 12:23 PM, Prince prince141...@gmail.com wrote:
https://groups.google.com/**forum/?hl=enfromgroups=#!**
Dear Prince,
Congratulations my friend, well done and keep it up excellent work for our
group.
Warm Regards,
Amar
On Fri, Jan 11, 2013 at 11:32 AM, अनिल नारायण गवली
gawlianil8...@gmail.comwrote:
heartly congratulations prince.
Warm Regards,
Gawli Anil
On Fri, Jan 11, 2013 at 11:04 AM,
=SUMPRODUCT(($C$164:$C$182),IF(ISERR(D164:D182),0,(D164:D182)))/$C$183 wuth
CSE
paste this is in C185
regards
On Friday, January 11, 2013 12:15:53 PM UTC+5:30, amar takale wrote:
Hi All,
Pls suggest me Sumproduct formula in Row 185. I Put formula Row 183 but it
is so long Confusing.Pls
Hi,
How to use hlookup and v lookup in Excel Worksheet.
I need to know the formulas.
Regards
Ruchi sharma
Sent from my iPhone
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like
Hi,
can you this
=VLOOKUP(A3,$A$3:$B$8,2,0)
=HLOOKUP(B2,$B$2:$C$4,1,0)
thankx
satendra
On Fri, Jan 11, 2013 at 12:52 PM, Ruchi Sharma simpliru...@gmail.comwrote:
Hi,
How to use hlookup and v lookup in Excel Worksheet.
I need to know the formulas.
Regards
Ruchi sharma
Dear Prince,
Great, thats perfect solution.Many Many Thanks boss.
On Fri, Jan 11, 2013 at 12:45 PM, Prince prince141...@gmail.com wrote:
=SUMPRODUCT(($C$164:$C$182),IF(ISERR(D164:D182),0,(D164:D182)))/$C$183
wuth CSE
paste this is in C185
regards
On Friday, January 11, 2013 12:15:53 PM
Glad to see this mail for you, keep it up good work..
Congrats :)
Rajan verma
On Fri, Jan 11, 2013 at 12:10 AM, amar takale amartak...@gmail.com wrote:
Dear Prince,
Congratulations my friend, well done and keep it up excellent work for our
group.
Warm Regards,
Amar
On Fri, Jan 11,
can be done with using concatenate function
=A1,B1,C1,D1
Rajan
On Thu, Jan 10, 2013 at 11:53 PM, Satendra kumar
satendrakuma...@gmail.comwrote:
Dear Anil,
i have large database so how to define colored range??
=IF(COUNTIF($I$2:I2,I2)=1,IF(T2=T3,CONCATENATE(O2,,,O3,,,O4,,,O5
),),)
hi Smitha,
please get this
Public Sub CombineData()
Public Sub CombineData()
Dim wks As Worksheet
For Each wks In ThisWorkbook.Worksheets
If wks.Name = Index Or wks.Name = Output Then
GoTo lbl
Else
wks.UsedRange.Copy
With
Dear Rajan ji,
Please find attachment solve ,
thankx
satendra
On Fri, Jan 11, 2013 at 1:13 PM, rajan verma rajanverma1...@gmail.comwrote:
can be done with using concatenate function
=A1,B1,C1,D1
Rajan
On Thu, Jan 10, 2013 at 11:53 PM, Satendra kumar
satendrakuma...@gmail.com wrote:
75 matches
Mail list logo