hi,
shared only example format data like that
On Saturday, November 21, 2015 at 9:30:37 PM UTC+5:30, pramodb35 wrote:
>
> Akash.
> Kinldy Share Excel File
>
> On Sat, Nov 21, 2015 at 9:01 PM, Akash Singh > wrote:
> >> Hi,
> >
> > Can anyone guide who write a code in VBA in excel to find the
can we use vlookup or match,index function over here to sort column A like
column B, if possible can anyone do it for me, I tried on column E:I but
failed
Thanks in advance
NOTE:
Priority is the formula if not possible then you may use macro
--
*Izhar Ul Haq*
Cell# 009203069072597
--
Are y
See if this works
On Sun, Nov 22, 2015 at 4:55 PM, Izhar wrote:
> can we use vlookup or match,index function over here to sort column A like
> column B, if possible can anyone do it for me, I tried on column E:I but
> failed
> Thanks in advance
> NOTE:
> Priority is the formula if not possible t
> Hi Sam
> Thank you very much for your quick response
> Later i researched on the particular question and i concluded a result
> which may be seen in the attach workbook...but thank you very much for your
> quick response
>
> --
> *Izhar Ul Haq*
>
>
>
> Cell# 009203069072597
>
--
Are
PSA.
Can someone please create a macro for me that would eliminate this
frustrating problem that I have with date converstion.
DATE1 = Source. It always gets imported in as 2 different date formats.
DATE2 is what I want returned in a MMDD format. I have manually change
it in this exampl
CTRL+D
CTRL + R
to copy the formula below and to the right.
Regards,
Mandeep baluja
On Monday, November 23, 2015 at 9:32:12 AM UTC+5:30, GENIUS wrote:
>
> HI EVERYONE
> can we use any keyboard key for double clicking the plus sign for copying
> the formula below in the range or is
Try this and let me know !!
Sub Dates_Test()
Dim i As Long
For i = 1 To Cells(Rows.Count, 1).End(xlUp).Row
Cells(i, 3).Value = Cells(i, 1).Value
Cells(i, 3).Value = Format(Cells(i, 1).Value, "mmdd")
Cells(i, 3).NumberFormat = "General"
Next
End Sub
Regards,
Mandeep baluja
--
Are you
Any update >??
On Thursday, November 19, 2015 at 1:34:51 PM UTC+5:30, Mandeep Baluja wrote:
>
> Hi paul,
>
> But while correcting it this is giving error. please find the attached
> file. it works on small amount of data easily but while using the data in
> sheet it gives error. I admit by mist