Hi Expert,
PLease assist me how can attach sample excel file to the new post.
There is no link avaliable which can upload my sample file for the
clear understanding of my problem.
Warm Regards,
Bhushan Sabbani.
--
Your suggetion is much appriciateable
On Wed, Feb 2, 2011 at 9:30 AM, Puttu * puttu...@gmail.com wrote:
Hi Experts,
Required your advise on VBA training, I am looking for VBA best training in
Basavanagude or Gandhibazr Bangalore. Could any body have any good training
institute please
Hi All,
How can we extract month in text. Can someone define some formula for this.
Attached my question in clear.
Regards,
Solomon
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips
Thanks for valuable post.
Is it possible to hide the complete row based on lookup value??
For example in your solution, if i lookup value x than i want to hide
row 14 because the lookup result is �0�/Blank. And if i change the
value and look the value �y� i want to hide both row 13 and 14.
pls
type this in cell f5
=TEXT(E5,)
On Wed, Feb 2, 2011 at 1:09 PM, solomon raju faithful1...@gmail.com wrote:
Hi All,
How can we extract month in text. Can someone define some formula for
this.
Attached my question in clear.
Regards,
Solomon
--
Please find the attached
Regards,
Manoj Kumar
On Wed, Feb 2, 2011 at 1:09 PM, solomon raju faithful1...@gmail.com wrote:
Hi All,
How can we extract month in text. Can someone define some formula for
this.
Attached my question in clear.
Regards,
Solomon
--
Simple way is create separate table where you will get months than do
VLOOKUP... :)
Like 1 = April, 2 = May, 3 = Juneetc.
Regards,Anil Bhange
IP Phone - 512320 | Mobile - 90290 32123
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of solomon raju
just
=TEXT(E5,)
On Wed, Feb 2, 2011 at 2:39 PM, solomon raju faithful1...@gmail.com wrote:
Hi All,
How can we extract month in text. Can someone define some formula for
this.
Attached my question in clear.
Regards,
Solomon
--
In cell F5 try the following formula:
=CHOOSE(MONTH(E5),January,February,March,April,May,
June,July,August,September,October,November,December)
On Wed, Feb 2, 2011 at 2:39 AM, solomon raju faithful1...@gmail.com wrote:
Hi All,
How can we extract month in text. Can someone define some
Thank You Ashish.
On Wed, Feb 2, 2011 at 2:53 PM, ashish koul koul.ash...@gmail.com wrote:
type this in cell f5
=TEXT(E5,)
On Wed, Feb 2, 2011 at 1:09 PM, solomon raju faithful1...@gmail.comwrote:
Hi All,
How can we extract month in text. Can someone define some formula for
Hi ,
find here with your attached Sheet.. i used Choose() Function to get desired
result.
Rajan
On Wed, Feb 2, 2011 at 1:09 PM, solomon raju faithful1...@gmail.com wrote:
Hi All,
How can we extract month in text. Can someone define some formula for
this.
Attached my question in clear.
Hi,
I am not finding any link from where i can upload my sample file.
Regards.
Bhushan
On Feb 2, 2:11 pm, Manish pansari.man...@gmail.com wrote:
Thanks for valuable post.
Is it possible to hide the complete row based on lookup value??
For example in your solution, if i lookup value x than i
Hi ashish sir,
thanks for your time and solution,but in my excel database column no
is diff ,can u pls provide me the same macro code based on below
column no as per my database
header - column no.
Name - 4
process doj -63
process - 61
ref type -87
process doj 1 -92
process1 -90
ref type 1-116
Any body have any suggetion
On Wed, Feb 2, 2011 at 9:30 AM, Puttu * puttu...@gmail.com wrote:
Hi Experts,
Required your advise on VBA training, I am looking for VBA best training in
Basavanagude or Gandhibazr Bangalore. Could any body have any good training
institute please provide me the
Hello friends I am looking for solution for our intercompany company
reconciliation report.
I have data as per the sheet *data, *now I want the macro to sent out all
the info as per sheet *requirement *to be mail out when I click a macro to
all the peoples who owns the a/c.
Please help me in
@bushan
mail your file to id excel-macros@googlegroups.com and attach the file
On Wed, Feb 2, 2011 at 4:42 PM, Bhushan bsabban...@gmail.com wrote:
Hi,
I am not finding any link from where i can upload my sample file.
Regards.
Bhushan
On Feb 2, 2:11 pm, Manish pansari.man...@gmail.com
Hi Team,
Is there any alternate way to get page count details from a Zipped folders
files without unzip the data.
I.e. I will usually get zip files containing a set of PDF files. I have to
track the page count of each pdf files. Now I am doing the below steps to do
this task,
1. Unzip the
Ashish Koul has been selected as *'Most Helpful Member'* for the month of
Jan 2011.
He has posted over 75 posts (11% of total posts) in January 2011 and helped
many people through his expertise. He has been consistent contributor to
this excel forum.
*Many Many Thanks Ashish for wonderful
Very easy to understand, and just what I needed. Thank you very much
for your time and knowledge!
On Feb 2, 12:40 am, ashish koul koul.ash...@gmail.com wrote:
see if this helps
Sub sort1()
Sheets(1).Range(a1:a Range(a1).End(xlDown).Row).Sort
key1:=Sheets(1).Range(a:a),
Wow, I like this VBA example quite a bit, the problem I provided was
indeed simplistic and would need to be modified for my intended need.
I'm fairly new at VBA and very much appreciate your skill and
knowledge. I was wondering if an array was the way to go! Thank you
Again!
On Feb 2, 3:51 am,
Hello everyone,
I am glad to share that I have decided to launch an excel knowledge website
for this group.The website will be launched on 4th anniversary of this group
i.e. 17th March 2011.
The designing of the website and development of content has already been
initiated by me.
I will need
Hey Ayush,
This is indeed a great news!!
A great initiative from your side once again!!
By profession I do a little bit of web development and content development.
Therefore I would like to be the first volunteer to this job..
Cheers,
Andy
On Wed, Feb 2, 2011 at 9:09 PM, Ayush
Congrats ashish.
He is really wonder boy. i have seen his many posts and his knowledge is damn
good.
happy to meet u here Ashish your code has taught me a lot. :)
From: Ayush jainayus...@gmail.com
To: excel-macros@googlegroups.com
Sent: Wed, 2 February, 2011
Dear all experts,
I am not confirmed about array { } formulas when why use this. Please
clearfiy with examples.
Regards,
Aamir Shahzad
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips
Dear Ashish,
why use and why use 4 times. And please tell other Format text
Regards,
Aamir Shahzad
On Wed, Feb 2, 2011 at 3:53 PM, ashish koul koul.ash...@gmail.com wrote:
type this in cell f5
=TEXT(E5,)
On Wed, Feb 2, 2011 at 1:09 PM, solomon raju faithful1...@gmail.comwrote:
Hi,
I need further assistance on this matter.
After I create a database, how can I delete entire rows where cell in
column C (C2, C3,) equals 0?
thank you in advance,
seba
On 28 jan., 15:33, ashish koul koul.ash...@gmail.com wrote:
alright let us know if you require any help
On Fri, Jan
Congratulation Ashish Ji,
you are wonderful ashish ji, your knowledge of VBA is very impressing your
creative formulas are too.
congrts again, CHEERS
Regards
ROHAN
9818247278
On Thu, Feb 3, 2011 at 1:19 AM, hanumant shinde
hanumant_5...@yahoo.co.inwrote:
Congrats ashish.
He is really
Hi Experts,
I am also Required your advise on VBA training, I am looking for VBA best
training in East Delhi any body have any good training institute please
provide me the address or phone no. to contact.
Thanks
Anil Kumar
113784
On Wed, Feb 2, 2011 at 4:57 PM, Puttu *
Congrats ashish.
On Thu, Feb 3, 2011 at 1:19 AM, hanumant shinde
hanumant_5...@yahoo.co.inwrote:
Congrats ashish.
He is really wonder boy. i have seen his many posts and his knowledge is
damn good.
happy to meet u here Ashish your code has taught me a lot. :)
Hi,
I have recently started using Excel 2007 and was previously with Excel 2003.
I found the transition not very easy in terms navigating to the frequently
used commands/functions. One observation i have is also that the 'Review'
tab takes while to load unlike other tabs. Anyone has an idea on why
hi,
for converting the date formate, if a1 has the date 01/01/2011 :
for Day : Text(a1,ddd) = result =(Sat)
Text(a1,) = result =(Saturdary)
for Month : Text(a1,mmm) = result =(Jan)
Text(a1,) = result =(January)
for Year : Text(a1,yy) = result =(11)
I TOO INTEND TO CONTRIBUTE.
On Wed, Feb 2, 2011 at 9:09 PM, Ayush jainayus...@gmail.com wrote:
Hello everyone,
I am glad to share that I have decided to launch an excel knowledge website
for this group.The website will be launched on 4th anniversary of this group
i.e. 17th March 2011.
The
Congrats Man
Regards,
Manoj Kumar
On Thu, Feb 3, 2011 at 10:31 AM, anil panchal anil.kan...@gmail.com wrote:
Congrats ashish.
On Thu, Feb 3, 2011 at 1:19 AM, hanumant shinde hanumant_5...@yahoo.co.in
wrote:
Congrats ashish.
He is really wonder boy. i have seen his many posts and
Congratulation Ashish Ji,
Great Job..Please Keep it Continue..
Download: www.eType.com/Welcome.php http://www.etype.com/Welcome.php
On Wed, Feb 2, 2011 at 8:25 PM, Ayush jainayus...@gmail.com wrote:
Ashish Koul has been selected as *'Most Helpful Member'* for the month of
Jan
Congress ashish sir i am also big fan of ur knowledge and ur
kindliness for others
thanks for being part of this group and being helping hand for others
keep up the good work sirji,
ayush sir ur discussion is right
On 2/3/11, NOORAIN ANSARI noorain.ans...@gmail.com wrote:
Congratulation Ashish
Dear Group,
I also need VB Training. Please Suggest
Thanks,
Prabhakar Thakur
New Delhi
+919953736776
On Thu, Feb 3, 2011 at 10:24 AM, anil panchal anil.kan...@gmail.com wrote:
Hi Experts,
I am also Required your advise on VBA training, I am looking for VBA best
training in East Delhi
Hello friends.
Can any one help me on this?
Thanks in advance
Jagadeesh B S
On Wed, Feb 2, 2011 at 5:30 PM, Jagadeesh B S jagg...@gmail.com wrote:
Hello friends I am looking for solution for our intercompany company
reconciliation report.
I have data as per the sheet *data, *now I
hi Rohan,
that was cool. good info even though it was asked for month only u mentioned
day
and year also. good initiative. i like it
From: Rohan Young rohan.j...@gmail.com
To: excel-macros@googlegroups.com
Sent: Thu, 3 February, 2011 10:30:08 AM
Subject: Re:
congrats Ashish
Regards
Umesh Dev
On Wed, Feb 2, 2011 at 8:25 PM, Ayush jainayus...@gmail.com wrote:
Ashish Koul has been selected as *'Most Helpful Member'* for the month of
Jan 2011.
He has posted over 75 posts (11% of total posts) in January 2011 and helped
many people through his
Hi,
Coild the problem be the fact that the calculation option is on manual?
Greets Peter
2011/2/2 Hector Ruiz hector.ru...@gmail.com
Hi all, I made a macro to do a consultation with automatic cell ranges,
with letters running but when the result is number does not work, I have
to double
Hi Hector,
Change the formula to IF(ISBLANK(D2),(B2-A2)*24,(D2-B2)*24) in the vba you
have mentioned is esblanco
Regards
Umesh Dev
On Thu, Feb 3, 2011 at 2:01 AM, Hector Ruiz hector.ru...@gmail.com wrote:
Hi all, I made a macro to do a consultation with automatic cell ranges,
with
41 matches
Mail list logo