|
Count fields and show names
Hello all,
I have an excel spreadsheet that has 5 fields (cells-HIP, WAIST, ARM,
LEGS, HEAD) each with a value of 1 or 0 (True or False)
I need a formua to count the 5 fields and if there are 3/5 that are 1
(True) then fill a new cell (Total) with 1(True), if there are less
than 3 fields, then False (0). But would it also be possible to show
which fields, along with the value of 1 or 0, we...
|
6 |
03.09.2006 20:34:51 |
|
|
Public Sub in ThisWorkbook not found
I don't know what's going on, but I have created a public subroutine in
my workbook, at the workbook level (not on a sheet) but none of my
sheets can see the subroutine.
I know this should be possible, I could swear I've done this for ages,
but I cannot figure out what is going on here.
The subroutine in ThisWorkbook is defined as:
Public Sub ScoreSummary(rngTarget As Range)
I try to ...
|
3 |
03.09.2006 20:10:51 |
|
|
How to not chart empty series
I am trying to build dynamic charts which chart only the series with
non-zero data in them.
i.e. I've got the chart pointed to a data range of say 20 different
series, of which only a handful are likely to have non-zero values in
them at any given moment.
How do I chart JUST the ones with non-zero values, and hide or ignore
the ones which are just a row of zeros?
I don't want to delet...
|
6 |
03.09.2006 19:37:04 |
|
|
Left Justification Question ?
Hello:
Using Excel 97.
I know, Wow, but it does everything, for the most part, that I need.
Question:
I have a column of numbers; single and two digit.
On the menu, I have the icon that shoves it all to the left selected.
I have a few single digit numbers in the column, though, that I would like
to move over in the column by a space or two.
Not leading zeros, just want to move t...
|
3 |
03.09.2006 19:28:36 |
|
|
Calculating average based on 7 days or 5 days
Hi all,
I am trying to generate an average based on two criteria. I have column
A as the date that covers every day of a month, column B is colour (i.e.
blue, red, yellow, etc), and column C a number, column D is the total.
Every day column D updates automatically based on the date. I must fill
in the number or colour. If I was to fill in colour then it is simple as
it covers every...
|
6 |
03.09.2006 16:09:26 |
|
|
find the highest letter/number combination
I wish to have Excel 2000 look along a row of letters and return the
highest letter/number (latest in the alphabet) to a cell.
the range is like: A-B-C1-D3
i can find the highest letter, but i can not find the highest number.
i want excell to find the combination D3, does anyone know how to solve
this problem?
...
|
5 |
03.09.2006 14:19:15 |
|
|
Conditional formatting
Help Please
I've built a spreadsheet for monthly rostas, with the columns;
Date, Day, Staff-a, Staff-b.
No problem with Date and created Drop-Down Lists for Staff-a, Staff -b.
Day is formatted as text to give the day of week but also it has Conditional
Formating to highlight the Sunday in the month.
But, is it possible to high-light the whole row when Date/Day show up ...
|
3 |
03.09.2006 14:11:10 |
|
|
How to set the amount of values visible when open a combo box?
How to set the amount of values visible when open a combo box?
and
How to have a default value highlighted when opened as always the top
of the list is visible.
Bart
Excell 2003
...
|
4 |
03.09.2006 14:02:04 |
|
|
Row height Autofit
When I use Autofit for Row-heights, my print output either leaves large
open spaces or truncates the cell contents. To avoid this, I have to
manually set each row-height, after seeing the Print Preview, even
after Autofitting. Some fonts seem to have this problem more than the
others.
My printers are perfectly configured. In fact, switching to a second or
third printer is not helping.
...
|
1 |
03.09.2006 13:08:18 |
|
|
advanced conditional formatting help!!
Here is what I am trying to do:
If the sum of 4 cells
E22 to E25
Equals D22
Then Color the text in:
E22 to E25 - Green
---------------------------------------
If the sum of E22 to E25
Does not equal D22
Then color the text in:
E22 to E25 - Red
------------------------------------
Any ideas of how to do this?
Thanks
...
|
4 |
03.09.2006 07:55:19 |
|
|
date and number conversion
I have 3 columns: date numbers numbers
The date column has the format:
Thu Sep 1 17:00:00 2005
I tried selecting the column, format cells, category: date, and select
my preference but nothing changes. Essentially I want to remove the
time and change the date format to D/M/Y. i also tried this on an
individual cell.
For the number columns they are in bytes and I want to change t...
|
6 |
03.09.2006 00:44:17 |
|
|
Exact copy worksheet mirror
Is there a way to make an exact copy of a worksheet (which includes row
spacing/background colors, forumlas), and put them into another excel
file as a new worksheet.
ie.
sheet1 of newbook.xls
is exactly the same as, and is also updated when sheet1 is modified.
sheet3 of masterbook.xls
any thoughts?
...
|
4 |
02.09.2006 16:04:02 |
|
|
calculation for each observation
Hello,
Suppose I have a table which record the income for each people in each
area
area income
1 100
2 70
2 60
I would like to (1) count the number of people in each area and (2)
average income
area number of people average income
1 1 85
2 2 60
Thank you.
...
|
2 |
02.09.2006 11:12:02 |
|
|
help with sum macro - different number of rows
I am trying to record a macro that would sum a column at the end of the
column. However the number of rows will not always be the same. How
do I get the sum to always show up at the end of the column.
TIA
Mark
...
|
3 |
02.09.2006 05:52:11 |
|
|
Update Max value
I wish to update the value in cell A3 from the maximum of the input update
to cell A1 or cell A2 or the previous cell A3 value . I use the formula
=MAX(A1,A2,A3) but it is not working. Any suggestions?
Thanks,
Bob
...
|
4 |
02.09.2006 05:01:45 |
|
|
Can this be done?
Is it possible to move column B fields to the row with matching content in A
From this:
A B
bananas yellow
oranges candy
pigs bananas
cows blue
candy
blue
red
yellow
To this:
A B
bananas bananas
oranges
pigs
cows
candy candy
blue blue
red
yellow ye...
|
2 |
02.09.2006 00:25:39 |
|
|
Send email to mosre than one user
How do I use SendMail when I have multiple addressees? The following
produces valid looking email addresses as you would type them in outlook but
the result is undeliverable.
....
Worksheets("emailAddresses").Activate
ActiveSheet.Range("A2").Select
While Selection.Value & "" <> ""
If MailAddr & "" = "" Then
MailAddr = Selection.Value
Else
MailAddr = Mail...
|
4 |
01.09.2006 23:36:24 |
|
|
Help with hlookup formula
I haven't worked with Excel much, but I'm guessing what I want to do is
possible. I have two sheets in a workbook. One lists about 100 serial
numbers. The other lists about 5000 serial numbers with additional
information on each. So what I want to do is filter and see only the
matches between the two sheets. It looks like you might be able to do
it with hlookup, but I can't figure out th...
|
3 |
01.09.2006 22:50:55 |
|
|
pivot table
is there a way to preserve border outlines in a pivot table after you refresh?...
|
2 |
01.09.2006 21:01:20 |
|
|
Summarizing Items based on classifications
Looking for some help on figuring out how to do something in Excel 97.
I'm using a spreadsheet to track my expenses and spending. Until now,
I've just been recording the date, amount, and an explanation, and
subtotalling each month. Now I'd like to add a category and total by
category for each month. I've added a new column for a category code
(A, B, C, etc). So I have Date, Amount, ...
|
4 |
01.09.2006 20:43:51 |
|
|
Macro to change cells' display, Pounds, euro, dollars
I have a spreadsheet which I plan to protect all but a handful of
fields for the user to enter various money amounts. I'd like to include
a BUTTON in the spreadsheet that will force the display of any money
field to pounds, dollars, or euro. Mostly a cosmetic change, and I
don't want the user to have to select the fields to change since some
are locked.
Is there any example like this using...
|
5 |
01.09.2006 20:29:14 |
|
|
Use Datedif but for future dates
I have a formula for identifying years, months, days from a past date to
now. DATEDIF(C6,NOW(),"y")&" Y, "& DATEDIF(C6,NOW(),"ym")& " M, " &
DATEDIF(C6,NOW(),"md") & " D"
I'd like a formula that can produce the same format (years, months, days)
between now and a future date.
Any ideas?
Thanks in advance,
Bart
...
|
5 |
01.09.2006 20:13:09 |
|
|
Book1 is not automatically closing
I recently tried a couple of solutions I found on these boards to
ensure that the Task Pane stayed visible on startup. I had already
tried setting it in Tools|Options, but since I have both a Personal.xls
and a Book.xlt, I tried the registry dword approach. It worked on the
Task Pane, but then the blank Book1 did not automatically close when I
opened another file. So I deleted the dword, a...
|
4 |
01.09.2006 20:02:40 |
|
|
Verify that looking at DATA of SQL SERVER VIEW will be read-only
We want to start allowing our users to have ODC files to connect to and look
at data in SQL SERVER VIEWS.
I want to make sure that the users will only ever be able to look at this
data and not actually change the back-end SQL data.
Thanks for any clarification you can give!...
|
2 |
01.09.2006 19:32:02 |
|
|
Linking Question
I have several books that are all in the same folder (master templates)
I'd like to link them with out recording the "full path", that way I can
copy the files to "project" folders and use them. But I don't want them
pointing back to the files in the master template folder.
Can I declare some kind of variable %HERE% so that the linked files always
searches the folder where the current file...
|
2 |
01.09.2006 17:58:25 |