Hi,
if you dont want to use Function then Replace the Space.
On Fri, Sep 30, 2011 at 6:42 PM, dguillett1 wrote:
> =SUBSTITUTE(F9," ","")
>
> *From:* big smile
> *Sent:* Friday, September 30, 2011 6:54 AM
> *To:* EXCEL MACRO GROUP
> *Subject:* $$Excel-Macros$$ TRIM FUNCTION
>
>
>
> Respcte
Please VIsit this Page..
http://www.cpearson.com/excel/Events.aspx
On Sat, Oct 1, 2011 at 12:09 PM, XLS S wrote:
> Hey Rajan Babu,
>
> which page?
>
>
>
>
>
> On Sat, Oct 1, 2011 at 11:52 AM, rajan verma wrote:
>
>> HI,
>> Please visit this Page to know more about Worksheet Events..
>>
>> Regar
Hey Rajan Babu,
which page?
On Sat, Oct 1, 2011 at 11:52 AM, rajan verma wrote:
> HI,
> Please visit this Page to know more about Worksheet Events..
>
> Regards
> Rajan
>
> On Sat, Oct 1, 2011 at 10:53 AM, Mr excel wrote:
>
>> HI group,
>>
>> This is a Great & amazing group in learning exce
Hi, Anil
I think u want to keep in ur file that data also which comes 2 or 3 time but
after removing 2nd or 3rd data which is repeating in ur file if i'm ri8.
Then u sud chose A to z in example data then simply write in 2nd column
=A2=A3 then drag them n it will return True of False.
False value wu
Select cell or column then right click format cell ...then in
number tab go to date and select date format then ok
On Fri, Sep 30, 2011 at 11:03 AM, Sanjib Chatterjee <
chatterjee.kolk...@gmail.com> wrote:
> Dear
>
> I like to put the date format in Excel as "dd/mm/",
HI,
Please visit this Page to know more about Worksheet Events..
Regards
Rajan
On Sat, Oct 1, 2011 at 10:53 AM, Mr excel wrote:
> HI group,
>
> This is a Great & amazing group in learning excel vba..
>
>
> *Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
> Boolean)*
>
HI group,
This is a Great & amazing group in learning excel vba..
*Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)*
*Dim st As String*
*Dim sh As Worksheet*
*Set sh = Sheets("Sheet2")*
*st = Target.Address*
*sh.Activate*
*sh.Range(st).Activate*
*ActiveCe
USE
=INDEX(INDIRECT(TEXT(D1,"MMMYY")&"!$A$2:$A$65536"),SMALL(IF(ISNUMBER(SEARCH($C$3,INDIRECT(TEXT(D1,"MMMYY")&"!$B$2:$B$65536"))),ROW(INDIRECT(TEXT(D1,"MMMYY")&"!$B$2:$B$65536"))-MIN(ROW(INDIRECT(TEXT(D1,"MMMYY")&"!$B$2:$B$65536")))+1,""),ROW(A1)))
in B8
Regards
Sam Mathai Chacko (GL)
On Sat,
Hi Jatin
i recommend,
Krishnakumar KC
http://www.freelancer.co.nz/users/513618.html
http://www.linkedin.com/profile/view?id=14325892&authType=name&authToken=wPDQ&locale=en_US&pvs=pp&trk=ppro_viewmore
if you are looking someone from India, even some expert from this group can
help you.
HTH
Ma
That's what I do DAILY.
(currently maintining over 80,000 lines of VBA code)
If it can be done remotely, I'd be glad to help.
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times yo
=SUBSTITUTE(F9," ","")
From: big smile
Sent: Friday, September 30, 2011 6:54 AM
To: EXCEL MACRO GROUP
Subject: $$Excel-Macros$$ TRIM FUNCTION
Respcted Sir & group members.
I have put some numbers in one cell -- for ex. 2 5 9 8 9 5 9 9 v v v ---
now i want the same cell to trimed as
I can do it from Texas at $75 hourly
-Original Message-
From: Jattin Agarwal
Sent: Friday, September 30, 2011 3:35 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Excel expert required .
Dear Excel experts
I would request that if any VBA expert can help in automati
Just modify my code to this. You could also sort by site ascending with
descending date>advance filter to unique>copy but this is easier.
Option Explicit
Sub CopyLastDatetoothersheeetSAS()
'run from source sheet
Dim i As Long
Dim dlr As Long
On Error Resume Next
For i = 3 To Cells(Rows.Count, 1).E
Respcted Sir & group members.
I have put some numbers in one cell -- for ex. 2 5 9 8 9 5 9 9 v v v ---
now i want the same cell to trimed as look as --- 25989599vvv [ i want to
remove the space in between]
is it possible with excel function.
Thanks
--
---
SIMPLE WAY
SELECT THAT CELLS
GO TO FORMAT CELLS
THEN
CLICK ON NUMBER--CUSTOM---
TYPE THE DD-MMM-YY IN THE TYPE FIELD
On Fri, Sep 30, 2011 at 2:28 PM, Amresh Maurya wrote:
> Hi PFA Solution.
>
> On Fri, Sep 30, 2011 at 12:49 AM, Sanjib Chatterjee <
> chatterjee.kolk...@gmail.com>
You can select the date format as dd-mmm- format cell option.
On 30 Sep 2011 13:19, "Sanjib Chatterjee"
wrote:
> Dear All
>
> Please go through the mail and help me.
>
> Ragards,
>
> sanjib
>
> -- Forwarded message --
> From: Sanjib Chatterjee
> Date: Fri, Sep 30, 2011 at 12:1
Dear Excel experts
I would request that if any VBA expert can help in automating some reports .
fees can be discussed over meeting . we are based in Mumbai
Regards
Jatin Agarwal
09322335208
--
--
Some import
I don't see all of my original code here but
also give me meaning of "r = Cells(Rows.Count, "J").End(xlUp).Row "
Excel is looking in col J for the bottom most cell, ie 22
Range("J2:J" & r) in above code.
Excel is using range("j2:j22")
makes little difference what r is called. could be lastrow or x
If ??? I understand, simply CUSTOM format the cell as "dd-mm-
From: Sanjib Chatterjee
Sent: Friday, September 30, 2011 12:33 AM
To: excel-macros
Subject: $$Excel-Macros$$ date format in Excel
Dear
I like to put the date format in Excel as "dd/mm/", and like to get the
output as "dd-mm
I seem to be missing something...
PROVIDED that your Windows Date format is dd/mm/
when you enter a string in this format, Excel recognizes it as a date.
As such, you can:
Right-click the cell(s)
select Format Cells
on the Number tab, select "Date".
There SHOULD be a format at the bottom calle
Thank you all very much for taking your time to teach others. I really
appreciate your help.
John
On Thu, Sep 29, 2011 at 4:06 PM, dguillett1 wrote:
> =(D2-C2)*24
>
> *From:* John A. Smith
> *Sent:* Thursday, September 29, 2011 2:55 PM
> *To:* excel-macros@googlegroups.com
> *Subject:
Hi Anil,
Please find the attached sheet. here i am using countif function with if
function . and later on autofilter to draw the value of duplicate value. and
then then later on you can copy that A-Column data.
On Wed, Sep 28, 2011 at 12:46 PM, anil kumar wrote:
> Hi everybody,
>
> I have a file
Dear Sanjib,
Please use below code as per your requirement.
*Function Date_Format(d As Date)
Date_Format = Format(d, "dd-mmm-")
End Function
*
On Fri, Sep 30, 2011 at 1:19 PM, Sanjib Chatterjee <
chatterjee.kolk...@gmail.com> wrote:
> Dear All
>
> Please go through the mail and help me.
>
Hello Dear,
I think It's work use this key Shift+Ctrl+3.
--
--
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 @
Hello suman,
thanks for reply, it works and fulfill my needs. but not that way I want. If
you have better
Idia plz send me.
Thanks & Regards
Anil
>>
>
--
--
Some important links for excel users:
1. Follow us on
Dear dguillett and noorani,
I don't want to remove double I want show that and copy in other sheet. for
removing I use Alt +AM
> Thanks & Regards
>
Anil
--
--
Some important links for excel users:
1. Follow us
Dear All
Please go through the mail and help me.
Ragards,
sanjib
-- Forwarded message --
From: Sanjib Chatterjee
Date: Fri, Sep 30, 2011 at 12:15 PM
Subject: date format help
To: excel-macros
Dear All members,
please help me regarding date format in Excel.
I want to put th
THANKS NOORAIN
--
--
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 @ http://www.linkedin.com/groups?gid=1871310
use this formula : =TEXT(C1,"dd-mmm-")
On Thu, Sep 29, 2011 at 11:45 PM, Sanjib Chatterjee <
chatterjee.kolk...@gmail.com> wrote:
> Dear All members,
>
> please help me regarding date format in Excel.
>
> I want to put the value in excel as "dd/mm/", but like to get the value
> as "dd-mm
29 matches
Mail list logo