Sandeep
In fact you can format in any way you want.
try this :
Option Explicit
Dim i
Sub Myformat()
For i = 1 To 30
Cells(i, 3).Value = Format(Cells(i, 1).Value, " mm dd")
Next i
End Sub
Let me know.
Tomaz
On Jun 24, 10:00 pm, "Sandeep" wrote:
> Hi Everyone,
>
> Please help me in chang
Thanks you Dilip, I got it.
- Original Message -
From: Dilip Pandey
To: excel-macros@googlegroups.com
Sent: Thursday, June 25, 2009 7:09 PM
Subject: $$Excel-Macros$$ Re: Date Problem
Hi Sandeep,
Query solved and attached with this email. Thanks.
Note:- try to get the
Use the formula in cloumn 3
=IF(A5<>A6,B5,""). Fill it in each row.
Then filter column 3 for non-blanks.
NB: It will be best if you format the data as a table (or excel list).
CA_logo_icai Small1
Anil Kumar Agarwala
From: excel-macros@googlegroups.com [mailto:excel-mac...@
Hi,
Could you pls confirm you need the total amount or the amount which is
highlighted in your data sheet?
Regards
Naveen Kumar M N
Email :naveenkumarmn...@yahoo.com
Best Wishes-Karunaada Kuvara
--- On Thu, 1/29/09, Chaudhry Zahid Ali wrote:
From: Chaudhry Zahid Ali
Subject: $
Hi!
Pls chk Attached file
Thanks & regards
Harish Upadhyay
9773284902
On 1/29/09, Chaudhry Zahid Ali wrote:
>
> Hi,
>
> I have got a little problem that I need to solve I have a sheet with
> multiple transactions. The columns include Date and amounts. There are
> multiple amounts against a
Attached sheet contains the solution, let me know if you are looking for
something else
Thanks,
Nidhesh
On Thu, 29 Jan 2009 Chaudhry Zahid Ali wrote :
>Hi,
>
>I have got a little problem that I need to solve I have a sheet with
>multiple transactions. The columns include Date and amo
Hi,
Check the attached file let me know if its fine
Regards
Sathish Jalendran
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Chaudhry Zahid Ali
Sent: 29 January 2009 09:17 pm
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Date Prob
