Dear Praneet,
Please convert your Excel File in Access and use below query
SELECT Logfile.Salary from Logfile
WHERE (Logfile.Name)=[Enter a Name];
*ORDER BY *Logfile* ASC*
--
Thanks regards,
Noorain Ansari
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/
On Wed,
Dear Praneet,
Try Ms Access(or)Sql Server..
--
*Best Regards,*
*Venkat*
*Chennai*
*
*
On Wed, Jul 27, 2011 at 10:42 PM, XLS S xlst...@gmail.com wrote:
Dear Praneet,
Use Ms Access,..is it possible to provide the data?
please provide the raw data
On Wed, Jul 27, 2011 at
both file from Haseeb and Ashish working GRAET!!!
thanks a lot to you both
Pawel
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2.
Hi,
Thanks a lot for quick reply. It works well.
Regards
Anwar
On Thu, Jul 28, 2011 at 11:24 AM, §»VIPER«§ viper@gmail.com wrote:
Hi Anwer
pfa. it may help
--
*Great day,*
*viper
*
On Thu, Jul 28, 2011 at 10:17 AM, Anwar Mohd anr7no...@gmail.com wrote:
Hi Experts,
I
Hi Ashish,
Any solution for this. Thanks in advance.
-- Forwarded message --
From: Chandra Shekar chandrashekarb@gmail.com
Date: Fri, Jul 22, 2011 at 1:21 PM
Subject: Re: $$Excel-Macros$$ Extracting data from Website
To: excel-macros@googlegroups.com
Hi Asish,
How to pull
Hi Mohan,
If you want to get the data based on Multiple Criteria in 2007 You May Try
Countifs,Sumifs,Averageifs
*Best Regards,*
*Venkat*
*
*
*
*
On Thu, Jul 28, 2011 at 8:38 AM, Mohanraj shunmugam
mohanraj2...@gmail.comwrote:
dear team member,
i need formula for multiple criteria to find
can you send me link and text you want to extract
On Thu, Jul 28, 2011 at 11:54 AM, Chandra Shekar
chandrashekarb@gmail.com wrote:
Hi Ashish,
Any solution for this. Thanks in advance.
-- Forwarded message --
From: Chandra Shekar chandrashekarb@gmail.com
Date: Fri,
Dear All,
Please find attached Excel Test.
--
Thanks regards,
Noorain Ansari
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/
--
--
Some important links for excel users:
1. Follow us on
Hi sundar
here is the solution for all without array
Min (-)tive value =MIN(A1:A10)
Min (+)itive value
=SMALL(A1:A10,(COUNT(A1:A10)-COUNTIF(A1:A10,=0)+1))
Max (-)tive value
=LARGE(A1:A10,(COUNT(A1:A10)-COUNTIF(A1:A10,0)+1))
Max (+)itive value =MAX(A1:A9)
--
*Great
Cheers. .
Thanks,
DILIPandey
On 7/28/11, qcan comeonove...@gmail.com wrote:
THANK YOU EVERYONE. I am in awe with the knowlege you guys have. WELL
DONE !
On Jul 27, 2:25 am, Rajan_Verma rajanverma1...@gmail.com wrote:
Try this..
Sub Reverse()
Dim fRng As Range
Dim Couter As Integer
On Thu, Jul 28, 2011 at 12:05 PM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
Dear All,
Please find attached Excel Test.
--
Thanks regards,
Noorain Ansari
*http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/
--
Enjoy ...
On Thu, Jul 28, 2011 at 9:16 AM, Muhammad Talal Akbar
sh.talal.ak...@gmail.com wrote:
okay thanks dear
On Wed, Jul 27, 2011 at 6:03 PM, XLS S xlst...@gmail.com wrote:
Dear Akabr,
Coming soon Daily Doze VBA Classes Just wait.
Just Download PDF for learn VB
Dear Haseeb,
Thanks for your reply. But result is not coming with this formula.
Thanks once again.
Kalyan Chattopadhyay
On Thu, Jul 28, 2011 at 12:21 AM, Haseeb Avarakkan
haseeb.avarak...@gmail.com wrote:
Hello Kalyan,
If you just have two customers, you can hard coded as array use 1
Hi,
You should indicate the file name before the function :
Eg. Personal.xlsb! SpellNumber...
Regards.
Daniel
-Message d'origine-
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de aju chacko
Envoyé : jeudi 28 juillet 2011 06:10
À :
Dear Arpit,
Please try below code to delete row equal to 0 in J Column..
Sub delete_row()
dim i,j as long
application.screenupdating=false
j=application.worksheetfunction.counta(sheet22.range(J:J))
for i=1 to j
if sheet22.cells(i,10).value=0 then
sheet22.range(Ji).EntireRow.Delete
end if
Hi,
Another way to do it :
Sub test()
Dim rgRange As Range
With Sheets(Report)
Set rgRange = Range(.[A1], .Cells(.Rows.Count, 1).End(xlUp).Offset(, 9))
rgRange.AutoFilter 10, 0
Set rgRange = rgRange.Offset(1).Resize(rgRange.Rows.Count - 1)
Set rgRange =
Hi excel gurus,
I am using excel 2007.I want to give all my custom excel function (UDF) a
felling like real function can it possible?
I want to show the user all help to be prompt when they select the UDF.
Thanks in advance.
Sandeep Kr. Chhajer.
Sent on my BlackBerry® from Vodafone
--
Hi All,
Could you help me with VB code for Reverse Vlookup function command where we
can lookup value from Right to Left.
Some similar to Vlookup but lookup from Right to Left.
Please give me a function code so that I can able to save this in Personal
workbook and use in all excel file.
Hi,
In the below link I need to extract data by name i.e.*Chandra Shekar *in
comments columns.
Thank you in advance.
http://chandoo.org/wp/2010/01/27/pivot-table-tricks/
On Thu, Jul 28, 2011 at 8:32 AM, ashish koul koul.ash...@gmail.com wrote:
can you send me link and text you want to extract
Thanks Noorain for your quick respond.
It will not delete all rows properly at one time, about 50% 0 values row
penidng at the time of appling logic first time. i made some change but its
going hang. can you please modify it.
Sub delete_row()
dim i,j as long
Thaks Daniel,
your logic is super.
On Thu, Jul 28, 2011 at 4:09 PM, Daniel dcolarde...@free.fr wrote:
Hi,
** **
Another way to do it :
** **
Sub test()
Dim rgRange As Range
With Sheets(Report)
Set rgRange = Range(.[A1], .Cells(.Rows.Count,
Hi Anil,
Look Attached it will help u...
*Best Regards,*
*Venkat*
*Chennai*
On Thu, Jul 28, 2011 at 4:16 PM, Anil Bhange
anil.bha...@tatacommunications.com wrote:
Hi All,
** **
Could you help me with VB code for Reverse Vlookup function command where
we can lookup value from Right
Hi Sandeep,
Save your UDF function as a .XLA (or)XLAM and you may open and use it...
*Best Regards,*
*Venkat*
*Chennai*
On Thu, Jul 28, 2011 at 4:13 PM, chhajersand...@gmail.com wrote:
Hi excel gurus,
I am using excel 2007.I want to give all my custom excel function (UDF) a
felling like
try sumproduct.
SUMPRODUCT((A2:A31=A35)*(B2:B31=B35)*C2:C31)
On Thu, Jul 28, 2011 at 11:57 AM, Venkat CV venkat1@gmail.com wrote:
Hi Mohan,
If you want to get the data based on Multiple Criteria in 2007 You May Try
Countifs,Sumifs,Averageifs
*Best Regards,*
*Venkat*
*
*
*
*
On
Hope it will Help you
Sub HighLight()
Application.ScreenUpdating = False
On Error Resume Next
Dim cell As Range
Dim rng As Range
Dim st As String
Dim loc As Integer
Dim n as string
st =
Set rng = ActiveSheet.UsedRange
For Each cell In rng
another way to delete simple just select the rows.
simple macro to understand.
*Sub deleterow()
Application.ScreenUpdating = False
Dim cell As Range
Set cell = Selection
For Each cell In Selection
If cell.Value = 0 Then
cell.EntireRow.Delete
End If
Next cell
End Sub
*
On Thu, Jul 28, 2011 at
See the attached sheet with SUmifs Function
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Adam Hamilton
Sent: Thursday, July 28, 2011 9:17 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ VBA Needed to
Use Sumproduct function ti will help you.
as manhy criteria you can put in brackets and get your desire result.
*SUMPRODUCT(($B$3:$B$21=E3)*$A$3:$A$21)*
On Thu, Jul 28, 2011 at 5:05 PM, Venkat CV venkat1@gmail.com wrote:
Hi Anil,
Look Attached it will help u...
*Best Regards,*
Try this ..
please find the attachment
On Thu, Jul 28, 2011 at 5:05 PM, Venkat CV venkat1@gmail.com wrote:
Hi Anil,
Look Attached it will help u...
*Best Regards,*
*Venkat*
*Chennai*
On Thu, Jul 28, 2011 at 4:16 PM, Anil Bhange
anil.bha...@tatacommunications.com wrote:
Dear Arpit,
please try below code..it will be help to delete all row of J
column
Sub delete_row()
Dim i, j As Long
Application.ScreenUpdating = False
j = Application.WorksheetFunction.CountA(Sheet22.Range(J:J))
For i = j To 1 Step -1
If Sheet22.Cells(i, 10).Value = 0 Then
Hey Ranjan qcan want if cell contain any 3 Capital letter then color hole
cell.but your solution color only first 3 letter ...
On Thu, Jul 28, 2011 at 5:32 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
Hope it will Help you
Sub HighLight()
Application.ScreenUpdating = False
Hey Kal xcel,
please clear what you want
On Thu, Jul 28, 2011 at 1:03 PM, Kal xcel kalx...@gmail.com wrote:
Dear Haseeb,
Thanks for your reply. But result is not coming with this formula.
Thanks once again.
Kalyan Chattopadhyay
On Thu, Jul 28, 2011 at 12:21 AM, Haseeb Avarakkan
Thanks XlS S, Venkat and other members, I have the solution for the query but I
thought it would be great to create the VBA Function which help as a formula in
excel.
So could you please help me with VBA code where we all could just type
something like =RLOOKUP() and will get the
Select the Column which have 0 Value and Run this Macro
Sub DeleteBySelection()
On Error GoTo err:
Application.ScreenUpdating = False
Dim rng As Range
Dim cell As Range
Set rng = Selection
For Each cell In rng
If cell.Value = 0 Then
Run this in Claims Paid File
Sub DoSomething()
Dim rng As Range
Dim cell As Range
Dim rng2 As Range
Dim cell2 As Range
Dim i As Integer
i = 1
Set rng = Range(A:A)
rng.Sort Key1:=Range(A2)
rng.Copy Range(D1)
Thanks Rajan,
But Vba is not ending. It is giving me debug required at End If in Vba Code,
further the totals are also not tying after Vba Code applying.
Please do the needful by looking it again.
Regards,
Kaushik
--
HI,
Try the below function ; the parameters are the same as those of the VLOOKUP
function :
Function RLookup(ToSearch, rg As Range, col As Long, Optional ProxVal)
Dim RightRange As Range
If IsError(ProxVal) Then ProxVal = 1
Set RightRange = rg.Resize(, 1).Offset(,
Just to precise that the « col » parameter should be a positive number, the
rightmost column being column 1.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Anil Bhange
Envoyé : jeudi 28 juillet 2011 14:23
À : excel-macros@googlegroups.com
=VLOOKUP(B35;B25:C31;2)
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Anwar Mohd
Sent: Thursday, July 28, 2011 6:48 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ need formula to summarize based on multiple
crteria
Hi Experts,
Sub delRow()
LastRow = Range(j Rows.Count).End(xlUp).Row
For Each cl In Range(j2:j LastRow)
If cl = 0 Then
cl.EntireRow.Delete
End If
Next cl
End Sub
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of NOORAIN ANSARI
Sent: Thursday,
SUBSTITUTE(F1TEXT(G1,ddmmyyy), ,)
On Thu, Jul 28, 2011 at 5:13 PM, Hari harisha.prabha...@gmail.com wrote:
dear members,
can any one solve my query with help of formula, i am very poor in MS
excel.
find the attachement, reply at the earliest.
Thanks in advance,
have a nice day.
--
Thanks a lot dear
On 28 July 2011 18:32, ashish koul koul.ash...@gmail.com wrote:
SUBSTITUTE(F1TEXT(G1,ddmmyyy), ,)
On Thu, Jul 28, 2011 at 5:13 PM, Hari harisha.prabha...@gmail.com wrote:
dear members,
can any one solve my query with help of formula, i am very poor in MS
excel.
find
HI hari for below Query you can just do as F1G1H1 as much as u can..
if you want to use anysyble between then just use as F1-H1.
On Thu, Jul 28, 2011 at 6:49 PM, XLS S xlst...@gmail.com wrote:
Dear Hari,
Use Concatenat Function or operate..please find the attachment
On Thu, Jul 28,
Thanks Daniel,
It's amazing and Finance people on this group will be grateful to you, just one
more request to get this function inbuilt in excel, could you please share how
and where to save the below macro.
Because I tried but not getting answer and it shows Error.
Regards,Anil Bhange
Hey,
Make Add-In
http://support.microsoft.com/kb/285337
http://www.ozgrid.com/VBA/excel-add-in-create.htm
On Thu, Jul 28, 2011 at 7:17 PM, Anil Bhange
anil.bha...@tatacommunications.com wrote:
Thanks Daniel,
** **
It’s amazing and Finance people on this group will be grateful to
You can Use LooKUP Function if Your data is Sorted
=LOOKUP(E3,$B$3:$B$21,$A$3:$A$21)
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Venkat CV
Sent: Thursday, July 28, 2011 5:06 PM
To: excel-macros@googlegroups.com
Cc:
Attached Your File with that Codes
thanks
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of KAUSHIK SAVLA
Sent: Thursday, July 28, 2011 6:14 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Vba Code required
Thanks Rajan,
But Vba
Thanks Rajan.
It works perfectly
Regards,
Kaushik
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @
Sub Delete()
On Error Resume Next
With Range(A1:A5)
.EntireRow.Hidden = False
For i = 1 To .Rows.Count
If WorksheetFunction.Sum(.Rows(i)) = 0 Then
.Rows(i).EntireRow.Delete = True
End If
Next i
End With
End Sub
On Thu, Jul 28, 2011 at 9:54 PM, Prabhu prabhugate...@gmail.com wrote:
Hi Friends,
XLS S, I would tend to believe that progressing from small to large
indices for a row will not solve the problem.
A more conservative approach would be the classic reverse look that
looks like this
Sub DelRowWithZeroes()
Dim lngLoop As Long
With Worksheets(Sheet1).Range(P3:P13)
Hi Friends,
It is taking too long to delete the Zero value cells ans its rows.
Is there any way to select all the Zero value in a particular rows and
remove(Delete) from sheet.
Regards,
Prabhu
--
--
Some
Hi
Try
Sub Mtest()
Dim LR As Long, r As Long
LR = ActiveSheet.UsedRange.Row + ActiveSheet.UsedRange.Rows.Count
Application.ScreenUpdating = False
For r = LR To 1 Step -1
If Application.WorksheetFunction.CountIf(Rows(r), =0) = 1 Then
Rows(r).Delete
Next r
Application.ScreenUpdating = True
End Sub
Hi Anil
Find attach
Try
=LOOKUP(2,1/($A$2:$A$12=D3),$B$2:$B$12)
Thanks
Mahesh
On Thu, Jul 28, 2011 at 4:16 PM, Anil Bhange
anil.bha...@tatacommunications.com wrote:
Hi All,
** **
Could you help me with VB code for Reverse Vlookup function command where
we can lookup value from Right
Is there a way to add a floating message box. Something that will stay
within view as you scroll down or up a page. Thanks in Advance!!
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips
This is great, but how can I add an additional criteria to filter the
correct 'project/investment' that apply?
On Thu, Jul 28, 2011 at 5:12 AM, Rajan_Verma rajanverma1...@gmail.com wrote:
See the attached sheet with SUmifs Function
-Original Message-
From:
Hello Anil.
You can use VLOOKUP for Reverse Lookup. Consider A1:B20 is the data. E2 is
the Lookup_Value from Col_B. So use this,
=VLOOKUP(E2,CHOOSE({1,2},$B$2:$B$20,$A$2:$A$20),2,0)
CHOOSE({1,2},$B$2:$B$20,$A$2:$A$20) will give the array of Col_B value first
then Col_A. So VLOOKUP will work
Great Haseeb, Can you tell me something about CHOOSE,OFFST function
On Fri, Jul 29, 2011 at 5:07 AM, Haseeb Avarakkan
haseeb.avarak...@gmail.com wrote:
Hello Anil.
You can use VLOOKUP for Reverse Lookup. Consider A1:B20 is the data. E2 is
the Lookup_Value from Col_B. So use this,
Please find the link
http://www.excel-vba.com/vba-prog-1-1-editor.htm
On Fri, Jul 29, 2011 at 5:25 AM, mahamadou lawali malaw...@gmail.comwrote:
Thanks a lot for your help, but I am a beginner in VBA.So would you
guys please break it down for me? I've tried to paste the code and I
really
Hi Friends
I'm preparing sales report and i find some problem in this attached file.
Please give me solution.
Thanks in advance
Always SKM
--
--
Some important links for excel users:
1. Follow us on TWITTER for
See if it helps
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of always online
Sent: Friday, July 29, 2011 9:31 AM
To: excel-macros@googlegroups.com
Cc: always...@gmail.com
Subject: $$Excel-Macros$$ Please solve my problem
Hi Friends
I'm preparing
Hi,
pfa. it may help
--
*Great day,*
*viper
*
On Fri, Jul 29, 2011 at 9:53 AM, Rajan_Verma rajanverma1...@gmail.comwrote:
*See if it helps*
* *
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *always online
*Sent:* Friday, July 29, 2011
Thanks .Can I just Copy paste as a simple Flash game I dont want to use
Excel or Word
Is it possible
On Tue, Jul 26, 2011 at 6:34 PM, XLS S xlst...@gmail.com wrote:
Hye..
just click Design mode then cut and paste ...
for more information please find the attachment..
On Tue,
62 matches
Mail list logo
