hi Paul,
Sorry for the inconvenience.PFA file names of excel file are 1,2,3.
Please suggest.
On Friday, December 14, 2012 9:03:11 PM UTC+5:30, Paul Schreiner wrote:
I don't think we can work that way...
You're using someone ELSE's macro with YOUR files and folders
and you've admitted
Hi rendils,
Please apply this:
*
Option Explicit
'Main Function
Function SpellNumber(ByVal MyNumber)
Dim Dollars, Cents, Temp
Dim DecimalPlace, Count
ReDim Place(9) As String
Place(2) = Thousand
Place(3) = Million
Place(4) = Billion
Place(5) = Trillion
'
Dear Karan,
Please try
=INDEX($B$2:$B$6,SMALL(IF($B$2:$B$60,ROW($B$2:$B$6),),ROW(A3))-1)
with ctrl+shift+Enter
see attached sheet for more clarity.
--
With Regards,
Noorain Ansari
http://
http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com
http://
I am looking to write a macro in excel.
I wish to position the cursor on worksheet 2 to automatically enter some
data. The row number of the new position is dependant on the value of a
cell in worksheet 1.
Can anyone tell me how to do this?
Thank you.
--
Join official Facebook page of this
Hi Karan,
Please paste this in C2 and Drag it down.
=LARGE($B$2:$B$12,COUNTIF($B$2:$B$12,0)+1-ROW(A1))
Regards
Prince
On Monday, December 17, 2012 2:00:22 PM UTC+5:30, Karan Singh wrote:
Dear All,
I need your assistant to get value from the list excluding 0. I'v
attached a sample file.
Hi,
If you are inserting data automatically then no need to set cursor on sheet
2. Just define range object and assign value to it.
If you provide sample data, it is easier to give solution.
Regards
Swapnil
On Dec 17, 2012 2:32 PM, ollyolly andrew.cla...@tiscali.co.uk wrote:
I am looking to
Hi Ollyolly,
can you please tell us when this function will be performed. On opening of
the workbook or on any other event. And one more thing where i will get
the cell adress of the sheet 2 to put the cursor into Sheet2.
Regards
Prince
On Monday, December 17, 2012 2:32:21 PM UTC+5:30,
Here it's working. Thanks.
-- Forwarded message --
From: NOORAIN ANSARI noorain.ans...@gmail.com
Date: Mon, Dec 17, 2012 at 2:04 PM
Subject: Re: $$Excel-Macros$$
To: excel-macros@googlegroups.com
Dear Karan,
Please try
Dear Pravin,
Where are you facing problem with my formula.
pls explain...
On Mon, Dec 17, 2012 at 2:57 PM, Pravin Gunjal isk1...@gmail.com wrote:
Hi,
Ms-Excel has given the correct answer whereas Noorain's formula is not
working properly.
Regards
Pravin Gunjal.
-- Forwarded
Hi Anil,
Please Paste this formula into C2 and drag upto C18
=REPLACE(A2,1,LEN(B2)+1,)
Regards
Prince
On Monday, December 17, 2012 11:58:24 AM UTC+5:30, Anil Saxena wrote:
Hi All,
plz help, I want correct email id and remove the bounce email from email
id column.
--
*Anil Saxena*
Matt, Please share your workbook.
Regards,
Anoop
Sr. Developer
On Sat, Dec 15, 2012 at 9:58 PM, Matt moni...@gmail.com wrote:
Hi, search the forum but couldn't find an example that fit. I'm trying to
do a search off column A on the Lookup tab, and search for it in the
yellow column in the
Swapnil Prince,
Thanks for your swift replies, I'll try and respond to you both in one post.
The spreadsheet I am trying to write is to record the arrival time of event
entrants at certain locations.
Sheet 1 cell A1 contains the time function =now().
Sheet 1 cell A2 is where the entrants
Hi ollyolly,
That means the value in Cell A1 on Sheet1 is the arrival time, This time
should be inserted into cell C1 on Sheet2 as you hit the enter Key on
Sheet1 after typing entrants number in Cell A2 on Sheet1. Right ?
Regards
Prince
On Monday, December 17, 2012 3:04:33 PM UTC+5:30,
Hi karan Please Find one more way to do the same:
=SMALL(($B$2:$B$6)*($B$2:$B$60),COUNTIF($B$2:$B$6,=0)+ROW(A1)) with
Ctrl+shift+Enter
Regards
Prince
On Monday, 17 December 2012 14:00:22 UTC+5:30, Karan Singh wrote:
Dear All,
I need your assistant to get value from the list excluding 0.
Try this also,
=TRIM(REPLACE(A2, FIND(B2,A2),LEN(B2)+1,))
Regards,
Lalit Mohan
On Monday, 17 December 2012 11:58:24 UTC+5:30, Anil Saxena wrote:
Hi All,
plz help, I want correct email id and remove the bounce email from email
id column.
--
*Anil Saxena*
MIS Executive - Response
Hi,
Please find attached file for solution.
In attached excel, macro is updating arrival time without copying it. And
there is no key assigned to macro. When you enter value in A2 cell in
Sheet1 and hit enter macro will update arrival time in Sheet2
Regards,
Swapnil.
On Mon, Dec 17, 2012 at
Dear Pravin,
Could you please explain it more when you want to protect or unprotect the
sheet. so that we can provide you best solution.
Regards,
Lalit Mohan
On Monday, 17 December 2012 15:51:04 UTC+5:30, Pravin Gunjal wrote:
Dear Prince
Request for your co-operation on this issue.
In K7
=INDEX(E7:H7,,MATCH(MAX(COUNTIF(E7:H7,E7:H7)),COUNTIF(E7:H7,E7:H7),0))
With CSE
On Thursday, 13 December 2012 13:00:03 UTC+5:30, amar takale wrote:
Dear all
Can Anybody tell me formula to merge cell entry in one column if it is
duplicate then over right on it
Regards
Amar
--
No Possible with the same name
On Monday, 17 December 2012 09:29:13 UTC+5:30, Sanjay Kumar Maurya wrote:
Dear All,
I'm inserting new sheet in a workbook but all sheet have a different name
like sheet1, sheet2.
but i want,
if I'm inserting new sheet then every time they have same name!
Good one Rajan
Regards
Prince
On Monday, 17 December 2012 16:38:07 UTC+5:30, Rajan_Verma wrote:
In K7
=INDEX(E7:H7,,MATCH(MAX(COUNTIF(E7:H7,E7:H7)),COUNTIF(E7:H7,E7:H7),0))
With CSE
On Thursday, 13 December 2012 13:00:03 UTC+5:30, amar takale wrote:
Dear all
Can Anybody tell me
*In K7*
=LOOKUP(10^10,E7:H7,E7:H7)
*Non *Array Solution.
On 14-12-2012 5:50 PM, amar takale wrote:
Dear Experts
Pls can anybody help me on this matter.
As always, Thank you very much for all the help
Regards
Amar
On Thu, Dec 13, 2012 at 1:00 PM, amar takale amartak...@gmail.com
Why you want to have same name?
On Monday, 17 December 2012 09:29:13 UTC+5:30, Sanjay Kumar Maurya wrote:
Dear All,
I'm inserting new sheet in a workbook but all sheet have a different name
like sheet1, sheet2.
but i want,
if I'm inserting new sheet then every time they have same name!
Hi, i put the link at the bottom of my question.
tx
matt
--
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 Need
Hi Experts
I need a macro which will fill-in mentioned formulas in cell C3 to K4 for
sheet backup and get the desired results.
activesheet.range(c2)= =LOOKUP(2,1/(('*^BSESN*_WBQ'!$D:$D=$B3)*('*^BSESN*
_WBQ'!$E:$E=C$2)),'*^BSESN*_WBQ'!$K:$K)
i need macro to get above red highlighted values from
experts please help me with this.i have also attached the file .
On Monday, December 17, 2012 1:59:39 PM UTC+5:30, SG wrote:
hi Paul,
Sorry for the inconvenience.PFA file names of excel file are 1,2,3.
Please suggest.
On Friday, December 14, 2012 9:03:11 PM UTC+5:30, Paul Schreiner
Hi All Experts,
Pls give any solution.I will try it bu not sucess
On Fri, Dec 14, 2012 at 6:04 PM, Pravin Gunjal isk1...@gmail.com wrote:
*Dear Amar,*
*
*
*Pl share the test file.*
*
*
*Regards*
*Pravin Gunjal.*
*
*
On Fri, Dec 14, 2012 at 5:50 PM, amar takale amartak...@gmail.com
Hi Dear,
Solution is Perfect but waht is 10^10,I confused.I got Output but little
confusing.
Thank Very much
On Mon, Dec 17, 2012 at 4:37 PM, Ms-Exl-Learner ms.exl.lear...@gmail.comwrote:
=LOOKUP(10^10,E7:H7,E7:H7)
--
Join official Facebook page of this forum @
Dear Amar,
Please explain your query and what is your exact requirment.
On Mon, Dec 17, 2012 at 6:06 PM, amar takale amartak...@gmail.com wrote:
Hi All Experts,
Pls give any solution.I will try it bu not sucess
On Fri, Dec 14, 2012 at 6:04 PM, Pravin Gunjal isk1...@gmail.com wrote:
*Dear
Hi Swapnil
I am not very good in VBA, can you please send me macro code for this.
Regards
Amit
On Mon, Dec 17, 2012 at 5:54 PM, Swapnil Palande
palande.swapni...@gmail.com wrote:
Hi,
Try formula function of class Range
Regards
Swapnil
On Dec 17, 2012 5:16 PM, Amit Gandhi
Dear Friends,
Could you please help me understand how to write or develop Addin in Excel
2007? Do we have a training material or some write ups for hint?
Best Regards,
Amit
Disclaimer: This message and its attachments contain confidential information
and may
Hi All,
Good Afternoon!!!
Can Somebody help me by giving a macro which can add comments based on a
cell value like,
In the attached workbook, sheet named 'Clients' I have a list of client
codes against which 'Details' sheet they have some requirements
in columns named 'Req.1' , 'Req.2',
Sir,
I saw the calendar made by Mr. Debaranjan. The calendar is not made by
Mr Debarajan himself it is downloaded from
http://www.vertex42.com/Files/download/exclusive.php?file=yearly_event_calendar.xlsx
and only modified by him. You can easily see the properties of the
excel calendar made by Mr.
That must be it! I think it's because your weekday formula return_type
number (16) doesn't work in Excel 2007. I have the option of doing:
1 Returns a number from 1 (Sunday) to 7 (Saturday).
2 Returns a number from 1 (Monday) to 7 (Sunday). 3 Returns a number
from 0 (Monday) to 6
As noted by Shreyas Gupta, it seems that Debaranan has submitted someone
else's work as his own.
I will speak with Ayush to determine how best to handle this situation.
Paul
On Thursday, December 13, 2012 2:11:20 PM UTC-5, Paul Schreiner wrote:
Results of the recent Calendar Challenge are
I'll have to look at it and figure out how to calculate it differently.
I'll get back to you soon.
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 people
Hi Paul, when are we seeing the rest of the calenders,
is it possible to load it to say skydrive or any web hosting site and send
us a link to download.
thanks
On Mon, Dec 17, 2012 at 3:07 PM, Paul Schreiner schreiner_p...@att.netwrote:
[image: Boxbe] https://www.boxbe.com/overview This
Thanks Paul.
On 13 December 2012 18:30, Paul Schreiner schreiner_p...@att.net wrote:
That is correct.
# (days) / 7 (days/week) = # (weeks)
*Paul*
-
*“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places
Hi, i put the link at the bottom of. my question.
tx
here is the link with the spreadsheet
https://www.box.com/s/33z5kuabqbjn2b971ae6
matt
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread
Hi Amar,
But Amar what about if there is number like : 2 ,2,3,4 then what should be
the output for this.
Regards
Prince
On Monday, December 17, 2012 6:32:12 PM UTC+5:30, amar takale wrote:
Dear Noorain,
Actually I want Each column filled by different person after finish data
entry I
Sub add_comment()
Dim i As Long
Dim x As String, found As Range
Dim j As Long, k As Long
For i = 2 To Sheets(Clients).Range(a1).End(xlDown).Row
Set found =
Sheets(Details).Range(a:a).Find(Sheets(Clients).Cells(i, 1).Value,
LookIn:=xlValues)
If Not found Is Nothing Then
j =
Hi Ashish,
Thank you very much.
Works fine, saved lot of time.
Thanks.
On Mon, Dec 17, 2012 at 7:11 PM, ashish koul koul.ash...@gmail.com wrote:
Sub add_comment()
Dim i As Long
Dim x As String, found As Range
Dim j As Long, k As Long
For i = 2 To
Even shorter than the previous one,
=LOOKUP(10^10,E7:H7)
Just type =10^10 in a cell for knowing the evaluated result.
On 12/17/12, amar takale amartak...@gmail.com wrote:
Hi Dear,
Solution is Perfect but waht is 10^10,I confused.I got Output but little
confusing.
Thank Very much
On Mon,
Hi all,
I've been searching for hours looking for a generic macro to help with the
following problem.
If cell value in column J of worksheet Sheet1 = Apple or Pear then
copy that cell plus the previous 4 cells to a new worksheet called Sheet2.
Hope someone can help.
Best regards
sw1085
--
can you share the sample file
On Mon, Dec 17, 2012 at 9:57 PM, sw1085 swilson2...@gmail.com wrote:
Hi all,
I've been searching for hours looking for a generic macro to help with the
following problem.
If cell value in column J of worksheet Sheet1 = Apple or Pear then
copy that cell plus
hi
*can you share the input file and final output file too*
Regards
Ashish
On Mon, Dec 17, 2012 at 5:46 PM, SG sonal...@gmail.com wrote:
experts please help me with this.i have also attached the file .
On Monday, December 17, 2012 1:59:39 PM UTC+5:30, SG wrote:
hi Paul,
Sorry for the
*With formula* http://web.pdx.edu/~wde/Code/Excel_Files/No_VBA_Spellout.php
VBA http://www.contextures.com/excelfilesRon.html#RF0001
http://support.microsoft.com/kb/213360
On Mon, Dec 17, 2012 at 1:20 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Delin,
Please see
Dear Ashish,
Thanks will check..
Best Regards,
Amit
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of ashish koul
Sent: 17 December 2012 22:00
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ How to develop Addins
try these
try this code for *ComboBox1_Change()*
Private Sub ComboBox1_Change()
Dim rw As Long, cl As Range, found As Range
Set found = Worksheets(ThamDinh).Range(A:A).Find(Me.ComboBox1.Value,
LookIn:=xlValues)
If Not found Is Nothing Then
rw = found.Row
tbxSoTT =
try this code for *ComboBox1_Change()*
Private Sub ComboBox1_Change()
Dim rw As Long, cl As Range, found As Range
Set found = Worksheets(ThamDinh).Range(A:A).Find(Me.ComboBox1.Value,
LookIn:=xlValues)
If Not found Is Nothing Then
rw = found.Row
tbxSoTT =
Thanks Ashish koul
You were quick to answer, your answer is very good, sincerely thanks.
2012/12/18, ashish koul koul.ash...@gmail.com:
try this code for *ComboBox1_Change()*
Private Sub ComboBox1_Change()
Dim rw As Long, cl As Range, found As Range
Set found =
Dear Group,
Kindly help me, i want to create Circles around the cells. means if i have
some Numbers in any excel sheet and i want circle to be created on cell who
have numbers less then 30.
please help me.
--
Pankaj Pandey
Bhopal
--
Join official Facebook page of this forum @
How are you wanting this to happen?
Are you wanting to make it so that it adds the circles automatically when the
cell value changes?
or are you wanting to run a macro (hit a button) and have it add the circles?
Keep in mind that circles would be DRAWING OBJECTS and have no actual
association
Hi
c
Michael Cho
--
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 Need Advice will not get
quick attention or
Hi Pankaj,
If you want circles around the cells with values less than 30, there are two
methods that come to mind.
(1)Use a data validation rule that specifies that values = 30 are the
only valid values (you can disable all warnings in the data validation rule
so it will allow entry of
Dear Parvin,
I want like
If same number all cell something cell also miss=one number which same
If single number=show single number
that it simple. I used Ms-Exl-Learner that perfect but if all cell same but
last cell different number then show that numbers,I want that time show
error then i will
Not sure whether this...
For 2003 version of excel
=IF(ISNA(LOOKUP(10^10,E7:H7)),,LOOKUP(10^10,E7:H7))
For excel version which is higher than 2003
=IFERROR(LOOKUP(10^10,E7:H7),)
On 18-12-2012 10:16 AM, amar takale wrote:
Dear Parvin,
I want like
If same number all cell something cell also
Hi SG,
Please share your file with us.
Regards
Prince
On Friday, 14 December 2012 19:18:59 UTC+5:30, SG wrote:
Hi Experts,
I need your help in one of my problem.I want to consolidate the
multiple excel files of a folder with same name numbered as 1,2,3 in to a
one excel file.I have
Hi Rajan
That Perfect one Solution
Thanks very much.
On Mon, Dec 17, 2012 at 4:43 PM, Prince prince141...@gmail.com wrote:
Good one Rajan
Regards
Prince
On Monday, 17 December 2012 16:38:07 UTC+5:30, Rajan_Verma wrote:
In K7
=INDEX(E7:H7,,MATCH(MAX(**COUNTIF(E7:H7,E7:H7)),COUNTIF(**
Dear Ms-Exl-Learner,
As always, Thank you very much for all the help
Regards
Amar
On Tue, Dec 18, 2012 at 10:42 AM, Ms-Exl-Learner
ms.exl.lear...@gmail.comwrote:
Not sure whether this...
For 2003 version of excel
=IF(ISNA(LOOKUP(10^10,E7:H7)),,LOOKUP(10^10,E7:H7))
For excel version
Hi Amit,
Please find some useful details on the below mentioned links
http://www.microsofttraining.net/article-625-create-excel-vba-add-in.html
https://groups.google.com/forum/?hl=enfromgroups=#!topic/microsoft.public.excel.programming/dV0S4zUgj2o
Regards
Prince
On Monday, 17 December 2012
Respected Champs,
Can you explain why the exponential function 10^10 is used in the formula
=LOOKUP(10^10,E7:H7,E7:H7) i.e 10 to the power of 10 would yield a quite
large number and how can it be useful in the look up function.
Regards,
P.VIJAY KUMAR
--
Join official Facebook page of this
61 matches
Mail list logo
