On Aug 15, 9:48 pm, Dhananjay Pinjan
wrote:
> Dear All,
>
> Can anyone provide me the solution as per the requirement
in the
> attachment.
>
> Thanks in advance & Regards,
>
> Dhananjay Pinjan
> (Mob. No. 9922255533)
Hi Dhananjay,
No need for any special formatting!
Please refer to attac
how do u do it. Thx
On 8/16/09, Dilip Pandey wrote:
> Dear Mahesh,
>
> Please find the unprotected file. I have removed Worksheet passwords
> + VBA Password. Thanks
>
> --
> DILIP KUMAR PANDEY
>MBA-HR,B COM(Hons.),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
>
thanx ...definatly i will do this.
On Sun, Aug 16, 2009 at 11:14 PM, Dilip Pandey wrote:
>
> Hi Umesh,
>
> You can discuss the same, no problem. But I would suggest if you can
> go ahead and post the same to the group, marking me in the CC field.
> There are many great minds who would also be i
hi
Friends...can you help me for maintain daytoday mis.. we face many problem
to maintain thousand of data in excel..
we discuss on that..
--
--
Warm Regards,
You mesh
--~--~-~--~~~---~--~~
---
its simple. use is error function.
Pl. see the attachment.
tx.,
On Sat, Aug 15, 2009 at 5:21 PM, Dhananjay Pinjan wrote:
>
> Dear All,
>
> Please ignore the previous mail sent by me because i forgot to attach the
> excel file.
>
> Can anyone provide me the solution as per the requirement in the
Dear All Excel Gurus,
Kindly help on the problem in the attached sheet.
I need formula for ranking , punches as per day/time
Regards,
Prashant
--~--~-~--~~~---~--~~
--
Some important
Dear Manish,
I tried the same, but my objective is not to allow users to use filter of
the cell A1, they may use any of the visible cell except A1
Please advise further
Regards,
Prashant
|
Manish Purohit to excel-macros
show details 8:25 AM (10 hours ago)
Reply
[image: Follow up message]
Pra
Hi Dhananjay,
Solution is attached as per your requirements. Thanks,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On 8/15/09, Dhananjay Pinjan wrote:
> Dear All,
>
> Please ignore the previous mail sent b
Hi Dhananjay,
Same to you and to all of our great frnds...Happy Independence Day.
(Belated)...!!
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On 8/15/09, Dhananjay Pinjan wrote:
> Wishing you all a very h
Hi Umesh,
You can discuss the same, no problem. But I would suggest if you can
go ahead and post the same to the group, marking me in the CC field.
There are many great minds who would also be intersted to help you
out.
Group Mail Id:- excel-macros@googlegroups.com
Thanks,
Dilip Kumar Pandey
Hi Prashant,
You can refer to the attached file.
In order to achieve the task, you need to first unlock all the cells
(Select whole tab, and uncheck the "Locked" checkbox under Protection
tab in cell format option). Now select the highlighted tab, and check
that box. Finally you need to protect t
Dear Shah,
Use of " & " explained below -:>
1.) To seperate a references / texts in the formula result
2.) To include some text in - between the references & results.
Note:- Between formulas / References you can use &" "& to include any
text or space. e.g. <<>>>
Let me know if you still fac
Dear all,
Any idea how to make .tsv file.
Either by office or any other tool.
I want to make a tabular format with file extension .tsv
Any help
Rgds,
A Hakim
--~--~-~--~~~---~--~~
--
Ruchi,
Do onething while using concatenate function use space in between A1, A2 and
A3
the formula would be like* =CONCATENATE(A1," ",A2," ",A3)*
**
Nilesh
09325096881
On 8/11/09, Dave Bonallack wrote:
> Hi Ruchi,
> I think you need the following formula:
> =A1&CHAR(13)&A2&CHAR(13)&A3
> The
We can do the subtotal in one cell only.
Find the attached excel file for the solutions
Manish Purohit
Imagination is more important than knowledge. Knowledge is limited.
Imagination encircles the world.
_
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
Dear Dhananjay,
Please change"-" to 0 & do formatting _(* #,##0.00_);_(* (#,##0.00);_
(* "-"??_);_(@_)
Regards,
Prashant
On Aug 16, 8:54 am, Dave Bonallack wrote:
> Hi,
> Have a look at the attached.
> I've used SUMIF. But I don't know why you don't want to use SUM. It works
> just as well,
Hi Abdul,
I think we don't need to use the below code due to which it changes those
cells since a non-numeric found and as soon as a non-numeric cell encounters
it exit the macro due the following lines of code.
Else
Exit Sub
End If
Bakul,
Try the below code:
Sub Inse
Dear Ayush,
It is really helpful & nice one..
But I am not able to select next month.. when i have selected calendar
it is coming August-2009,but i need calender for September which i am
not able to drag down in same calendar.
Regards,
Darshil Shah.
On Fri, Aug 7, 2009 at 7:49 AM, Ayushj wrote
Hi,
I have to replace ! in the workbook, you can use what ever you want in
place of !. But the find and replace did not work for me. Then i use a
alternate method for this. See the steps below.
1). find ! in cells using Edit->find (just want to know the columns which
has !). After this I
Hi Dhananjay,
Find the attached excel file with the solution.
You can use N( ) to treat any string as 0.
Manish Purohit
Imagination is more important than knowledge. Knowledge is limited.
Imagination encircles the world.
_
From: excel-macros@googlegroups.com [mailto:excel-
It is really nice,
but for undesrstanding can you please guide that what is the use of " & "?
Where we need to put this?
Regards,
Darshil Shah.
On Tue, Aug 11, 2009 at 4:42 PM, soura...@gmail.com wrote:
>
> Hi Ruchi
>
> Here is formula for your reference
>
> =A1&" "&A2&" "&A3
>
>
>
> On Aug 11
Dear Dhananjay,
YOu can do a simple change in the formatting of the cells.
Select the table, use custom format and choose General.
Paste the following formatting.
General;General;_-* "-"??_-;_...@_-
Click oK.
Now change all - with 0 . you will notice all 0 values will be represented
as -.
Hop
22 matches
Mail list logo
