try this formula or attached file
=IFERROR(INDIRECT(dSMALL(IF(IF(COUNTIF($E$3:$E$5,$D$3:$D$8)=0,1,0)*ROW($D$3:$D$8)0,ROW($D$3:$D$8)),ROW(A1))),)
From: santosh subudhi santoshkumar.subu...@gmail.com
To: excel-macros excel-macros@googlegroups.com
Sent:
PFA
From: Ali Abbas tigarman...@gmail.com
To: excel-macros@googlegroups.com
Sent: Thursday, August 22, 2013 9:01 PM
Subject: $$Excel-Macros$$ Sum if array for cut dates
Date: 1 2 3 4
Amount: 100 200 300 400
Now formula working.
We can
add below Microsoft Scripting Runtime library from tool--reference
From: Indrajit $nai talk2indra...@gmail.com
To: excel-macros@googlegroups.com
Sent: Monday, August 19, 2013 4:08 AM
Subject: $$Excel-Macros$$ Need urgent help on macro error.
Hi All,
PFA.There are three argument in UDF first lookup value ,
lookarea(range),colnum
From: Rashid Khan prkha...@gmail.com
To: excel-macros@googlegroups.com
Sent: Sunday, August 18, 2013 9:32 PM
Subject: $$Excel-Macros$$ Formula or UDF to do Vlookup for values
pls provide excel or explain more about your query...
From: Pankaj pankajdhamij...@gmail.com
To: excel-macros@googlegroups.com
Sent: Wednesday, August 7, 2013 9:23 AM
Subject: $$Excel-Macros$$ Help needed in Excel
I have 2 columns in excel - A and B.
I
Function eval(str As String)
word = Split(str, +)
For Each wrd In word
add_1 = WorksheetFunction.Sum(WorksheetFunction.Substitute(wrd, ', ))
add2 = add2 + add_1
Next
eval = add2
End Function
From: xlstime xlst...@gmail.com
To:
Use below formula or attached file
=QIF(MONTH(A2)4,1,IF(MONTH(A2)7,2,IF(MONTH(A2)10,3,4)))-YEAR(A2)
From: Krishnaraddi V. Madolli krishnaraddi.mado...@asia.xchanging.com
To: excel-macros@googlegroups.com excel-macros@googlegroups.com
Sent: Wednesday, July 31,
From: ravinder negi ravi_colw...@yahoo.com
To: excel-macros@googlegroups.com excel-macros@googlegroups.com
Sent: Wednesday, July 31, 2013 4:12 PM
Subject: Re: $$Excel-Macros$$ Move Data to Different Sheets based on CFA Names
PFA...
NOTE:- Please remove
you can use
=SUM(INDIRECT(CELL(address,INDIRECT(r7cMATCH(B2,F6:M6,0)+5,FALSE)):CELL(address,INDIRECT(rMATCH(B3,E7:E10,0)+6cMATCH(B2,F6:M6,0)+5,FALSE
From: Waseem Saifi waseemsa...@gmail.com
To: excel-macros excel-macros@googlegroups.com
Sent: Thursday,
Hi
With the help of SUM IF, you can get the result.
For ref. PFA
On Wed, Jul 24, 2013 at 6:20 PM, suresh k brave.sur...@gmail.com wrote:
Hi All,
I have attached my query regarding sum function query
I know this can be solved through pivot table, but I want the result in
formulaes.
Pls
=SUMIF($A$4:$A$54,H4,$B$4:$B$54)
use this formula
From: suresh k brave.sur...@gmail.com
To: Excel group excel-macros@googlegroups.com
Sent: Wednesday, July 24, 2013 6:20 PM
Subject: $$Excel-Macros$$ Sum query
Hi All,
I have attached my query regarding
From: ravinder negi ravi_colw...@yahoo.com
To: excel-macros@googlegroups.com excel-macros@googlegroups.com
Sent: Tuesday, July 23, 2013 12:44 PM
Subject: Re: $$Excel-Macros$$ Copy all the dynamic rows from multiple sheets
and past in the “Consolidated” sheet
From: ravinder negi ravi_colw...@yahoo.com
To: Veerabomma, Naresh naresh.veerabo...@ihealthtechnologies.com;
'excel-macros@googlegroups.com' excel-macros@googlegroups.com
Sent: Tuesday, July 23, 2013 2:58 PM
Subject: Re: $$Excel-Macros$$ Copy all the dynamic
From: ravinder negi ravi_colw...@yahoo.com
To: Veerabomma, Naresh naresh.veerabo...@ihealthtechnologies.com;
'excel-macros@googlegroups.com' excel-macros@googlegroups.com
Sent: Tuesday, July 23, 2013 2:59 PM
Subject: Re: $$Excel-Macros$$ Copy all the dynamic
Hi,
Simply put your code in change event of GB combobox.
From: Abhishek Jain abhishek@gmail.com
To: excel-macros@googlegroups.com
Sent: Monday, July 22, 2013 12:58 PM
Subject: Re: $$Excel-Macros$$ doubt with regard to change event of the combo
What is
Hi, if you want through VBA then you can use below function
Function reversetext(rtext As String)
reversetext = StrReverse(rtext)
End Function
thanks and regards
Ravinder Negi
From: Prafull Jadhav prafulltjad...@gmail.com
To: excel-macros@googlegroups.com
please provide excel file with exmaple
On Fri, 7/12/13, vba v...@vabs.in wrote:
Subject: Re: $$Excel-Macros$$ pulling data from a validation list
To: excel-macros@googlegroups.com excel-macros@googlegroups.com
Date: Friday, July 12, 2013, 1:49 PM
please elaborate your query with attachment and examples
On Fri, 7/12/13, vba v...@vabs.in wrote:
Subject: Re: $$Excel-Macros$$ pulling data from a validation list
To: excel-macros@googlegroups.com excel-macros@googlegroups.com
Date: Friday, July
use this formula
=SUBSTITUTE(IF(A2=C2,CELL(address,B2),),$,)
--- On Sat, 6/29/13, unz...@gmail.com unz...@gmail.com wrote:
From: unz...@gmail.com unz...@gmail.com
Subject: $$Excel-Macros$$ ACCOUNTING: IF CELL IN A RANGE IS EQUAL TO CELL IN
OTHER RANGE THAN INSERT CELL
To:
Hi all,
I have a query , I have made a formula for this but very long so I would like
some small formula to get email id only, pls help thanks in advance
abcd
billga...@microsoft.com xyz
12 xyz john_hay...@microsoft.com 34a bcd
billga...@yahoo.com 1234 abcd
abcd 1234
PM
Function ExtractEmail(Sentence As String) As String
Dim Word
For Each Word In Split(Sentence, )
If InStr(1, Word, @) 0 Then ExtractEmail = Word
Next
End Function
Pada 15/06/2013 15:03, ravinder negi
, ravinder negi menulis:
I want this in excel
formula..this one also very nice can you explain how split
is working.
--- On Sat, 6/15/13, De Premor d...@premor.net
wrote
here u go dear
http://www.w3schools.com/SQl/default.asp
--- On Tue, 6/11/13, Amit Desai (MERU) amit.de...@merucabs.com wrote:
From: Amit Desai (MERU) amit.de...@merucabs.com
Subject: $$Excel-Macros$$ Tutorial on SQL
To: excel-macros@googlegroups.com
Date: Tuesday, June 11, 2013, 3:55 PM
here is the code...
Sub filecopy()sheetname = ActiveWorkbook.ActiveSheet.Range(a16)Path =
ActiveWorkbook.ActiveSheet.Range(a15)
Sheets(Sheet1).Select Sheets(Sheet1).Copy ActiveWorkbook.SaveAs
Path \ book2, FileFormat:=56 ActiveSheet.Name = sheetname
please give more detail with example file so we can understand properly whether
you want this in VBA for or normally in excel sheet.
--- On Wed, 5/1/13, pankaj gmail account pankaji...@gmail.com wrote:
From: pankaj gmail account pankaji...@gmail.com
Subject: $$Excel-Macros$$ Fwd: Mandatory Cell
you can use auto corrrect feature which will replace off into Office Supplies.
Just go to file-option-proofing-autocorrect, type off in replace box and
office Supplies in with box.
--- On Sun, 4/21/13, Mathan mathan4s...@gmail.com wrote:
From: Mathan mathan4s...@gmail.com
Subject: Re:
Hi Chaya,
You can use =EOMONTH(A2,0) formula.
RegardsRavinder Negi
--- On Fri, 3/22/13, Chaya chayamon...@gmail.com wrote:
From: Chaya chayamon...@gmail.com
Subject: $$Excel-Macros$$ Month-Date-Year
To: excel-macros@googlegroups.com
Date: Friday, March 22, 2013, 12:50 PM
Dear Experts,
Hi,
A1
0.6875
B1
=1.5/24
=A1+B1
0.6875
=1.5/24
=A2-B2
Please convert the A1 into numbers
--- On Mon, 3/18/13, JosephJoseph jfara...@gmail.com wrote:
From: JosephJoseph jfara...@gmail.com
Subject: $$Excel-Macros$$ Time calculation help
To:
, 2013, 12:33 PM
On Sat, Mar 9, 2013 at 12:32 PM, Shrinivas Shevde shrinivas...@gmail.com
wrote:
On Sat, Mar 9, 2013 at 11:52 AM, ravinder negi ravi_colw...@yahoo.com wrote:
there is no sheet
--- On Fri, 3/8/13, Jaz jazb...@gmail.com wrote:
From: Jaz jazb...@gmail.com
Subject: $$Excel
there is no sheet
--- On Fri, 3/8/13, Jaz jazb...@gmail.com wrote:
From: Jaz jazb...@gmail.com
Subject: $$Excel-Macros$$ Re: calculating between two cells in two different
sheets.
To: excel-macros@googlegroups.com
Date: Friday, March 8, 2013, 10:20 PM
Hi,
I would appreciate very much if
Hi please find attached with solution.. I am not sure about the amount to
subtract, please advise again. if you want.
--- On Fri, 3/8/13, Jaz jazb...@gmail.com wrote:
From: Jaz jazb...@gmail.com
Subject: $$Excel-Macros$$ calculating between two cells in two different sheets.
To:
Hi,
Use attached file, you just need to change data source of chart and you use if
condition.
Thanks Regards
--- On Fri, 1/25/13, santosh subudhi santoshkumar.subu...@gmail.com wrote:
From: santosh subudhi santoshkumar.subu...@gmail.com
Subject: $$Excel-Macros$$ Dynamic Charts
To: excel-macros
step 1: first Unlock the cells which you dont want to protect. (format
cell)step 2: then click on protect the sheet option and you will find that two
check boxes are checked default, you can unchecked the first check box Select
locked cell.
Please reply if this does not work.
--- On Mon,
you can use conditional formatting for this
--- On Thu, 1/17/13, Manjunath Narayanappa manjunath.narayana...@aon.co.uk
wrote:
From: Manjunath Narayanappa manjunath.narayana...@aon.co.uk
Subject: FW: $$Excel-Macros$$ need formula Highlight
To: 'excel-macros@googlegroups.com'
Hi Prashant,
Please receive the file with solution, please revert back if you want something
else.
Thanks
--- On Mon, 1/14/13, Prashant Pawle ppawle.ex...@gmail.com wrote:
From: Prashant Pawle ppawle.ex...@gmail.com
Subject: $$Excel-Macros$$ formula required
To: excel-macros@googlegroups.com
Hi,
Please check Auto correct option in Excel, you can find ti in
File--Options--Proofing--AutoCorrrect Option
you will get 125 replaced with 255, delete that using delete tab (click).
Please advise if this solve you query.
thanks RegardsRavinder Negi
--- On Tue, 1/15/13, venus
you can use =DMAX(database,field,criteria)
--- On Thu, 1/10/13, Ms-Exl-Learner ms.exl.lear...@gmail.com wrote:
From: Ms-Exl-Learner ms.exl.lear...@gmail.com
Subject: Re: $$Excel-Macros$$ How to get max number from a database ?
To: excel-macros@googlegroups.com
Date: Thursday, January 10, 2013,
here is the solution
On Thu, 1/3/13, Awal malaw...@gmail.com wrFrom: Awal malaw...@gmail.com
Subject: $$Excel-Macros$$ Lookup and Replace
To: excel-macros@googlegroups.com
Date: Thursday, January 3, 2013, 8:47 AM
Hello,I would like to wish y'all a Happy New year...
I am still learning VBA and I
Here is the anwser, I have attached a file with solution. Please reply if you
want this?
--- On Fri, 1/4/13, harshad shukla er.harshad.shu...@gmail.com wrote:
From: harshad shukla er.harshad.shu...@gmail.com
Subject: $$Excel-Macros$$ Vlookup for two same values
To: excel-macros@googlegroups.com
Hi,
there is Datedif() function can be used for calculating age
=datedif(DOB,today(),Y) for years=datedif(DOB,Today(),YM ) for
months=datedif(DOB,today(), MD) for days
--- On Fri, 12/7/12, Rakesh Kumar Sharma rakeshks@gmail.com wrote:
From: Rakesh Kumar Sharma rakeshks@gmail.com
Hi Nik,
Please try this attached sheet and advise whether you exactly want this or else.
--- On Fri, 12/7/12, nm nms8...@gmail.com wrote:
From: nm nms8...@gmail.com
Subject: $$Excel-Macros$$ Re: Pl Solve my date query
To: excel-macros@googlegroups.com
Date: Friday, December 7, 2012, 10:55 PM
HERE IS THE SOLUTION
--- On Thu, 12/6/12, C.G.Kumar kumar.bemlmum...@gmail.com wrote:
From: C.G.Kumar kumar.bemlmum...@gmail.com
Subject: $$Excel-Macros$$ Extracting Text from Cell
To: excel-macros@googlegroups.com
Date: Thursday, December 6, 2012, 12:59 PM
Hi ,
I need to extract a relevant
hi Ahmed,If you want this through conditional formatting then you can paste
this =INDIRECT(gROW())=TODAY()+14 in conditional formatting formula thanks
--- On Thu, 12/6/12, Ahmed Ab abab19800...@gmail.com wrote:
From: Ahmed Ab abab19800...@gmail.com
Subject: $$Excel-Macros$$ Lease date alarm
Hi,
=WEEKNUM(Future date,2)-WEEKNUM(today(),2)Weeknum gives number of week
you can change option (2) in formula as per your requirement, formula will
prompt you when you enter formula.
If this works otherwise tell us more detail
--- On Thu, 12/6/12, t vinay vinaytu...@gmail.com wrote:
From: t
You can use trim function of excel like =trim(cell reference), and it will
remove space from the cell value and then use function remove duplicate which
is available in data-remove Duplicates.
--- On Thu, 11/22/12, Manjunath Narayanappa manjunath.narayana...@aon.co.uk
wrote:
From: Manjunath
solved your query now
--- On Mon, 11/19/12, Raj Mahapatra rajexcelma...@gmail.com wrote:
From: Raj Mahapatra rajexcelma...@gmail.com
Subject: $$Excel-Macros$$ Event - Worksheet Change
To: excel-macros@googlegroups.com
Date: Monday, November 19, 2012, 11:15 PM
Dear Friends,
kindly help out on
Hi Everyone,,
I am trying to use chrome instead using Internet explorer.
Here is the code I have (the code the works for Internet Explorer and
the modified code for Chrome):
Dim IEapp As Object
Dim CHromeapp As Object
'Open Internet Explorer and Display the Route
Set IEapp =
Here is the solution.
--- On Sun, 8/26/12, Kuldeep Singh naukrikuld...@gmail.com wrote:
From: Kuldeep Singh naukrikuld...@gmail.com
Subject: $$Excel-Macros$$ Only MID Function
To: excel-macros@googlegroups.com
Date: Sunday, August 26, 2012, 1:07 PM
Hi Experts,
Extract 10 from the
201 - 248 of 248 matches
Mail list logo