hi all,
please help
Thanks
On Tue, Jan 4, 2011 at 1:38 PM, Raj Mahapatra rajafs...@gmail.com wrote:
hi gurumurthy,
you are right. I want to see the description in our macro function as we
see for microsoft functions.
hi Haigreeva,
as per the comments by the gurumurthy, I want to see
hi rajesh
very gud explantion
On Thu, Dec 30, 2010 at 4:51 PM, Raj Mahapatra rajafs...@gmail.com wrote:
hi Group,
i want to show description of the Function while using the same in Excel
like below screen shot.
e.g while using if function in excel it displays like
=if(logical_test,
hi dilip sir
i always felt that one day u will get this title..
congrates
On Tue, Jan 4, 2011 at 8:50 PM, Suryaprasad suryaprasad...@gmail.com wrote:
Congrats Dilip
On Tue, Jan 4, 2011 at 7:37 PM, sharad gupta sharadgupta2...@gmail.com
wrote:
Hi Dilip Sir,
Congratulations to you .
Hi,
A UDF (User Defined Function) is like any other function. It can only return a
value. It cannot do anything else. To change the background colour of a cell,
use Conditional formatting or a regular macro.
Regards - Dave.
Date: Wed, 5 Jan 2011 06:50:53 +0530
Subject: Fwd:
There's GOT to be something else going on.
I created a new file with.xlam extension.
Protected the Sheet and Workbook
Created a sub called Init with only the line:
Application.Calculation = xlCalculationAutomatic
Created a Workbook_Open sub
calling Init.
It worked just fine.
I also tried it
Hi,
Though not a macro... but still works the same...pls chk the attached
Regards,
Manoj Kumar
On Wed, Jan 5, 2011 at 3:52 PM, Jorge Marques leote.w...@gmail.com wrote:
Hi guys, i´m need your help, i have a list of brands, that i need to put
values of sales of the various shops , from cell
Dear Mr. Dilip
*Congratulations to you*
Regards
Sumit Vyas
On Mon, Jan 3, 2011 at 3:31 PM, Ayush jainayus...@gmail.com wrote:
Dear Group,
I am very very very very happy to share a good news with you. One of our
dearest group member Dilip Kumar Pandey is awarded Microsoft MVP award on
Hi Jitendra,
A solution can be found here: http://www.ozgrid.com/Excel/dependent-lists.htm
On 4 jan, 10:15, Jitendra Verma jitendra.kumarve...@gmail.com wrote:
Hi All,
I have a question related to data validation in excel.
Below is the description..
I want to create two dropdown list using
Hey Susan,,
If you have that book then please send it to my email address or
attach here...
my email address issharma(dot)ctc(at the rate)gmail(dot)com
Thanks Regards,
B. Sharma
On Dec 30 2010, 9:43 pm, Susan susan.m.ander...@comcast.net wrote:
I useExcel2007 Visual Basic for
Hi Dilip,
Many many congratulation to you. This group needs you. Keep it up.
On Wed, Jan 5, 2011 at 4:45 PM, SUMIT VYAS svyas0...@gmail.com wrote:
Dear Mr. Dilip
*Congratulations to you*
Regards
Sumit Vyas
On Mon, Jan 3, 2011 at 3:31 PM, Ayush jainayus...@gmail.com wrote:
Dear
Good one.
Hope the attachment meet your expectation.
Thanks and regards,
Maidul
On Wed, Jan 5, 2011 at 1:36 AM, OpenExcel.com ashishj...@openexcel.comwrote:
Hi Friends,
*What is 'Custom Format' ?:* Microsoft Office Excel provides many built-in
number formats, but in some cases they do not
Hello Rajesh,
There is no foolproof method for this.Try to use run security macro
before opening workbook.
Try to do this.To avoid unauthorized use of your workbook.
1.Write the Machine name of Authorized person line by line in notepad
2.Save it with your desirables name
3.Check machine name
Hi,
I paid for the book via Amazon.com... you could check out your local library
perhaps they have it to check out for 'free'.
Susan
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of B Sharma
Sent: Wednesday, January 05, 2011 3:30
I want to apply formula in excel sheet can you implementation this formula.
Fibrotest = 4.467 × log [α2-macroglobulin] −1.357 × log [haptoglobin] +
1.017 × log [GGT] + 0.0281 × [age] + 1.737 × log [bilirubin] − 1.184 ×
[apolipoprotein A1] + 0.301 × Sex (female=0, male=1− 5.540.
--
It´s excellent, this will do fine! thank you very much Manoj :)
2011/1/5 Manoj kumar manoj.vishwakarma...@gmail.com
Hi,
Though not a macro... but still works the same...pls chk the attached
Regards,
Manoj Kumar
On Wed, Jan 5, 2011 at 3:52 PM, Jorge Marques leote.w...@gmail.comwrote:
Hi Dilip Sir,
Congratulations
By
Narasimharao ML
09010509753
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN
Hi Friends,
As a part of my official activities, I will get incoming document as an
Ordinary PDF format. I have to covert this to a word document before I
processing it.
Now I am Doing the below steps for convertion for each files.
1. Open the PDF File.
2. Select all content using Cntrl+A
Problem - I have one spreadsheet which is used to record our time
sheet in office. Sheet 1 is named Macro1 and has following code/lines
in the cells starting from A1 till A18:
Next Fortnight
=ECHO(FALSE)
=SELECT(R56C13)
=COPY()
=SELECT(R9C15)
=PASTE.SPECIAL(3,1,FALSE,FALSE)
=SELECT(R10C4:R49C5)
Hi,
I have a list of numbers and I need to find the highest of the most
frequent occurrances.
For example:
List 1
1
3
3
4
4
Should return the value 4 because its the highest of the most
frequent
occurrances of any number.
List 2
1
3
3
3
4
4
Should return 3 because it's the most frequent
Hi,
I need to combine several excel files into one file. I create this new
file in the directory that user chooses (this folder contains the
files I want to copy). It loops trough the files and works perfectly
except that it copies the combined Manual Timesheets.xls file and
pastes it to itself
check the attachment see if it helps
On Thu, Jan 6, 2011 at 6:17 AM, Kim anast...@gmail.com wrote:
Hi,
I have a list of numbers and I need to find the highest of the most
frequent occurrances.
For example:
List 1
1
3
3
4
4
Should return the value 4 because its the highest of the
Hi Ashish,
can you pls explain this.
{=OFFSET(E1,MAX(IF(F2:F9=MAX(F2:F9),ROW(F2:F9),))-1,0)}
Also,why have u used {}. when to use them. if do F2 i get Value error. why is
it
so.
so many que :( can you please explain.
From: ashish koul
try this macro
first get all the pdf names with complete path by clicking on file name and
selecting the folders having pdfs
then click on make documents
remebr u need to chang i =1 to last no
and
C:\Program Files\Adobe\Reader 9.0\Reader\AcroRd32.exe
path in the code
On Thu, Jan 6,
Dear members,
There is a excel puzzle for you. Let see who all can give the answer
correctly.
There is a data of [month] in excel with no fixed length , minimum three
characters, text format. You need to develop formula (Not Macro) which can
convert it into number.
For example
Jan to 1
March
there was Typo in example...its Decem to 12
Submit your answer now. :D
Thnx again.
On Thu, Jan 6, 2011 at 11:54 AM, Ayush jainayus...@gmail.com wrote:
Dear members,
There is a excel puzzle for you. Let see who all can give the answer
correctly.
There is a data of [month] in excel with no
check the attachment
MONTH(VALUE(LEFT(A1,3)1))
On Thu, Jan 6, 2011 at 11:54 AM, Ayush jainayus...@gmail.com wrote:
Dear members,
There is a excel puzzle for you. Let see who all can give the answer
correctly.
There is a data of [month] in excel with no fixed length , minimum three
Wow AshishSuperfast...I liked it..
Dear group,
Do you have better answer to beat ashish :P
On Thu, Jan 6, 2011 at 11:57 AM, ashish koul koul.ash...@gmail.com wrote:
check the attachment
MONTH(VALUE(LEFT(A1,3)1))
On Thu, Jan 6, 2011 at 11:54 AM, Ayush jainayus...@gmail.com wrote:
Dear
try this it may help
Fpath = BrowseFolder(Caption:=Select the folder .)
excelFile = Dir(Fpath \*.xls)
Do While excelFile
If excelFile Combined Manual Timesheets.xls Then
Workbooks.Open Filename:=Fpath \ excelFile
' copy rows
ActiveWorkbook.Sheets(1).Activate
LastRow
how about this...
=MONTH(1A1)
Regards,
Manoj Kumar
On Thu, Jan 6, 2011 at 12:05 PM, ayush jain jainayus...@gmail.com wrote:
Wow AshishSuperfast...I liked it..
Dear group,
Do you have better answer to beat ashish :P
On Thu, Jan 6, 2011 at 11:57 AM, ashish koul
Thanks so much Ashish but the problem is in the temporary column. I
really need to do it in one cell only without introducing any new
data.
Any idea on how I can achieve that?
Again, thanks for your help.
Kim
On Jan 6, 4:07 pm, ashish koul koul.ash...@gmail.com wrote:
check the attachment
30 matches
Mail list logo
