Hi,
You can modify your formula as =CONCATENATE("FY09-Q4",CHAR(10),"
(",TEXT(SUM(A2:A4),"0,000"),")") .
Regards,
Deepak
On Tue, Jun 8, 2010 at 8:31 PM, Sharath Sambrani <
sharath.c.sambr...@gmail.com> wrote:
> thanks Paul,
>
> it worked amazingly!
>
> :)
>
> On Tue, Jun 8, 2010 at 8:19 PM, P
Hi,
Give me a sample file I will solve this for you.
Regards,
Deepak
On Tue, Jun 8, 2010 at 8:35 PM, molinari wrote:
> I have a list of reports to be printed out Monday - Friday, where each
> worksheet is Monday, Tuesday, Wednesday, Thursday, or Friday. I made
> another worksheet to list repo
Hi Amanda
You haven't specified at what stage you are stuck with your macro or
attached the workbook.
The correct way to go would be
1) Confirm if names are repeated in the source sheet
2) Loop through the column containing the names.
3) Go on adding and renaming sheets and pasting the specific r
Jason,
There can be a way to automate end-to-end, of what the employees are
doing or may be to some extent atleast
Can you send a sample sheet to the group
People will be able to help you a bit faster by looking at it
Cheers
Harry
On Jun 8, 4:59 pm, JsinSk wrote:
> Hello All,
>
> At my workp
Swapnil,
Your post is an amsing one.
Thanks
Alfred,
There are two things to the solution provided by Swapnil,
1) There is a label on the sheet1
2) There is data on the sheet which makes the graph
If you go into design mode of excel and click over the data, you will
be able to select a invisib
Hi
You may also
1) sort the column (say A)
2) write this formula in an empty (or insert a new one) column next to A (B)
=A2=A1
3) Filter column B for all "TRUE" values and delete entire rows of the
filtered range!
:)
Hemant Hegde
On 8 June 2010 19:34, ashish koul wrote:
> first sort the s
I had an xlsm workbook that was shared and very slow even though the
file size was only 3000 K. This file took around 3 minutes to open or
save. After removing the custom views that had been automatically
created by users editing the sheet, the file size went down to
200K ... opening now takes 4 se
I have a list of reports to be printed out Monday - Friday, where each
worksheet is Monday, Tuesday, Wednesday, Thursday, or Friday. I made
another worksheet to list reports that we no longer need (by their
report number). I want the macro to go through the worksheet and
delete the rows that corres
the =Text() function diplays numbers in different formats.
replace your Round() function with:
text(round(sum(a2:a4),0),"#,###")
=CONCATENATE("FY09-Q4",CHAR(10)," (",TEXT(ROUND(SUM(A2:A4),0),"#,###"),")")
curiously enough,
you SHOULD be able to use:
="FY09-Q4" & CHAR(10) & " (" & TEXT(ROUND(SU
what version of excel are you using?
Excel 2007 has a =SUMIFS function that allows you to sum a column using
multiple ranges and criteria.
you then copy the first 3 columns to another sheet, sort and remove duplicates
(also in Excel2007)
You then use =sumifs (the function wizard will help) to add
Hello All,
At my workplace we have a report that is run every 15 minutes, it
takes an employee nearly all of those 15 minutes to process and report
the data to the group. I'm looking for a way to help automate this
somewhat for the employee so he can work on other tasks through the
day as well.
B
Hi,
i am trying to use sum function in concatenate function. i want to
concatenate 'text' + 'sum of a range' + 'text'
i want to use this in a column heading, say cell A1.
cells A2, A3 and A4 has number values.
in cell i want to display as:
FY09-Q4
(4,464)
FY10 should be displayed in the first
Dear Mahesh,
Excel 2007 can open file upto 10,48,576. Go to Data Tab> From Text>then
select your notepad file & import in excel
Regards,
Prashant
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Mahesh
Sent: 08 June, 2010 7:51 AM
To: excel-macros
Dear All,
Need your help on below mention issue.
I have a notepad file which contains more than 10 lacs records.
Can anyone give me a solution, how to open it in excel?
--
With Love,
Mahesh Bisht
--
--
Some impor
Hi Lkmodi,
The uploaded spreadsheet does not have any formulas/VBA in it. It is
simply to give you an idea of what the sheet will look like (first
tab) and what I want the tabs to eventually look like (2nd tab).
Thanks,
Amanda
On Jun 7, 6:15 pm, "L.K. Modi" wrote:
> > DEAR AMANDA
>
> > I HAVE F
I am having some trouble figuring out a problem. Anyway, I am working
with a large dataset, so it is obviously not efficient to do this by
hand, so hopefully someone can help me out.
This is how my spreadsheet is set up:
Year|Last Name|First Name|$ amount|Cholesterol Level|Height|Weight
However,
I have code that exports a query from Access to Excel. At times I am
unable to open the Excel file that I created. When I double click on
the file from Windows Explorer, the file flashes on the screen very
quickly and goes away. If I go to the task manager and end
"Excel.exe," I will then be abl
Hi Swapnil (nice name !! where is it from ?)
Your soluce works fine ! thx a lot !
I have à second question, do you think is it possible
to "affect" the graphic to a shape ?
I have this question because, with this solution, I can't modify the
numbers
of the graphic. So I think I need 2 areas, the
18 matches
Mail list logo