please add me 8308800600
On Mon, Aug 8, 2016 at 9:43 PM, Rajeev Ranjan <06raj...@gmail.com> wrote:
> please add the my number 9811503853
>
> On Friday, 5 August 2016 14:16:39 UTC+5:30, Prabhu Pinky wrote:
>>
>> Creating WhatsApp group for VBA macro... Pls msg me your contact, if you
>> wants to j
This will work
=IFERROR(IFERROR(MID(A2,FIND("MOC",A2,8),7),UPPER(MID(A2,FIND("moc",A2,7),8))),UPPER(MID(A2,FIND("Moc",A2,7),8)))
However may of the cases it is written like MOC 9 or MOC - 08 hence some
garbage is appearing. you can remove by text to coloumn command.
Prashant
On Wed, May 20,
pls check
On Wed, May 20, 2015 at 2:58 PM, Neeraj wrote:
> Dear Experts,
>
>
>
> Kindly find the sheet and do the needful formula
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.
from GEOFORCE,.Hence i have given
two pivots and minitab box plot analysis.
Hope this will solve your query.
Prashant Pednekar.
On Wed, Apr 15, 2015 at 10:50 PM, kumar wrote:
> Hi,
>
> Any one looked at it?
>
> On Wednesday, April 15, 2015 at 3:13:43 PM UTC+1, kumar wrote:
>&
Dear Mandeep,
This was wonderful file. I used it for one of my project.
However required one improvement. Tried to see the code, but it is lock
hence. need your guidance.
- I need to select entire data in sheet. currently it is not taking data
after black rows.
- The color and formating becomes
Dear All
Happy new Year to you all.
Lets keep journey of collective knowledge addition.
Prashant
On Wed, Dec 31, 2014 at 7:54 PM, Vaibhav Joshi wrote:
> Joyous January –Fabulous February
>
> Magical March –Adorable April
>
> Magnificent May –Jolly June
>
> Jubilant July –Awesome August
>
> Sc
Good morning all.
Sorry ! I did not used *Please help.*
in my earlier mail.
Request you to help me.
Thanks
Prashant.
-- Forwarded message --
From: Prashant Pednekar
Date: Mon, Oct 14, 2013 at 3:21 PM
Subject: $$Excel-Macros$$ MS Excel 2003 to 2010
To: excel-macros
Dear friends
We are migrating from MS Excel 2003 to Excel 2010
Dose any one of you has Menu and commond by command comparion in both
version.s
i.e. 2003 2010
Data > Validation ???
Else is anyone has related material.
Regards
Prashant
--
Are you =EXP(E
achment . see if it helps
>>
>>
>>
>>
>> On Tue, Aug 20, 2013 at 9:46 AM, Prashant Pednekar wrote:
>>
>>> Hi Chaya, Prabhu,
>>>
>>> Done with a simple macro.
>>>
>>> Use Control + Shift + A at particular cell wher
Dear Dave, and other friends.
I am using belwo code for locking rows. It is not working. Can you let me
know where i am going wrong. my date value is in first column.
Private Sub Worksheet_Activate()
ActiveSheet.Unprotect
Rows("5:1200").Locked = True
With Range("A5:A1500")
Set
Hi all
I want to convert on Text in each cell to rows ?
In each Cell has 50 + numbers one below one.
e.g.
09:51:18
09:51:31
09:52:04
There are five such columns.
Can any one help me to convert to rows?
Regards.
prashant
--
-
ActiveSheet
For Each MWS In ActiveWindow.SelectedSheets
If Not MWS Is AWS Then
FAR = AWS.UsedRange.Cells(AWS.UsedRange.Cells.Count).Row + 1
LR = MWS.UsedRange.Cells(MWS.UsedRange.Cells.Count).Row
MWS.Range(MWS.Rows(NHR + 1), MWS.Rows(LR)).Copy AWS.Rows(FAR)
End If
Next MWS
End Sub
On Sa
Dear Experts.
I have a eight workbooks of telephone billing statement which are
converted from pdf file to excel. Each workbook contain 135
worksheets. Each sheet contain the data like Date/Time, Number,
Destination, Duration, Call charges. in two table. The useful data of
each worksheet is from
On Fri, Mar 26, 2010 at 3:24 PM, Prashant Pednekar
wrote:
> On Thu, Mar 25, 2010 at 2:32 PM, Prashant Pednekar
> wrote:
>> Dear All,
>>
>> I am having presentation (PPT) of 3 slide. Each slide contains one excel
>> sheet.
>> The last slide will have sum of val
On Thu, Mar 25, 2010 at 2:32 PM, Prashant Pednekar
wrote:
> Dear All,
>
> I am having presentation (PPT) of 3 slide. Each slide contains one excel
> sheet.
> The last slide will have sum of values of Sheet 1 to 2 (i.e. Slide 1 &2 ).
>
> The original file is having some
HI
Dose any one have pop up calender in excel cell.
Regards,
Prashant.
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free a
>
>
> On Tue, Sep 8, 2009 at 11:56 AM, Prashant Pednekar
> wrote:
>
>> Dear all
>>
>> Thanks for the knowlege enrichment of excel by you all...
>>
>> I am facing problem with Filter. While filtering data I am not able to see
>> the data after speci
On Tue, Apr 14, 2009 at 12:24 PM, Suryaprasad.bv
wrote:
> Prashant,
>
> Can you post me a sample file so that i can help you out
>
> Cheers
> Surya
>
>
>
> On Tue, Apr 14, 2009 at 12:16 PM, Prashant Pednekar > wrote:
>
>> Hi All
>>
>> here
Hi All
here my doubt is
The Validation is not having constraint,
i.e. afte entering one product and specification, if i am again changing the
product.the specifition remain same?
Eg.
Product 2 Specification 6
how can we resolve this ?
Regards.
Prashant.
On Wed, Apr 8, 2009 at 11:33 PM, Harm
19 matches
Mail list logo
