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 wrote:
> check the attachment see if it helps
>
>
>
how about this...
=MONTH(1&A1)
Regards,
Manoj Kumar
On Thu, Jan 6, 2011 at 12:05 PM, ayush jain 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 wrote:
>
>> check the attachment
>>
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).A
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 wrote:
> check the attachment
>
> MONTH(VALUE(LEFT(A1,3)&1))
>
> On Thu, Jan 6, 2011 at 11:54 AM, Ayush wrote:
>
>> Dear members,
>>
>> There is a excel p
check the attachment
MONTH(VALUE(LEFT(A1,3)&1))
On Thu, Jan 6, 2011 at 11:54 AM, Ayush 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
> characters, text for
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 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 ,
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
its array formula so u have to press ctrl +shift +enter then {} it will
come automatically
for offset check help =
MAX(IF(F2:F9=MAX(F2:F9),ROW(F2:F9),"")) it will return the maximum row no
which is having max value in range f2:f9
On Thu, Jan 6, 2011 at 11:15 AM, hanumant shinde
wrote:
>
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, 20
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
To: excel-macros@g
check the attachment see if it helps
On Thu, Jan 6, 2011 at 6:17 AM, Kim 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 most
>
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
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 occurr
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 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
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 grou
It´s excellent, this will do fine! thank you very much Manoj :)
2011/1/5 Manoj kumar
> 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 wrote:
>
>> Hi guys, i´m need your help, i have a
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.
--
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 A
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 before
Good one.
Hope the attachment meet your expectation.
Thanks and regards,
Maidul
On Wed, Jan 5, 2011 at 1:36 AM, OpenExcel.com wrote:
> Hi Friends,
>
> *What is 'Custom Format' ?:* Microsoft Office Excel provides many built-in
> number formats, but in some cases they do not meet our needs, we ca
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 wrote:
> Dear Mr. Dilip
>
> *Congratulations to you*
>
>
> Regards
>
> Sumit Vyas
>
>
> On Mon, Jan 3, 2011 at 3:31 PM, Ayush wrote:
>
>> Dear Group,
>>
>> I am very very ve
Hi Experts,
Is it possible to prevent coping a particular Excel work book , from
my computer. I am thinking if the macro has an address like computer
name\d\rajesh.xls it will not work in other computer & other location
without my permission, I don't know is it possible or is there a
better way fo
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" wrote:
> I useExcel2007 Visual Basic for Applications, Step by Step. This b
Hi Jitendra,
A solution can be found here: http://www.ozgrid.com/Excel/dependent-lists.htm
On 4 jan, 10:15, Jitendra Verma 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 the data validation lis
Dear Mr. Dilip
*Congratulations to you*
Regards
Sumit Vyas
On Mon, Jan 3, 2011 at 3:31 PM, Ayush 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
> 1st January for
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 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 B2:B15, and i need
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 wi
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: $$Excel-Macros
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 B2:B15, and i need that
when i select a brand from cell B1 it will copy automatically the value from
cell B16 to the cells from D2 to K2, example, if i select "Adidas" it will
c
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 wrote:
> Congrats Dilip
>
> On Tue, Jan 4, 2011 at 7:37 PM, sharad gupta
> wrote:
>>
>> Hi Dilip Sir,
>>
>> Congratulations to you . That is good news on new year 2011.
>>
>>
hi rajesh
very gud explantion
On Thu, Dec 30, 2010 at 4:51 PM, Raj Mahapatra 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, value_if_true, v
hi all,
please help
Thanks
On Tue, Jan 4, 2011 at 1:38 PM, Raj Mahapatra 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 the descri
33 matches
Mail list logo
