copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL
Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this g
on't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not al
ons regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbo
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 a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or by
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
--
*
*
* MARIES*
Excel Inspiration <http://xcel-inspir
s.com To
>> unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>
> --
> -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise,
> accurate thread titles. Poor thread titles, like Please Help, Urgent, Need
> Help
--
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
--
*
*
* MARIES*
Excel Inspiration <http://xcel-inspiration.blogspot.com/>
gt;> NOTE : Don't ever post 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
>>>
>
e 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 a question in the thread of
> another member. 3) Don't post questions regarding breaking or bypassing any
> security measure. 4) Ackno
questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not
x27;t post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post pe
>
> NOTE : Don't ever post 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
>
> To unsubscribe, send a blank email to
AM, David Grugeon wrote:
> Hi Maries
>
> Interesting. Do you know what is going through Excels mind when it does
> that? Why it does not just end up with lots of empty rows?
>
> On 11 June 2012 17:19, Maries wrote:
>
>> HI,
>>
>> Use the below formula
gt; Click in the "Replace with" box.
> Hold down ALT and on the number pad type 013. Release ALT
> Hold down ALT and on the number pad type 010. Release ALT
> Click Replace All
> Select the rows and with the mouse between two row numbers on the left
> double click.
>
la Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or
end email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
--
*
*
* MARIES*
Excel Inspiration <http://xcel-inspiration.blogspot.com/>
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise
g or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workb
gt;>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>> --
>>>> Thanks & regards,
>>>> Noorain Ansari
>>>> www.noorainansari.com
>>>> www.exce
Hi Santosh,
Find the attached file. I hope this fulfill.
On Mon, Jun 4, 2012 at 2:27 AM, Anil Gawli wrote:
> See the attached data
> Regards,
> Gawli Anil
>
>
>
> On Mon, Jun 4, 2012 at 2:38 PM, santosh subudhi <
> santoshkumar.subu...@gmail.com> wrote:
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
--
*
*
* MARIES*
Excel Inspir
;>>
>>> I truly appreciate his consistency and commitment to group. He is really
>>> doing great job God bless you :)
>>>
>>> Thanks to Noorain, Don, Asa, Maries, and other folks for helping excel
>>> enthusiasts voluntarily !! Keep it up !!
>>
t; NOTE : Don't ever post personal or confidential data in a workbook.
>> Forum owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this g
Hi,
Check this link,
http://www.jiguparmar.com/1_22_Electrical-Engineering.html
*
*
* MARIES*
Excel Inspiration <http://xcel-inspiration.blogspot.com/>
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Pleas
c As Range
Set Sh = Worksheets("Sheet1")
Set Rng = Sh.Range("A20:H20")
For Each c In Rng
StrFtr = StrFtr & c & " "
Next c
ActiveSheet.PageSetup.LeftFooter = StrFtr
End Sub
--
*
*
* MARIES*
Excel Inspiration <http://xcel-inspir
post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to
*PFA...*
On Wed, May 16, 2012 at 8:11 PM, Maries wrote:
> Hi,
>
> Try it,
> *
> =COLUMN()*25+ROW()*
>
>
>
> On Wed, May 16, 2012 at 8:05 PM, Mangesh Dayne wrote:
>
>> I am happy for your kind support
>>
>> Pls help me again for below i
#x27;t ever post 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@goog
Hi,
Find the attachments..
--
*
*
* MARIES*
Excel Inspiration <http://xcel-inspiration.blogspot.com/>
--
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
ead 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 a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you re
Hi,
PFA...
*
*
* MARIES*
Excel Inspiration <http://xcel-inspiration.blogspot.com/>
--
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 Advic
Hi,
Try this formula,* =TEXT(B2-A2,"[h]:mm:ss")*
*
*
*
*
On Mon, May 14, 2012 at 9:40 PM, Seraj Alam wrote:
> Hi Expert,
>
>
> I have attached sheet in which I need total time taken in column C, I have
> applied formula but its not working properly. So please help me on this one.
>
>
> --
> Than
Hi,
It can be VBA Try below code,
Sub ShNmeChng()
Dim nme As String
nme = InputBox("Enter sheet name here...")
ActiveSheet.Name = nme
End Sub
Regards,
MARIES.
On Mon, May 14, 2012 at 4:27 AM, hilary lomotey wrote:
> EXCELLENT IT WORKED but i guess u cant change the shee
Try it,
=MID(CELL("filename"),FIND("]",CELL("filename"))+1,LEN(CELL("filename")))
On Mon, May 14, 2012 at 4:16 AM, hilary lomotey wrote:
> the name of the current sheet into one of the cells
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Po
*Can you share sample file with details*
On Sun, May 13, 2012 at 9:35 PM, coolguy wrote:
> Hiii
>
>
> i need a help ..
>
> i have an excel sheet which changes dyamically and gives the word "BUY" in
> a cell C3
>
> when C3 = buy i need to copy the values A3 B3 and D3 to another sheet .. (
> l
*=ROUNDUP(A1,0.1)
*
On Thu, May 10, 2012 at 2:55 PM, Deepak Rawat wrote:
> =ROUND(E12,0)
>
> Regards,
> Deepak Rawat
>
>
>
> On Thu, May 10, 2012 at 5:08 PM, Ashish Bhalara > wrote:
>
>> Dear expert,
>>
>> The function Round(value,0) display result i.e. 125.55 to 126 and 125.45
>> to 125.
>>
>> M
Try it,
*=INT(A1)+1
*
On Thu, May 10, 2012 at 2:38 PM, Ashish Bhalara
wrote:
> Dear expert,
>
> The function Round(value,0) display result i.e. 125.55 to 126 and 125.45
> to 125.
>
> My result: If the value 125.55 or 125.45 or 125.01 or 125.99 then output
> is 126
>
> In short if value contain an
Hi,
Try this formula in F16.
=IFERROR(INDEX(F$5:F$8,MATCH(1,($A$5:$A$8=$A16)*(F$5:F$8<>""),0)),"")
Apply with "Ctrl+Shift+Enter"
Regards,
MARIES.
On Thu, May 10, 2012 at 11:14 AM, Surendra Singh <
surendra.si...@in.aegisglobal.com> wrote:
>
t Opening Stock,
> Purchase or Issue option qty is same.
>
>
> On Wed, May 9, 2012 at 11:44 AM, Maries wrote:
>
>> Hi,
>>
>> Try below codes,
>>
>> Private Sub Worksheet_Change(ByVal Target As Range)
>> If Target.Cells.Count > 1 Or Target.Column <>
Hi,
Try below codes,
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.ScreenUpdating = False
With Worksheets(1).PageSetup
.LeftMargin = Application.InchesToPoints(0.05)
.RightMargin = Application.InchesToPoints(0.05)
.TopMargin = Application.InchesToPoints(0.05
,3,FALSE)"
Else
Target.Offset(0, 3) = ""
End If
End Sub
Regards,
MARIES.
On Tue, May 8, 2012 at 10:40 PM, Smitha S R wrote:
> Hi,
>
> PFA the statement with the formula as mentioned in the below mail.
>
> But if the particulars is selected Purchase /Issue other than Open
HI,
Try Vlookup for bring closing datas...
=VLOOKUP(D2,'Closing St n Utlzn-Apr 2012'!$A$2:$C$65,3,FALSE)
Regards,
MARIES.
On Tue, May 8, 2012 at 9:31 PM, Smitha S R wrote:
> Hi,
>
> PFA the attachment.
>
> Office stock consumption statement is attached where I need
Hi Tony,
I have done by formula... Just check the sheets cells. There is no Macro
codes inside.
Regards,
MARIES.
On Mon, May 7, 2012 at 5:13 PM, Tony Wu wrote:
> Sorry ... I didn;t see the Macro in the attachment.
> thanks,
> Tony
>
>
> On Saturday, May 5, 2012 9:23:46 AM U
Revised...
On Sun, May 6, 2012 at 12:19 AM, Maries wrote:
> Hi,
>
> Find the attachment I hope this fulfill your requirements
>
> Regards,
>
> MAIRES.
>
>
> On Sat, May 5, 2012 at 11:37 PM, BS CTC wrote:
>
>> FIFO calculation means calcula
ope you understand the calculation.
>
> The closing value of stock will be calculated on the Balance Quantity (@
> of last purchase rate)
>
> ** **
>
> Thanks & Regards,
>
> BS
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> *
*Can you explain more about FIFO calculation.*
On Fri, May 4, 2012 at 8:19 PM, B Sharma wrote:
> Dear Friends and excel experts,,
>
> I have a sheet in which there are columns like "Qty""Rate" of purchase
> of items,
> In Another sheet I need a formula for auto calculation of consumption
Hi,
Check the attachment.
Regards,
MARIES.
On Fri, May 4, 2012 at 12:27 PM, Tony Wu wrote:
> Hello,
>
> I have a file for the forecast demand, some parts have substitution, what
> I need is if the part has substitution, the original demand will be added
> to the new pa
Try this too,
=QUOTIENT(A1,1000)*1000
On Sat, May 5, 2012 at 5:47 AM, Maries wrote:
> *Asa, Good Information*
>
>
> On Fri, May 4, 2012 at 6:44 PM, Asa Rossoff wrote:
>
>> Hi Shekhar,
>>
>> ** **
>>
>> Either of these:
>>
*Asa, Good Information*
On Fri, May 4, 2012 at 6:44 PM, Asa Rossoff wrote:
> Hi Shekhar,
>
> ** **
>
> Either of these:
>
> =ROUNDDOWN(A1,-3)
>
> =MROUND(A1-500,1000)
>
> ** **
>
> If you wanted to round to the nearest multiple of 1000, instead of
> rounding down, you cou
Hi,
Check below link,
http://www.angelfire.com/biz7/julian_s/julian/julians_macros.htm
Regards,
MARIES.
On Sat, May 5, 2012 at 4:41 AM, karthik N wrote:
> Hi Friends,
>
>
> How learn the macro's in step by step,kindly provide the any macro
> tutorial website
>
&
Hi,
Find the attachment.
Regards,
MARIES.
On Fri, May 4, 2012 at 11:03 PM, Vijayendra Rao wrote:
> Dear Deba Ranjan,
>
> Thanks for efforts, I knew this formula and it was not solved my problem.
>
> I need the below details if any one worked 4th October 2011 to 4th May 2012
Hi,
Try it,
Sub insertrows()
Dim i As Long
On Error Resume Next
For i = Cells(Rows.Count, "A").End(xlUp).Row To 2 Step -1
Cells(i, "A").EntireRow.Insert
Next i
End Sub
Regads,
MARIES.
On Wed, May 2, 2012 at 10:36 PM, vaibhav joshi wrote:
> Hi i wanted to insert a row
>> April'2012
>> He has posted 185 posts in April 2012 and helped many people through his
>> expertise. He has been consistent contributor to this excel forum and has
>> acheived this recognition many times.
>>
>> Thanks to Don, Noorain, Asa, Maries, and oth
*Can you share sample file...*
On Wed, May 2, 2012 at 9:58 PM, vaibhav joshi wrote:
> Dear all
>
> I am having a sheet ,which contains data of various parties.
> I want to insert row at each change in party name automatically ,whether
> it can be done automatically or i have to make it manually
Hi,
Try below code,
Sub CompareWorksheets(ws1 As Worksheet, ws2 As Worksheet)
Dim r As Long, c As Integer
Dim lr1 As Long, lr2 As Long, lc1 As Integer, lc2 As Integer
Dim maxR As Long, maxC As Integer, cf1 As String, cf2 As String
Dim rptWB As Workbook, DiffCount As Long
Application.ScreenUpdatin
*Can you show sample OUTPUT in another column...*
*
*
On Sat, Apr 21, 2012 at 1:16 AM, Ashish Bhalara
wrote:
> Dear sir,
>
> I want to write the cell address to fulfill formula, is there any solution
> for it?
>
> Ashish
>
>
> On Sat, Apr 21, 2012 at 12:29 PM, Waseem Saifi wrote:
>
>>
>> I hope th
Hi,
Try this formula,
=CEILING(ROW()/11,1)
On Wed, Apr 18, 2012 at 1:36 AM, Krishnaraddi wrote:
>
> Hi Experts,
>
> I have attached the sheet with question. I require formula which will give
> number to repeat 11 times and 12th numer should be next serial number which
> should reeat again 11
**
On Tue, Apr 17, 2012 at 11:00 PM, kevin pietersen wrote:
> infotargets.com
--
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
Hi,
Try it,
Private Sub Workbook_Open()
Application.OnKey "^d", ""
End Sub
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.OnKey "^d"
End Sub
On Tue, Apr 17, 2012 at 3:36 AM, muralidhar e wrote:
>
> hi, anil
>
> Iam not understand, if u not feel can u explain it.
>
> *Iam wha
Hi,
Check these links...
http://www.excelmagic.com/inventorymagic.html
http://www.excel-skills.com/excel_templates.asp#InventoryUsage
On Mon, Apr 16, 2012 at 6:22 PM, raghu gr wrote:
> hi,
>
> how to maintain inventory in excel. if any one have samples pls let me know
>
>
> Thank you
>
> wit
Hi Anil,
Its very good formula made by Mr.Haseeb. 29 is used to pick the dates.
check below,
[image: Inline image 1]
like 28,30 also can use.
Regards,
MARIES.
On Mon, Apr 16, 2012 at 11:25 AM, anil panchal wrote:
> Dear All,
>
> Why Use *29???
>
> =TEXT(LOOKUP(MONT
*PFA...*
On Mon, Apr 16, 2012 at 11:04 AM, Maries wrote:
> Hi,
>
> Try it,
>
> =TEXT((B5-INT(B5))+(C5-INT(C5)),"[h]:mm:ss")
>
> On Mon, Apr 16, 2012 at 10:50 AM, anil panchal wrote:
>
>> TEXT(B5+C5,"[h]:mm:ss")
>
>
>
--
FORUM RULES
Hi,
Try it,
=TEXT((B5-INT(B5))+(C5-INT(C5)),"[h]:mm:ss")
On Mon, Apr 16, 2012 at 10:50 AM, anil panchal wrote:
> TEXT(B5+C5,"[h]:mm:ss")
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help
Hi,
To get the percentage, *Copy paste* or *Drag Down* the formula from *
Sheet1-D4*.
On Mon, Apr 16, 2012 at 1:10 AM, Sara Lee wrote:
> Hi
>
> So do i have to copy and paste this formula?
>
>
> On Sun, Apr 15, 2012 at 4:32 PM, Maries wrote:
>
>> Hi,
>>
Hi,
In that case, Dynamic range is good solution.
I have used Name Range "rng" refers
as*=OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),COUNTA(Sheet1!$1:$1))
*
Regards,
MARIES.*
*
On Mon, Apr 16, 2012 at 12:14 AM, Sara Lee wrote:
> thanks it is good but one change required--- wh
Hi,
Try this formula,
=B4/OFFSET($A$3,COUNTA(A:A)-1,2)
Regards,
MARIES.
On Sun, Apr 15, 2012 at 10:20 PM, Sara Lee wrote:
> i have created a pivot table in excel in sheet 4 out of sheet 1 data. Now
> i have added a calculation column - right most column of the pivot...
>
> now w
Hi,
Find the attachment...
On Sun, Apr 15, 2012 at 10:27 AM, jmothilal wrote:
>
> PURCHASE / SALES ITEM QTY STOCK
> P LG DVD WRITER 1 1
> P LG DVD WRITER 5 6
> S LG DVD WRITER 1 5
> P LG DVD WRITER 1 6
> P LG DVD WRITER 10 16
> S LG DVD WRITER 4 12
>
>
>
>
--
FORUM RULES (986+ members alread
*Congrats DON...
*
On Sat, Apr 14, 2012 at 12:43 PM, Rajan_Verma wrote:
> Congrats DON
>
> ** **
>
> Rajan.
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Ayush Jain
> *Sent:* Apr/Sat/2012 02:06
> *To:* excel-macros
> *Subject:*
Hi,
Previous one shows the next quarter.
Try below for previous quarter month,
=VLOOKUP(MONTH(TEXT(A1,"")&1),{1,"January";2,"January";3,"January";4,"April";5,"April";6,"April";7,"July";8,"July"
Hi,
Try it,
=VLOOKUP(MONTH(TEXT(A1,"")&1),{11,"January";12,"January";1,"January";2,"April";3,"April";4,"April";5,"July";6,"July";7,"July";8,"October";9,"October";10,
http://www.pivot-table.com/excel-pivot-tables/excel-pivot-table-keyboard-shortcuts
http://office.microsoft.com/en-us/excel-help/basic-keyboard-shortcuts-2-32-RZ102673162.aspx?section=3
http://office.microsoft.com/en-us/excel-help/keyboard-shortcuts-in-excel-2010-HP010342494.aspx
On Thu, Apr 12,
Hi,
Consider, Dates Range is A1:A10,
Try this array formula, (Apply with Ctrl+Shift+Enter)
=SUM(--(COUNTIF(A1:A10,A1:A10)=1))
Regards,
MARIES.
On Tue, Apr 10, 2012 at 8:07 PM, Amit Desai (MERU)
wrote:
> Dear All,
>
> ** **
>
> Please help to calculate unique count for
Haseeb,
*{1,-1}* Your Idea Solid.
On Mon, Apr 9, 2012 at 6:41 AM, Haseeb A wrote:
> =SUM(SUMIF(G3:G409,{">350",">449"},$D$3:$D$409)*{1,-1})
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need H
Hi,
Try Below Formulas,
=SUMPRODUCT(--((G3:G409>350)*(G3:G409<450))*D3:D409)
=SUM(IF(--(G3:G409>350)*(G3:G409<450),D3:D409,0))
Note: second one is Array formula. Apply with Ctr + Shift = Enter.
Regards,
MARIES.
On Mon, Apr 9, 2012 at 5:09 AM, Sara Lee wrote:
> =SUMIF(G3:G409
*Can you share your file...*
On Sun, Apr 8, 2012 at 4:18 AM, David wrote:
> I'm looking for assistance in fixing a problem a user found.
>
> I have a form created in Excel 2010. All cells on the form were locked -
> then specific cells were unlocked. This allowed the users to only modify
> the
o.uk/mps/ Thomas Möller
http://www.Team-Moeller.de<http://www.team-moeller.de/> Tony
Toews http://www.granite.ab.ca
Regards,
MARIES.
On Sun, Apr 8, 2012 at 5:03 PM, Rajan_Verma wrote:
> You can find sql queries on that link , please check this link
>
> ** **
>
> http://w
Hi,
As Don explained, I have used Array Formulas.
Check below link for more details,
http://www.excelfunctions.net/Excel-Array-Formulas.html
Regards,
MARIES.
On Sun, Apr 8, 2012 at 1:50 AM, dguillett1 wrote:
> If you mean { } this is because it is an array formula where you do
&g
Hi,
PFA. Change A1. You will get answer for any months.
Regards,
MARIES.
On Sun, Apr 8, 2012 at 12:34 AM, Rajan_Verma wrote:
> Pivot will work for huge data also.. and if you are talking about formula
> ,with large data it can be cause to make your processing slow, macro can be
>
?
On Sat, Apr 7, 2012 at 9:48 AM, Rajan_Verma wrote:
> Do you need any assistance ??
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Atef Gobran
> *Sent:* Apr/Sat/2012 06:35
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel
For other columns,
Sub Macro1()
Sheets("Results").Range("A2:A" &
ActiveSheet.UsedRange.Rows.Count).EntireRow.Clear
End Sub
On Fri, Apr 6, 2012 at 4:03 AM, Domain Admin wrote:
> And would offset(0,1) mean skip the first column?
>
> On Thu, Apr 5, 2012 at 5:01 PM, Domain Admin
> wrote:
> > That
Try it now,*
Sheets("Results").Range("A2:A" & ActiveSheet.UsedRange.Rows.Count).Clear*
On Fri, Apr 6, 2012 at 3:42 AM, Domain Admin wrote:
> That clears the header row too. I need to keep that row intact.
>
> On Thu, Apr 5, 2012 at 4:36 PM, Maries wrote:
&g
*Sheets("Results").Range("A2:A" & ActiveSheet.UsedRange.Rows.Count).Clear*
On Fri, Apr 6, 2012 at 3:36 AM, Maries wrote:
> Try it,
>
> Sheets("Results").Cells.ClearContents
>
>
>
> On Fri, Apr 6, 2012 at 3:29 AM, tangledweb wrote:
&g
Try it,
Sheets("Results").Cells.ClearContents
On Fri, Apr 6, 2012 at 3:29 AM, tangledweb wrote:
> Results
--
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 Probl
No need Value formula,
It can do it, =SUMIF($C$2:$C$113,A2,$D$2:$D$113)
On Fri, Apr 6, 2012 at 12:51 AM, Maries wrote:
> Hi,
>
> Try below formula,
>
> =SUMIF($C$2:$C$113,VALUE(A2),$D$2:$D$113)
>
> Regards,
>
> MARIES.
>
>
>
> On Thu, Apr 5, 2012 at 11:
*Try it, =TEXT(INT(A1),"DD/MM/")*
On Thu, Apr 5, 2012 at 7:54 PM, vijayajith VA wrote:
> Hi ,
>
> 12/2/2001 12:00 PM --- How to remove time ? i need only date ..
> is thr any formula ..Thanks in advance
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use conci
Hi Mohammed,
Try Below Formula with Ctrl + Shift + Enter.
=SUM((AB11:AB249<0)*SUBTOTAL(109,INDIRECT("AB"&ROW(11:249
Regards,
MARIES.
On Wed, Apr 4, 2012 at 5:20 PM, Maries wrote:
> *PFA...*
>
>
> On Wed, Apr 4, 2012 at 4:25 PM, Rajan_Verma wrote:
>
&
Thanks Rajan...
On Wed, Apr 4, 2012 at 12:39 PM, Rajan_Verma wrote:
> Nice solution marries J
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Maries
> *Sent:* Apr/Wed/2012 10:20
> *To:* excel-macros@googlegr
*PFA...*
On Wed, Apr 4, 2012 at 4:25 PM, Rajan_Verma wrote:
> Use only SUubtotal(109,rng_Sum)
>
> When you will apply filter it will sum only visible cells
>
> ** **
>
> Rajan.
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of
Dear Friends,
Very Useful Link,
http://office.microsoft.com/en-us/excel-help/excel-functions-by-category-HP010342656.aspx#BMcompatibility_functions
Regards,
MARIES.
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like
Hi,
Try below array formula,
=MAX(IFERROR(RIGHT(C2,{1,2,3,4,5,6,7,8,9,10})*1,""))
Apply with Ctrl + Shift + Enter.
Regards,
MARIES
On Wed, Apr 4, 2012 at 10:21 AM, Waseem Saifi wrote:
> please check attached file.
>
>
> On Wed, Apr 4, 2012 at 1:17 AM, Aamir Shahzad
Hi,
PFA. Use below Array formula,
=IFERROR(INDEX($B$4:$E$4,MATCH(B$9,OFFSET($A$4,MATCH($A10,$A$5:$A$7,0),1,1,4),0)),"")
Regards,
MARIES.
On Wed, Apr 4, 2012 at 7:16 AM, rekha siri wrote:
> Hi I need assistance in finding the right formula to substitute the value
> to da
Hi,
Try, below shown Array formula. (Apply with CSE)
=SUM((--INT(D7:D955)>=H13)*--(INT(D7:D955)<=H14))
Conditions, H13-Start Date & H14-End Date
Regards,
MARIES
On Mon, Apr 2, 2012 at 11:47 AM, LAKSHMAN PRASAD wrote:
> Dear Shrini**
> Plz find out solve attach
Hi,
Try below formula for TOI values.
=TEXT(A1,"h:mm AM/PM")
Regards,
MARIES.
On Mon, Apr 2, 2012 at 1:40 AM, qcan wrote:
>
>
> Hi,
>
> There is probably a very simple solution here, but I am stumped.
>
> In this link below, you will see a table that has a fie
ound at http://www.excelfox.com/forum/f10/
>
> Regards,
> Sam Mathai Chacko
>
>
> On Tue, Apr 3, 2012 at 1:23 AM, Maries wrote:
>
>> Hi Raj,
>>
>> Check below link,
>>
>> http://jackmcintyre.net/how-to-add-macros-to-the-excel-2007-ribbon/
>>
>> Dear F
Hi Haseeb, Great Solution...
On Mon, Apr 2, 2012 at 1:54 AM, pawel lupinski wrote:
> Hi Again,
>
> Thanks again, it's all working, I have a lot to learn what is great,
> you've shown me the magic.
>
> thanks
>
> Pawel
>
>--
> *From:* pawel lupinski
> *To:* "exce
Tool<http://openxmldeveloper.org/articles/CustomUIeditor.aspx>for
customize the Ribbon.
Regards,
MARIES.
On Mon, Apr 2, 2012 at 10:10 PM, Rajan_Verma wrote:
> I think u should create custom menu to display that in Ribbon
>
> ** **
>
> Rajan
>
> ** **
>
> *Fr
My Try,
Array formula, {=SUM(--(MONTH(Sheet1!A2:A7)=A1)*Sheet1!B2:B7)}
Regards,
MARIES.
On Mon, Apr 2, 2012 at 5:47 PM, dguillett1 wrote:
> =sumproduct((month(sheet1!a2:a200)=a1)*sheet1!b2:b200
>
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate
*Convert the formula contain cell into Time format*
On Sun, Apr 1, 2012 at 4:20 PM, Aamir Shahzad wrote:
> Dear Maris - your formula is giving 0.23 result if enter 532, required by
> powel was 5:32
>
> Aamir Shahzad
>
> On Sun, Apr 1, 2012 at 4:07 PM, Maries wrote:
>
h INT formula for decimal entries (For
Decimal condition formula shown below)
=TIME(TEXT(INT(A1),"00"),(A1*100)-(INT(A1)*100),0)
Now it is working for all our conditions like, 532,,2.3,12.10etc.
I hope this is fulfill your requirements.
Regards,
MARIES.
On Thu, Mar 29, 2012 at
2012 at 11:41 AM, Asa Rossoff wrote:
> Sorry, Sandeep, I did not immediately see that you needed copies of another
> sheet. Maries has you.
>
> Asa
>
> -Original Message-
> From: Asa Rossoff [mailto:a...@lovetour.info]
> Sent: Saturday, March 31, 2012 12:40 AM
&g
1 - 100 of 226 matches
Mail list logo
