unsubscribe
--
Thanks & Regards
Shivashankar.C.Katageri
9945800300
--
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 at
Dear Shivshankar,
http://groups.google.com/group/excel-macros/subscribe
click on unsubscribe
On Fri, Jan 13, 2012 at 2:09 PM, shivashankar katageri <
shankarkatag...@gmail.com> wrote:
> unsubscribe
> --
> Thanks & Regards
>
> Shivashankar.C.Katageri
>
> 9945800300
>
> --
> FORUM RULES (986+ me
Hi All,
Plz find the attached file and mention the formula.
--
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
Thanks Kris, the formmula works, but one more problem has come. Sheet
is attached again for providing solution.
Nemi
On Jan 12, 8:01 am, Kris wrote:
> Hi,
>
> I assume you enter NOW() in Q3.
>
> In R3:
>
> =MOD(Q3,1)
>
> In S3:
>
> =INDEX(D4:O4,,MATCH(MIN(ABS(R3-INDEX(D5:O28,MATCH(INT(Q3),INT(C5
Problem in getting result, hence sheet is attached once again.
Nem Gandhi
--
Nemi Gandhi
98204 92963
--
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
No Sir i want macros, because of in my log i have mentioned so many
formulas so the excel sheet is gets very slow hence i want macros.
Please do the needful.
Regards
Lokesh.M
On Fri, Jan 13, 2012 at 3:23 PM, Anjul Porwal wrote:
> hi,
>
> use formula *IF(ISTEXT(A2),"Delete","")*
>
> Regards
> A
hi Anil,
please use
=SUMPRODUCT(--(HOUR($B$2:$B$50)=13)*($A$2:$A$50=D$3))
Regards
Anjul
On Fri, Jan 13, 2012 at 2:45 PM, Anil Saxena wrote:
> Hi All,
> Plz find the attached file and mention the formula.
>
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concis
Hi Anil,
Also can use below formula,
=SUM(--(HOUR(B2:B50)=13)*--((A2:A50)=D3))
(With Ctrl+Shift+Enter)
Regards,
MARIES.
On Fri, Jan 13, 2012 at 3:21 PM, Anjul Porwal wrote:
> hi Anil,
>
>
> please use
>
> =SUMPRODUCT(--(HOUR($B$2:$B$50)=13)*($A$2:$A$50=D$3))
>
> Regards
> Anjul
>
>
>
>
>
>
Dear Group Members,
This query is related to MS Access 2007. I hope you will be able to solve it.
I have created the following table in Access.
Dealer Code Dealer Name RDSSch-1 Payout Sch-2 Payout
A ABCDEF
Try this :
=INDEX(C4:N4,MATCH(Q3,INDIRECT("C" & MATCH(P3,$B$4:$B$28,0)+4
&":o"&MATCH(P3,$B$4:$B$28,0)+4),1))
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Nemi Gandhi
Sent: Jan/Fri/2012 03:29
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$
Use custom filter "is Greater then or equal to " with "a" then delete all
visible rows
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Lokesh Loki
Sent: Jan/Fri/2012 03:12
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Delete text
Hi
Please explain what kind of invoice management application are you looking
for.. what will that do?
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Amresh Maurya
Sent: Jan/Fri/2012 11:33
To: excel-macros@googlegroups.com
Subject: $$Excel-Ma
See the attached
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Anil Saxena
Sent: Jan/Fri/2012 02:46
To: Dilip Pandey
Cc: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Plz do the needful
Hi All,
Plz find the attached file and mention the
This leaves col a as desired.If you don’t need to keep then delete 1st line and
change D to A
Sub Copycolatod_DeleteTextSAS()
Columns("A").Copy Range("D1")
Columns("D").SpecialCells(xlCellTypeConstants, 2).Delete Shift:=xlUp
End Sub
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Lokes
Try this :
Sub DeleteTextOnly()
Dim wksSheet As Worksheet
Set wksSheet = ThisWorkbook.Worksheets("SHeet1")
Application.ScreenUpdating = False
wksSheet.Range("A1").AutoFilter 1, ">=a"
wksSheet.Range("A2").Resize(wksSheet.Range("a2").End(xlDown).Row,
1).SpecialCel
Hi guys, i´m doing a excel file for comparatives of the year 2010, 2011,
2012, the problem is that i need to compare days, like if i choose to see
day 10 January of 2012 with the 2011, i must compare the same number of
cells with values, so it has to compare 11 january 2011 that has 7 numbered
sums
Hi Friend,
as per my observation, please find the attachment
Team
XLS
On Fri, Jan 13, 2012 at 8:37 PM, Jorge Marques wrote:
> Hi guys, i´m doing a excel file for comparatives of the year 2010, 2011,
> 2012, the problem is that i need to compare days, like if i choose to see
> day 10 January o
for which type process like inbound or outbound
On Thu, Jan 12, 2012 at 4:29 PM, hemanath dhanasekar wrote:
> Hey Friends,
>
> I am Hemanath working in a Leading BPO as Team Leader, I am new to this
> industry and I need your help folks
>
> Can anyone help me in sharing the SLA and Productivity T
Hi, thanks for any help.
I have a form to input data in a worksheet. One of this data is a
number, but when I put in the excel this data, the calculation doens´t
work.
The formula in the field is:
Cells(Ultimalinha, 15).Value = BemImovel
There is a value in the form (Bem Imovel), USD 5000
I’m looking at your file and trying to determine what you want.??? Do you want
to know the sum for 11 Jan of each year? What___
A better explanation and example showing comes from what cell or cells
__to where__and why_?
Don Guillett
SalesAid Software
dguille...@gmail.co
Dear Maries/Anjul Porwal,
Why tou use "13" in your formula. can you brief?
Regards,
Aamir Shahzad
On Fri, Jan 13, 2012 at 6:21 PM, Rajan_Verma wrote:
> See the attached
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Anil Saxena
> *Sent:*
Dear Aamir,
very simple 13 mean 1 pm and 14 mean 2 pm
but as per your example sheet you should need to replace 14 to 15..
because 15 mean 3 to 3
On Fri, Jan 13, 2012 at 10:46 PM, Aamir Shahzad wrote:
> Dear Maries/Anjul Porwal,
>
> Why tou use "13" in your formula. can you brief?
>
> Regards
Hi All,
Thanks to all of you experts, Keep rocking !.
Regards
Lokesh.M
On 1/13/12, NOORAIN ANSARI wrote:
> Dear Lokesh,
>
> Please try it..
>
> Sub Copy_and_Delete_Text()
> Dim rng, rng1, rng2 As Range
> Dim i, j As Long
> Set rng = Sheet1.Range("A1:A" & Sheet1.Range("A65536").End(xlUp).Row
Sub RemoveText()
Dim lngRows As Long
lngRows = Application.Max(Worksheets("Deleted
report").Cells(Rows.Count, "A").End(xlUp).Row, 2)
With Worksheets("Add Extracted")
.Range("E2:E" & Application.Max(.Cells(Rows.Count,
"E").End(xlUp).Row, 2)).Clear
With .Range("E2").Resiz
Hi Sam,
Thanks for doing this to me.
Regards
Lokesh.M
On Sat, Jan 14, 2012 at 9:02 AM, Sam Mathai Chacko wrote:
> Sub RemoveText()
>
> Dim lngRows As Long
> lngRows = Application.Max(Worksheets("Deleted
> report").Cells(Rows.Count, "A").End(xlUp).Row, 2)
> With Worksheets("Add Extra
Dear Group,
Thanks for the response. But there is no total at the end for the schemes.
Moreover for each dealer there will be hundreds of schemes so please let me
know the steps followed to prepare the report.
Thanks & Regards...
CA Vivek Jain, FCA, DISA (ICAI)
Vivek Shantilal Jain & Co.
You are welcome.
In keeping with Donald's solution, here's a shorter version
Sub RemoveText()
Dim lngRows As Long
lngRows = Application.Max(Worksheets("Deleted
report").Cells(Rows.Count, "A").End(xlUp).Row, 2)
With Worksheets("Add Extracted")
.Range("E2:E" & Application.Max(.
OK, Thanks for your suggestion SAM.
Thanks for your help.
Regards
Lokesh
On Sat, Jan 14, 2012 at 9:11 AM, Sam Mathai Chacko wrote:
> You are welcome.
>
> In keeping with Donald's solution, here's a shorter version
>
>
> Sub RemoveText()
>
> Dim lngRows As Long
> lngRows = Application.Ma
Try this, Cells(Ultimalinha, 15).Value = BemImovel ^ 1
Regards,
Sam Mathai Chacko
On Fri, Jan 13, 2012 at 10:40 PM, Marcio Bandeira <
marciobandeir...@gmail.com> wrote:
> Hi, thanks for any help.
>
>I have a form to input data in a worksheet. One of this data is a
> number, but when I put i
Here's a simplified formula using named ranges
=INDEX($D$4:$O$4,MATCH(MIN(TimeArray),TimeArray,0)),
where TimeArray = =Sheet1!$R4-(Sheet1!$R4>=DateRow)*(DateRow),
where DateRow =
=OFFSET(Sheet1!$D$4:$O$4,MATCH(Sheet1!$Q4,Sheet1!$C$5:$C$27,0),0,1)
If you want a formula without a named range, you
Dear All,
Congrats for all excel macros group users ,
I have a excel where data is in Sheet1 to Sheet4.
I would expect from any one of you to provide macro for getting rows delete
from row 2 to till end
Only Header should remain when macros runs. (i.e Range "A1" should remain)
Please try to h
Sub DelRows()
Dim wks As Worksheet
For Each wks In ThisWorkbook.Worksheets
With wks
.Range("A2",
.UsedRange.SpecialCells(xlCellTypeLastCell)(2)).EntireRow.Delete
End With
Next wks
End Sub
Regards,
Sam Mathai Chacko
On Sat, Jan 14, 2012 at 8:07 AM, yogan
Hi Gurus,
Please find the attached querY
Thanks in adv.
--
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
You can use COUNTIFS, but SUMPRODUCT, should be an easy option since it
will work in Excel 2003 or 2007+
Regards,
Sam Mathai Chacko
On Sat, Jan 14, 2012 at 12:30 PM, vijayajith VA wrote:
> Hi Gurus,
>
>
> Please find the attached querY
>
> Thanks in adv.
>
> --
> FORUM RULES (986+ members alrea
34 matches
Mail list logo