Hi Shrinivas,
A sample workbook with the parameters and the expected output will be
helpful for giving exact solution.
<><><><><><><>
*Ms-Exl-Learner*
<><><><><><><>
On 06-10-2012 9:01 AM, Shrinivas Shevde wrote:
Dear Excel Learner
First of all sorry for delay.
Thanks for the reply and thi
Congratulations Mr. Rajan Ji
On Wed, Oct 3, 2012 at 5:13 PM, NOORAIN ANSARI wrote:
> I can say only...
>
> यूँ ही बरकरार रखो भाई अपने Expertise के छाप को.
> और अपनी तरक्की से छोटा कर दो आसमा के माप को.
> हम दोस्तों की दुआए,सदा संग बन के रहे साए...
> मेरे ओर से लाख-लाख बधाई, राजन ब
that's great but it's not working !!!
On Thu, Oct 4, 2012 at 4:13 PM, Rajan_Verma wrote:
> How many Sheets this workbook have ?
> do you remember all worksheet name?
>
> you can write formual to recover the contain only but not formating
>
> ='fullpathofworkbook[WorksheetName]'!A1
>
> Drag this f
Dear Rajan,
congrats...:)
On Fri, Oct 5, 2012 at 5:46 PM, prkhan56 wrote:
> Congrats!
>
> On Wednesday, October 3, 2012 3:43:49 PM UTC+4, NOORAIN ANSARI wrote:
>
>> I can say only...
>>
>> यूँ ही बरकरार रखो भाई अपने Expertise के छाप को.
>> और अपनी तरक
Dear Excel Learner
First of all sorry for delay.
Thanks for the reply and this is exactly I want.
Can u help me little more
In a master sheet there is sample Name I want to put 2 or 3 (may be
more)more parameter like ,Date, Created by ,Cost etc.and all this should
get transfer to respective sheet.
Hello. I work in the Audio Book field and this is exactly what I need.
One small question: Is there a way to mod this code to only include wave
files that have been created or modified within a date (and time if
possible) range inside the directory you choose. We would use this to pay
our n
Dear Karthik,
In 2003 Version you can also use
*=SUMPRODUCT(--(B4:B14="Karthik")*($C$4:$C$14="Collected"))*
On Fri, Oct 5, 2012 at 8:23 PM, karthik N wrote:
> Hi Friends
>
> Need help
>
> How many cases are collected in karthik, pls send me a any formula
>
> *name* *status* karthik collected
=COUNTIFS(A2:A12,"Karthik",B2:B12,"Collected")
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of karthik N
Sent: 05 October 2012 8:23
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Ne
First. A worksheet event macro must be in the SHEET module (or ThisWorkbook
for all shts). Try this simpler approach using all vba .
'===
option explicit
Private Sub Worksheet_Change(ByVal Target As Range)
Dim mf As Range
If Target.Column <> 1 Then Exit Sub
'If Target.Address <> Range("c1"
Visit here:
http://excelpoweruser.wordpress.com/2011/07/30/remove-special-character-from
-a-string/
Public Function SheetName(Shname As String) As String Dim Cod As Integer Dim
ShN As String
For i = 1 To Len(Shname)
Cod = Asc(Mid(Shname, i, 1))
Hi,
I am using Excel 2003 and have drop down cells with validations. I want to
restrict the copy-paste functionality for these drop-down cells. i have
written a macro for that purpose but it disables the copy-paste for entire
worksheet.
Appreciate if you could help me with a macro that checks
Congrats!
On Wednesday, October 3, 2012 3:43:49 PM UTC+4, NOORAIN ANSARI wrote:
>
> I can say only...
>
> यूँ ही बरकरार रखो भाई अपने Expertise के छाप को.
> और अपनी तरक्की से छोटा कर दो आसमा के माप को.
> हम दोस्तों की दुआए,सदा संग बन के रहे साए...
> मेरे ओर से लाख-लाख बधाई, राजन बा
Thanks to all
On Fri, Oct 5, 2012 at 1:32 PM, Ms-Exl-Learner .
wrote:
> Hi Manoj,
>
> Go through the below for Non Array Formula Solution.
>
> *Try this for getting the Maximum Date based on Name*
>
> =SUMPRODUCT(MAX($A$2:$A$47*($C$2:$C$47=$E2)))
>
> *Try this for getting the ID based on Max
Hi
In cell what input = removeSpecial(Cell) like this?
On 10/5/12, jeet singh wrote:
> Function removeSpecial(sInput As String) As String
> Dim sSpecialChars As String
> Dim i As Long
> sSpecialChars = "\/:*?"" {}[](),!`~\:;'._-=+&^%$<>|"
> For i = 1 To Len(sSpecialChars)
>
Hi Manoj,
Go through the below for Non Array Formula Solution.
*Try this for getting the Maximum Date based on Name*
=SUMPRODUCT(MAX($A$2:$A$47*($C$2:$C$47=$E2)))
*Try this for getting the ID based on Maximum Date of a name*
=SUMPRODUCT(($C$2:$C$47=$E2)*($A$2:$A$47=SUMPRODUCT(MAX($A$2:$A$47*($
Function removeSpecial(sInput As String) As String
Dim sSpecialChars As String
Dim i As Long
sSpecialChars = "\/:*?"" {}[](),!`~\:;'._-=+&^%$<>|"
For i = 1 To Len(sSpecialChars)
sInput = Replace$(sInput, Mid$(sSpecialChars, i, 1), "")
Next
removeSpecial = sInput
End
16 matches
Mail list logo
