Congrats Noorain. As always, your contributions help many.
Regards,
Sam Mathai Chacko
On Fri, Aug 3, 2012 at 11:10 PM, Ayush Jain jainayus...@gmail.com wrote:
Dear members,
Noorain Ansari has been selected as 'Most Helpful Member' for the month of
July'12. He has posted 143 posts in July
.
--
To post to this group, send email to excel-macros@googlegroups.com
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com
--
Sam Mathai Chacko
--
FORUM RULES (986+ members already BANNED for violation)
1
Either way, you need to consider the time difference between both the
countries. Only then will you actually be able to calculate the overall
time consumed for the dispatch to be delivered.
Sam Mathai Chacko
On Mon, Jul 30, 2012 at 11:25 PM, Paul Schreiner schreiner_p...@att.netwrote:
What kind
I also second both gentlemen's points.
For the solution, use
=SUMPRODUCT(($A$2:$A$10=$G$13)*($B$2:$B$10=$G14)*(C$2:C$10)) dragged down
and across
Regards,
Sam Mathai Chacko
On Tue, Jul 31, 2012 at 12:10 AM, dguillett1 dguille...@gmail.com wrote:
I did not look at your file because you
rngCluster.Areas.Count
For Each obj In rngCluster.Areas
MsgBox obj.Address
Next obj
End Sub
Regards,
Sam Mathai Chacko
On Sun, Jul 29, 2012 at 4:33 PM, Prince Dubey prince141...@gmail.comwrote:
Hi Sam,
Thanks for the reply,
I did the same as you have mentioned in your post i created
:C3), Range(D5:E10))
MsgBox rngCluster.Areas.Count
For Each obj In rngCluster.Areas
MsgBox obj.Address
Next obj
End Sub
Regards,
Sam Mathai Chacko
On Sun, Jul 29, 2012 at 4:33 PM, Prince Dubey prince141...@gmail.comwrote:
Hi Sam,
Thanks for the reply,
I did
.
--
To post to this group, send email to excel-macros@googlegroups.com
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com
--
Sam Mathai Chacko
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles
.
--
To post to this group, send email to excel-macros@googlegroups.com
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com
--
Sam Mathai Chacko
--
FORUM RULES (986+ members already BANNED for violation)
1) Use
Basically the key thing to understand is the groups of contiguous
non-empty cells in the parent range.
On 7/29/12, Sam Mathai Chacko samde...@gmail.com wrote:
Prince,
First of all, let us get the idea of an Area correct. An Area is the
number of clusters of contiguous cells in a range
'Do Nothing
End Select
Regards,
Sam Mathai Chacko
On Fri, Jul 27, 2012 at 7:27 PM, Jorge Marques leote.w...@gmail.com wrote:
Hi,
Ok I looked in several forums none explained, I only noticed then the code
only returns 1 Case or OR, the issue is that I have a Shops in this case
As a MOF, 6150FLA is in Column L also. What is your logic of using the
second instance of this value?
On Sat, Jul 21, 2012 at 11:30 PM, Sam Mathai Chacko samde...@gmail.comwrote:
Column G also has the same text as column header. How do you decide
whether it is column G, or column I??
Sam
:$V$1,0)),1)+1)
But if you want to use column I, just use
=INDEX($I$2:$I$22,MATCH(A54,$I$2:$I$22)+1)
Regards,
Sam Mathai Chacko
On Sat, Jul 21, 2012 at 11:39 PM, Sam Mathai Chacko samde...@gmail.comwrote:
As a MOF, 6150FLA is in Column L also. What is your logic of using the
second instance
Your question and title are contradicting.
Do you want to convert words to numbers, or vice versa?
Regards,
Sam Mathai Chacko
On Mon, Jul 16, 2012 at 11:15 PM, kumar.ashish861 kumar.ashish...@gmail.com
wrote:
Dear All,
Kindly help me to convert numbers in digits. I'll apply the formula
Try this, might help.
http://www.excelfox.com/forum/f10/activate-ribbon-tab-excel-2007-2010-a-50/
If it doesn't, can you post your XML code?
Regards,
Sam Mathai Chacko
On Thu, Jul 5, 2012 at 5:59 PM, Divaker Pandey divake...@gmail.com wrote:
Hi Group,
I made a custom menu and ribbon icon
Excellent achievement once again by Ashish and Dilip. Kuddos to both.
Regards,
Sam Mathai Chacko
On Mon, Jul 2, 2012 at 7:32 PM, ashish koul koul.ash...@gmail.com wrote:
Thank you all...
On Mon, Jul 2, 2012 at 4:39 PM, Amol Shrivastava shri.a...@gmail.comwrote:
*Congratulations Ashish
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com
--
Sam Mathai Chacko
--
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
@googlegroups.com To
unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com
--
Sam Mathai Chacko
--
--
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
PESTERING.
Sam Mathai Chacko
On Mon, Jun 18, 2012 at 11:25 PM, in.vaib...@gmail.com wrote:
**
Hi Ayush,
Why can't we have separate team of moderator like other sites.
--
*From: * Ayush Jain jainayus...@gmail.com
*Sender: * excel-macros@googlegroups.com
*Date: *Mon
, send a blank email to
excel-macros+unsubscr...@googlegroups.com
--
Sam Mathai Chacko
--
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
ActiveSheet.usedrange.entirecolumn.autofit
Sam Mathai Chacko
On Sat, Jun 16, 2012 at 4:28 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
Select the Column and press
ALT + O C A
** **
* *
*Regards*
*Rajan verma*
*+91 7838100659 [IM-Gtalk]*
** **
*From:* excel-macros
Should be *EntireColumns* as I had posted
Regards,
Sam Mathai Chacko
On Sat, Jun 16, 2012 at 7:29 PM, dguillett1 dguille...@gmail.com wrote:
or
ActiveSheet.UsedRange.Columns.AutoFit
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
*From:* Sam Mathai Chacko
are not responsible for any loss.
--
To post to this group, send email to excel-macros@googlegroups.com
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com
--
Sam Mathai
are not responsible for any loss.
--
To post to this group, send email to excel-macros@googlegroups.com
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com
--
Sam Mathai
YOu could use something like this
Use in B1 where you put the client name in A1
=INDEX(INDIRECT('[sample file register
.xlsx]LEFT(A1,1)'!$A$2:$A$20),MATCH(A1,INDIRECT('[sample file
register .xlsx]LEFT(A1,1)'!$B$2:$B$20),0))
Regards,
Sam Mathai Chacko
On Sat, Jun 9, 2012 at 5:06 PM, Vivek
Congratulations again Cheeteh great going.
Regards,
Sam Mathai Chacko
On Mon, Jun 4, 2012 at 12:17 AM, resp...@gmail.com wrote:
**
Congratulation Raj. Proud of you. Lunch for you tommorrow.
Sent from my BlackBerry® smartphone from Airtel Ghana
--
*From
-macro-functions-get-document-76/
http://www.excelfox.com/forum/f13/excel-macro-functions-get-cell-75/
Another example that uses GET.WORKBOOK
http://www.excelfox.com/forum/f13/list-all-worksheet-names-using-formula-119/
Regards,
Sam Mathai Chacko
On Tue, May 29, 2012 at 4:20 PM, NOORAIN ANSARI
to the same browse window, and uncheck the add-in
Regards,
Sam Mathai Chacko
On Wed, May 30, 2012 at 12:02 AM, Ashish Pradhan ashlyprad...@gmail.comwrote:
Hello Sam
Haven't yet installed this tool. I use Windows 7 (and I believe this
wouldnt be applicable for windows 7). Have seen
for any loss.
--
To post to this group, send email to excel-macros@googlegroups.com
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com
--
Sam Mathai Chacko
.
--
To post to this group, send email to excel-macros@googlegroups.com
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com
--
Sam Mathai Chacko
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles
.
--
To post to this group, send email to excel-macros@googlegroups.com
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com
--
Sam Mathai Chacko
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like
Here's one with SUMIF
Regards,
Sam Mathai Chacko
On Fri, May 18, 2012 at 9:22 AM, Ashish Pradhan ashlyprad...@gmail.comwrote:
Hello
Was trying to understand and learn the formula used by Ashish Koul.
However, when I edit the formula and exit the formula bar (without making
any changes
This is one way to do it. Run UserForm1 first.
Regards
Sam Mathai Chacko
On Fri, May 11, 2012 at 3:14 PM, Shekhar Sharma shekhar1...@gmail.comwrote:
Is it possible to pass Values between UserForms? If so, what's the syntax
for doing it?
Let's say I'm using this code
Private Sub
Just Use =TEXT(TODAY(),mmm)
Regards,
Sam Mathai Chacko
On Tue, May 8, 2012 at 11:02 AM, hilary lomotey resp...@gmail.com wrote:
Hello
Pls i want to get the month of today such as May but if i use this
formula TEXT(MONTH(TODAY()),mmm) its evaluates to Jan, however if i
evaluate only MONTH
Because today is the 5th month. And the value of 5 is actually equivalent
to 5 days starting from day zero. In other words, it is just the 5th of
January 1900.
And the month of 5th January 1900 is Jan of course.
Regards,
Sam Mathai Chacko
On Tue, May 8, 2012 at 11:33 AM, resp...@gmail.com wrote
personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--
To post to this group, send email to excel-macros@googlegroups.com
--
Sam Mathai
are not responsible for any loss.
--
To post to this group, send email to excel-macros@googlegroups.com
--
Sam Mathai Chacko
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise
***
On Sat, Apr 28, 2012 at 2:17 PM, Sam Mathai Chacko samde...@gmail.comwrote:
You can record macros in Excel. To know how to record macros, just do a
google search.
REgards,
Sam Mathai Chack
On Sat, Apr 28, 2012 at 1:42 PM, Deba Ranjan drdeva...@gmail.com wrote:
*Hi Experts
Happy Birthday Ayush. Have a great new year.
REgards,
Sam Mathai CHacko
On Fri, Apr 27, 2012 at 3:24 AM, Michael Brumby mikebru...@yahoo.comwrote:
*Happy birthday...!!*
Best Regards.
Mr Michael Brumby
Diese Email und samtliche beigefugten Anhange sind vertraulich zu
behandeln und
Nothing obvious. Can you share the original query with the datevariable,
and what is the new value that gets stored in the strNewCmd variable?
Regards,
Sam Mathai Chacko
On Thu, Apr 19, 2012 at 1:35 AM, JB dsdevonso...@gmail.com wrote:
I have Excel 2010 on Windows 7. I wrote a code
This might be of interest
http://www.excelfox.com/forum/f22/replacement-flawed-usedrange-property-374/
Regards,
Sam Mathai Chacko
On Thu, Apr 19, 2012 at 5:22 AM, Domain Admin domainqu...@gmail.com wrote:
Actually ever weirder. If I keep clearing the current region and
pasting in the exact
.
--
To post to this group, send email to excel-macros@googlegroups.com
--
Sam Mathai Chacko
--
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
Donald, your presence here is a boon to many. From everyone who has
benefited from your expertise, one way or the other, a big thanks. And
congratulations.
Regards,
Sam Mathai Chacko
On Sat, Apr 14, 2012 at 4:19 PM, in.vaib...@gmail.com wrote:
**
Congrats Don n Thanks a lot for sharing
are not responsible for any loss.
--
To post to this group, send email to excel-macros@googlegroups.com
--
Sam Mathai Chacko
--
FORUM RULES (986+ members already BANNED for violation)
1) Use
personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--
To post to this group, send email to excel-macros@googlegroups.com
--
Sam Mathai
Check attached
REgards,
Sam Mathai Chacko
On Sat, Apr 14, 2012 at 3:52 AM, Mr Excellent suryaprasad...@gmail.comwrote:
Hi All,
Need a simple index function with a drop given to auto publish the values
in the given table
Please help
Thanks
Excellent
--
FORUM RULES (986+ members
.
--
To post to this group, send email to excel-macros@googlegroups.com
--
Sam Mathai Chacko
--
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
Add-ins are designed to run in the background, and hence the file will not
be visible when you open it. If you go to the VBE window, you could
actually see that the vba project for your add-in is shown.
Sam Mathai Chacko
On Mon, Apr 2, 2012 at 10:50 PM, Raj Mahapatra rajafs...@gmail.com wrote
This link will tell you how to add a tab in Excel
http://www.excelfox.com/forum/f10/how-add-new-ribbon-tab-excel-26/?highlight=ribbon
Regards,
Sam Mathai Chacko
On Mon, Apr 2, 2012 at 11:40 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
I think u should create custom menu to display
The Custom UI Editor Tool is used to modify the XML tag of the custom UI
xml files on an office application file like Excel,Word, PPT, etc.
Quite a few examples can be found at http://www.excelfox.com/forum/f10/
Regards,
Sam Mathai Chacko
On Tue, Apr 3, 2012 at 1:23 AM, Maries talk2mar
I'd keep it short like this
Sub SheetAd()
Dim l As Long
For l = 1 To 100
Sheets(Sheet1).Copy , ActiveSheet
Next
End Sub
REgards
Sam Mathai Chacko
On Sat, Mar 31, 2012 at 1:11 PM, Asa Rossoff a...@lovetour.info wrote:
Sorry, Sandeep, I did not immediately see that you
It means that all blank cells from Column D are being set to that range
variable
Regards,
Sam Mathai Chacko
On Sat, Mar 31, 2012 at 10:38 PM, vijayajith VA vijayajith...@gmail.comwrote:
Hi,
Set sourcerange = Columns(D).SpecialCells(xlCellTypeBlanks)
Can any one explain above code?
what
a1(blank cell) will search for a1 in other
workbook get filled rite...
On Sat, Mar 31, 2012 at 10:43 PM, Sam Mathai Chacko samde...@gmail.comwrote:
It means that all blank cells from Column D are being set to that range
variable
Regards,
Sam Mathai Chacko
On Sat, Mar 31, 2012 at 10
Try this
http://www.excelfox.com/forum/f10/how-add-new-ribbon-tab-excel-26/
Regards,
Sam Mathai Chacko
On Fri, Mar 30, 2012 at 9:37 PM, ashish koul koul.ash...@gmail.com wrote:
check this http://www.rondebruin.nl/ribbon.htm#Examples
On Fri, Mar 30, 2012 at 12:44 PM, Divaker Pandey
.
--
To post to this group, send email to excel-macros@googlegroups.com
--
Sam Mathai Chacko
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help
are not responsible for any loss.
--
To post to this group, send email to excel-macros@googlegroups.com
--
Sam Mathai Chacko
--
FORUM RULES (986+ members already BANNED for violation)
1) Use
Why not simply use conditional format?
Sam Mathai Chacko
On Thu, Mar 29, 2012 at 8:22 PM, Tiffany tiffany@gmail.com wrote:
Hi -
I'm a little new to VBA but have managed to put together a macro that half
achieves its intended purpose.
Depending on what is chosen in a data validation
Select the three columns starting from the 8th Row, and Column F, and use
this conditional
=AND(ISNUMBER(F8),SUM($F8:$H8)2)
Regards
Sam Mathai Chacko
On Sat, Mar 17, 2012 at 11:52 AM, Pravin Kumar pravin.si...@gmail.comwrote:
Hi folk
I want to add validation for cell (3 cell) with two
--
Sam Mathai Chacko
--
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 not be answered.
2) Don't post
.
--
To post to this group, send email to excel-macros@googlegroups.com
--
Sam Mathai Chacko
--
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
.
--
To post to this group, send email to excel-macros@googlegroups.com
--
Sam Mathai Chacko
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent
.
--
To post to this group, send email to excel-macros@googlegroups.com
--
Sam Mathai Chacko
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula
the button to do the search.
Regards,
Sam Mathai Chacko
On Wed, Mar 7, 2012 at 8:56 PM, Joaowild joaow...@gmail.com wrote:
Hi. Someone help with this: I have a book with aprox 20 sheets, many
products are included. Well i need a search a defined product from
combobox inside a userform, but when i
=IFERROR(INDEX(Sheet2!$C$2:$C$15,SMALL(IF(IFERROR(SEARCH(Report!$B$32,Sheet2!$A$2:$A$15,1),0)0,ROW(Sheet2!$C$2:$C$15)-1,),ROW()-33)),)
Regards,
Sam Mathai Chacko
On Wed, Mar 7, 2012 at 9:49 AM, Ashish Bhalara ashishbhalar...@gmail.comwrote:
-- Forwarded message --
From
loss.
--
To post to this group, send email to excel-macros@googlegroups.com
--
Sam Mathai Chacko
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread
*osh.ListObjects(1).UnList*
Regards
Sam Mathai Chacko
On Wed, Mar 7, 2012 at 12:34 AM, dguillett1 dguille...@gmail.com wrote:
try
Sub removetableSAS()
dim i as integer
for i = 1 to 3
activesheet. osh.listobjects(Table i ).unlist
next i
End sub
Don Guillett
Microsoft MVP Excel
.
--
To post to this group, send email to excel-macros@googlegroups.com
--
Sam Mathai Chacko
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need
Not tested, but try this
range(a2:z223).copy
with
range(a1).resize(range(a2:z223).rows.count,range(a2:z223).columns.count)
.unmerge
.paste pastevalues
end with
Regards,
Sam Mathai Chacko
On Thu, Mar 1, 2012 at 6:21 PM, Scruffy Huffy tuffhu...@yahoo.com wrote:
Don,
I did this and got
am, Sam Mathai Chacko samde...@gmail.com wrote:
Not tested, but try this
range(a2:z223).copy
with
range(a1).resize(range(a2:z223).rows.count,range(a2:z223).columns.cou
nt)
.unmerge
.paste pastevalues
end with
Regards,
Sam Mathai Chacko
On Thu, Mar 1, 2012
Why don't you use TODAY()
Sam Mathai Chacko
On Thu, Mar 1, 2012 at 10:54 PM, danial mansoor danial_...@hotmail.comwrote:
i used NOW() function to get below date but now i want to split it,i try
to used LEFT and RIGHT function but it does not work on numbers i think
wats the reason? and any
.
--
To post to this group, send email to excel-macros@googlegroups.com
--
Sam Mathai Chacko
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
The trick is to select another cell... at any given time, at least one cell
WILL be selected (if not any other object) in a sheet. So at the end of
your macro, select any other cell, for example the top left cell A1
Sam Mathai Chacko
On Thu, Mar 1, 2012 at 12:12 AM, Scruffy Huffy tuffhu
be live linked to each option).
Thanks for your time.
Robb
On Feb 29, 1:52 pm, Sam Mathai Chacko samde...@gmail.com wrote:
The trick is to select another cell... at any given time, at least one
cell
WILL be selected (if not any other object) in a sheet. So at the end of
your macro
--
Sam Mathai Chacko
--
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 not be answered.
2) Don't post
...@gmail.com wrote:
Sam, I don’t think the “published” rules prohibit that. I just make it
my policy to encourage posters to learn by doing so I don’t do homework.
YMMV
Don Guillett
SalesAid Software
dguille...@gmail.com
*From:* Sam Mathai Chacko samde...@gmail.com
*Sent:* Wednesday, February
,SMALL(IF(IFERROR(SEARCH($E$1,Data!$E$3:$E$640,1),0)0,ROW(Data!$E$3:$E$640)-2,),ROW()-4))),,INDEX(Data!$A$3:$A$640,SMALL(IF(IFERROR(SEARCH($E$1,Data!$E$3:$E$640,1),0)0,ROW(Data!$E$3:$E$640)-2,),ROW()-4)))
in A5 and drag formula across
Regards,
Sam Mathai Chacko
On Mon, Feb 27, 2012 at 10:57 AM
Hi Lee,
=WEEKNUM(--TEXT(A1,\/00\/00))
http://www.excelfox.com/forum/f13/convert-text-mmdd-format-date-format-74/
In your case, I'd use
*
=TEXT(--TEXT(A1,\/00\/00),mmm)-WWEEKNUM(--TEXT(A1,\/00\/00))
* to give *Oct-W41*
Regards,
Sam Mathai Chacko
On Mon, Feb 27, 2012 at 11:47
Ah! Quote Haseeb {I think this part ISNUMBER(--MID(A3,6,4)) will allow
entry with 3 spaces before the fourth digit :-) , like}
I think that's a very good catch Haseeb. :)
I think adding an IFERROR(FIND( ,Range)) will solve the problem.
Regards,
Sam Mathai Chacko
On Mon, Feb 27, 2012 at 12
Add an extra column in the pivot and use as filter
Regards,
Sam Mathai Chacko
On Sat, Feb 25, 2012 at 2:17 PM, Ashish Bhalara
ashishbhalar...@gmail.comwrote:
Dear expert,
Is there possible to remove zero value raw from pivot? Please find the
attachment data of pivot file.
Thanks
Chacko samde...@gmail.comwrote:
Add an extra column in the pivot and use as filter
Regards,
Sam Mathai Chacko
On Sat, Feb 25, 2012 at 2:17 PM, Ashish Bhalara
ashishbhalar...@gmail.com wrote:
Dear expert,
Is there possible to remove zero value raw from pivot? Please find
If you have a pretty long range, you could use another range to do the
lookup. I have also added the below suggestion to the attachment.
Regards,
Sam Mathai Chacko
On Sat, Feb 25, 2012 at 10:15 AM, Maries talk2mar...@gmail.com wrote:
Hi,
Try it..
*=VLOOKUP(A1,{0,0-2;3,2-4;5,4-6;7,6+},2
)
.OnAction = Split(strMacroNames, ,)(lngLoop - 1)
End With
End With
Next
End Sub
Regards,
Sam Mathai Chacko
On Sat, Feb 25, 2012 at 6:44 AM, Cab Boose swch...@gmail.com wrote:
Hi
Xl2000
I want to add some macros to the existing'Tools' toolbar
I believe the OP was asking for a data validation
Regards,
Sam Mathai Chacko
On Sat, Feb 25, 2012 at 8:54 PM, Maries talk2mar...@gmail.com wrote:
Hi,
Please find the attachment.
Regards,
MARIES.
On Sat, Feb 25, 2012 at 5:59 PM, Vijayendra Rao
vijayendrar...@gmail.comwrote:
Dear
.
--
To post to this group, send email to excel-macros@googlegroups.com
--
Sam Mathai Chacko
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor
.
--
To post to this group, send email to excel-macros@googlegroups.com
--
Sam Mathai Chacko
--
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
*=G91*1440*
Regards,
Sam Mathai Chacko
On Fri, Feb 24, 2012 at 4:53 PM, satish
narbhaviwithsatishku...@gmail.comwrote:
Hi all,
I have the data in below format, I try to convert the date format in
to decimal Minutes. It comes well when the data below 24 Hrs, as soon
as it exceed 24 Hrs
If you insist on using your original formula, try a more lengthier
*=QUOTIENT(G91,1)*1440+HOUR(**G9**1)*60+MINUTE(**G9**1)+SECOND(**G9**1)/60*
But *=G91*1440 will give the same answer*
Regards,
Sam Mathai Chacko
On Fri, Feb 24, 2012 at 10:19 PM, Sam Mathai Chacko samde...@gmail.comwrote
Change sheet calculation to manual!
Sam Mathai Chacko
On Fri, Feb 24, 2012 at 11:45 PM, krishnanm2...@gmail.com wrote:
Dear Excel Gurus,
I need help with a formula.. All I need is to do I capture current time,
and freeze the same... For eg: if I need to enter the time as 10.01 am
using
I know I mentioned otherwise in
http://osdir.com/ml/excel-macros/2011-12/msg00084.html
However,* you cannot use ++*
You can use +0, *1, -0, /1, ^1 etc, but -- is the most elegant and common
approach.
Regards,
Sam Mathai Chacko
On Thu, Feb 23, 2012 at 12:21 PM, Asa Rossoff a...@lovetour.info
of another”
Don Guillett
SalesAid Software
dguille...@gmail.com
*From:* Sam Mathai Chacko samde...@gmail.com
*Sent:* Tuesday, February 21, 2012 11:39 AM
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Help with code please
*From:* Sam Mathai Chacko samde...@gmail.com
*Sent:* Tuesday, February 21, 2012 6:56 PM
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Help with code please.
Haha, I like the way you put that Don. I agree 6 of 1 is half a dozen of
another. On the other point however, I
added
lngCount = lngCount + 1
End If
Next objFile
Range(E1) = # Of Documents is: lngCount
lngCount = 0
lngLoop = 0
End Sub
Regards,
Sam Mathai Chacko
On Tue, Feb 21, 2012 at 8:37 PM, Dave davidstev...@gmail.com wrote:
Thanks Don I tried it and its giving me
= .Cells.Find(What:=whattolookfor, LookIn:=xlValues,
LookAt:=xlWhole)
If Not rng Is Nothing Then
Application.Goto rng
Exit For
End If
End With
Next wks
End Sub
Regards,
Sam Mathai Chacko
On Tue, Feb 21, 2012 at 8:03
On Tue, Feb 21, 2012 at 11:31 PM, Sam Mathai Chacko samde...@gmail.comwrote:
Use this in Cell A5 and drag down and across
=IFERROR(INDEX(Data!A$3:A$82,SMALL(IF(LEFT(Data!$E$3:$E$82,LEN(MyOutput!$D$1))=MyOutput!$D$1,ROW(INDIRECT((1:ROWS(Data!$E$3:$E$82,),ROW()-ROW(MyOutput!A$4))),)
Regards
=IF(AND(A1=3000,A1=4500),B1*0.5,B1)
Sam Mathai Chacko
On Tue, Feb 21, 2012 at 2:01 PM, m7md.gmail mo7md.m7m...@gmail.com wrote:
Please check attached
I need this function necessary now .
thanks,
*
--
*
Regards,
Mohamed Mahmoud
--
FORUM RULES (986
--
Sam Mathai Chacko
--
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 not be answered.
2) Don't post
With
End Sub
Regards,
Sam Mathai Chacko
On Thu, Feb 16, 2012 at 7:08 PM, chhajersand...@gmail.com wrote:
Dear Excel gurus,
I have a sheet with figures and formulas.
I want a macro which can convert all the numbers in to round off up to two
decimal but not the formulas.
Like if in any
Use this formula as an array in c8 and drag across
=IFERROR(INDEX(database!A$1:A$2500,SMALL(IF(LEN(SUBSTITUTE(UPPER(database!$A
$1:$A$2500),UPPER(Sheet2!$E$3),))LEN(UPPER(database!$A$1:$A$2500)),ROW(IN
DIRECT(1:ROWS(database!$A$1:$A$2500))),),ROW()-7)),)
Regards,
Sam Mathai Chacko
.
--
To post to this group, send email to excel-macros@googlegroups.com
--
Sam Mathai Chacko
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need
.
--
To post to this group, send email to excel-macros@googlegroups.com
--
Sam Mathai Chacko
--
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
Sub FormulaRound()
Dim rng As Range
For Each rng In ActiveSheet.UsedRange.SpecialCells(xlCellTypeFormulas)
rng.Formula = =ROUND( Right(rng.Formula, Len(rng.Formula) - 1)
,2)
Next rng
End Sub
Regards,
Sam Mathai Chacko
On Wed, Feb 15, 2012 at 11:40 PM, chhajersand
101 - 200 of 570 matches
Mail list logo