Hi All,
I would be grateful if you guide me to how I could consolidate .csv files and
be able to separate or distinguish between the rows by the different files
being consolidated.
Eg. .csv File 1:
Column A
1
1
1
.csv File 2:
Column A
2
2
2
Consolidated .csv
1 File1
Hi Shilpa,
Just to add to Mahesh's email .. this will work if you open both Excel
workbooks in the same Excel 'window'.
Thanks,
Amitabh
Date: Wed, 2 Dec 2009 17:00:52 +0530
Subject: Re: $$Excel-Macros$$ need help in excel
From: mahender.bi...@gmail.com
To: excel-macros@googlegrou
Hi Sudhir,
I found the following document via google (searched for: " Introduction to
Excel Macros")
Link: www.dur.ac.uk/resources/its/info/guides/39Excel2003Macros.pdf
I hope this helps you to understand what Macro's do.
Regards,
Amitabh
Date: Tue, 3 Nov 2009 14:00:42
Hi Anil,
The drop downs in the spreadsheet have been made using 'Data Validation'.
In Excel 2007 this can be found under the ribbon 'Data' - click on Data
Validation' - choose "list" from the options under Allow.
The source section will contain your metadata, ie the data which you wi
Hi Abdul,
You can do this using the MRound function. Example:
Cell A1=120
Formula: =MBOUND(A1,5)
here 5 means to the nearest 5. If you want the numbers to the nearest 10 then
the formula would be:
=MBOUND(A1,10)
Thanks,
Amitabh
Date: Tue, 13 Oct 2009 23:21:10 +0500
Subje
Hi,
Please find that attached spreadsheet. I have used converted the dates using
the 'Date Value' function and then used the day(),month() and year() formulas.
Thanks,
Amitabh
Date: Mon, 21 Sep 2009 07:43:44 -0400
Subject: $$Excel-Macros$$ hey also i was trying to convert these
Hi Manoj,
You will need to save the Office 2007 file in compatibilty mode, ie save it in
the format of Excel97 to 2003. Then you will be able to open the file in MS
office 2003.
Thanks,
Amitabh
From: manoj...@ocimumbio.com
To: dilipan...@gmail.com; excel-macros@googlegroups.co
Hi Rag,
You can print with the row and column headings by:
1. Going to print preview
2. Page Set-up
3. Choose the 'sheet' tab
4. Select the 'Row and Column headings' option.
Thanks,
Amitabh
Date: Tue, 1 Sep 2009 13:30:18 +0530
Subject: $$Excel-Macros$$ Require tabs to be see
Hi All,
Apologies for sending this request. I seem to have found out the solution. I
wasted one whole hour trying to figure out something which was simple, but I
seem to have over looked how the formatting is done. Please do not waste your
time on this request.
Apologies once again.
Hi All,
I would be grateful if you could help me out with the following problem I am
facing with regard to data formatting:
The changes I need to make to the file are as follows:
1. I need to deduct one hour from the 'CaptureTime' field(column E) which is in
seconds.
This I have
Hi Ramesh,
I have attached the spreadsheet and solved the second issue with regard to the
Date() function. and this is on the sheet named 'Date formats'. There may be
better ways of doing this but this is the method which came to mind first.
I was not clear on what you exactly wanted do
Hi Jen,
I have attached a file with the points plotted for both the mean and variance.
I am not sure which version of MS Excel you are using. The version of the file
attached is on MS Excel 2007 and the steps to construct the graph is as follows:
1. Insert - Choose chart type (Eg column
Hi Ramesh,
Please find the file attached with the vlookup formula.
The basic formula is:
=VLOOKUP($A3,Sheet1!$B$4:$F$18,4,0)
The ISNA formula is to replace any blank cells which come up with NA# with
'blank' cells.
Hope this helps.
Regards,
Amitabh
> Date: Thu, 1
Hi Zheng,
CTRL+` is working on my version of Excel 2007. This is listed in the list of
Excel 2007 shortcut keys which can be seen in the link below:
http://office.microsoft.com/en-us/excel/HP100738481033.aspx
Hope this helps,
Amitabh
Date: Mon, 8 Jun 2009 13:44:55 +0200
Hi John,
You need to change the format of the columns where you want numbers with
leading zeros to 'Text format'.
Another option if there is for example only one number you want with a leading
zero is to preceed the number with an " ' ", for example if you want to enter
the number 075
15 matches
Mail list logo
