How to list and count unique records
Sun, 2 May 2010 13:23:17 -0700 (PDT)
I am trying to tabulate errors from an automated checking tool.
The errors are listed by line. There can be hundreds of results but
mostly there are less than a dozen errors found repeatedly. I would
like to list the unique errors that occur, and list a count for how
many occurrences there are for each of those ...
|
EXCEL ENQUIRY
Sun, 2 May 2010 20:28:26 +0100
Hello,
I would be most grateful if someone could help me to create a formula in
Excel to add text. Please see below what I need to achieve:
1- I need to have a formula that add all the "Yes" contained in an Excel
column in Sheet 1 and have the total of all the "YES" (In numerical form) in
Sheet 2, hence I a ...
|
EXCEL ENQUIRY
Sun, 2 May 2010 20:24:43 +0100
Hello,
I would be most grateful if someone could help me to create a formula in
Excel to add text. Please see below what I need to achieve:
1- I need to have a formula that add all the "Yes" contained in an Excel
column in Sheet 1 and have the total of all the "YES" (In numerical form) in
Sheet 2, hence I a ...
|
Can't email direct from Excel spreadsheet as attachment.
Sat, 1 May 2010 19:04:16 +0100
I've recently had to re-install my OS and all the programmes. I find I can
no longer click on the 'send the spreadsheet as an attachment' button. Has
anyone any ideas plse? I am running Windows Vista Home Premium and Office XP
and have set the default email handler to Windows Mail.
Has anyone any ideas plea ...
|
Compatability report?
Sat, 1 May 2010 17:46:52 +0100
The following features in this workbook are not supported by earlier
versions of Excel. These features may be lost or degraded when you save this
workbook in an earlier file format.
Minor loss of fidelity # of occurrences
Some cells or styles in this workbook contain formatting that is ...
|
Problems with Gantt chart in Excel
Fri, 30 Apr 2010 18:09:56 -0400
I'm a novice using Excel 2007 and trying to create my first Gannt chart.
The result is at
http://www.hold.orthohelp.com/Gantt attempt.xlsx
Obviously I am doing something wrong because it does not look like the
example I followed in:
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=343
under "A ...
|
just installed office 2007
Fri, 30 Apr 2010 21:09:18 +0100
Before I spend hours trying to do this can I get the toolbars etc at the top
of the page looking anything like the old excel, there appears to be so much
there that I dont use and the stuff I normall use I am spending ages trying
to find it. It also takes up a lot of screen.
I accept I am just new to this ...
|
|
|
changing columns into rows
Fri, 30 Apr 2010 13:12:41 -0400
I'm a novice using Excel 2007 in W 7.
I have an existing database where I would like to change things so that
the rows become columns and vice versa. Is there a way to automatically
do that or do I need to recreate the spreadsheet from scratch?
Thanks, Jeff ...
|
Name Cell, Copy Named Cell, And Add All Named Cells
Fri, 30 Apr 2010 09:47:27 -0700 (PDT)
I'd like to be able to have a cell that is able to be copied and then
have another location that adds the original cell and any copies of
that cell.
In my situation, I have a group of cells that get copied different
numbers of times each time I use the document.
There is one cell in that group and all the cop ...
|
Help! "Find" command is suddenly going crazy!
Fri, 30 Apr 2010 15:50:29 GMT
Got a speadsheet with one column only. Around 9,000 or so lines. After
any additions I make, I always re-sort it aplhabetically. Never had
problems before, but today it's freaking me out! It's a list of band
names and includes:-
(hundreds)
...
NOVA REX
....
(hundreds more)
...
REX
...
(hundreds more)
...
|