|
Issue with a formula to help generate a report.
Hi all,
I'm trying to generate a report and am having trouble with the formula.
Any help would be greatly appreciated.
Here is what I need to be able to do.
I have 6 worksheets in the same workbook, worksheets 1 - 5 are
identically laid out and the sixth is the one I want to generate a
report on. Column A is for peoples names, Columns B-H are labelled
Monday - Sunday on top. If the pe...
|
1 |
29.09.2006 09:46:07 |
|
|
Add VLOOKUP
You are going to kill me, but it keeps returning zero when the total should
be $14.27. Could you take a look at it again.....pretty please?
"Bob Umlas" wrote:
> =SUMPRODUCT(--('21'!$B$8:$B$53=A14),$H$8:$H$53)
>
> "Nakia Allen" <NakiaAllen@discussions.microsoft.com> wrote in message
> news:D704BD32-E7F1-4F0D-B4E6-13EA079904F8@microsoft.com...
> > Greetings,
&...
|
2 |
29.09.2006 09:45:18 |
|
|
Disable Search Function In Excel Worksheet
How can I disable the search function (Control + F) in Excel 2003?
...
|
1 |
29.09.2006 08:59:36 |
|
|
Combining multiple worksheets
I have multiple worksheets with data in the same format - one worksheet per
month or cost center. Is there a way to combine these in one worksheet - a
way other than copy-pasting manually?
Thanks much....
|
1 |
29.09.2006 08:48:03 |
|
|
Custom Validation Not Accepting Valid Data Revision
Does anyone know why the following custom validation formula does NOT
allow
the user to accept zero (0) as a valid replacement for the target
cell?:
S11=AND(COUNTA($P11:$S11)<3)
MS-Excel will allow the user to hit the "escape" key and reset the
target field
value back to "blank" status.
...
|
2 |
29.09.2006 05:05:03 |
|
|
RAND FUNCTION
I AM TRYING TO CREATE A LIST OF 10 RANDOM SAMPLES WITH TWO DIGIT NUMBERS FROM
A 5 X 5 MATRIX THAT I ALREADY CREATED. HOW DO I INPUT THE COLUMN, ROW AND THE
STARTING NUMBER>...
|
2 |
29.09.2006 04:56:04 |
|
|
How do I get labels to repeat in a pivot table?
I am working with a table where I need to sort and subtotal by employee and
department. I'm trying to figure out a way to either use subtotal or a pivot
table to do this. With the pivot table, I get the data sorted correctly but
the name doesn't carry to each line. If I subtotal, I get the sort by field
on the total line but not the department name. Any ideas?...
|
4 |
29.09.2006 04:54:20 |
|
|
count many with COUNTIF?
Is there a way of doing this:
=COUNTIF(A1:A200;C2:C15)
without having to
=COUNTIF(A1:A200;C2)+COUNTIF(A1:A200;C3)+ ... ?
with best regards
P.S.
For those using a non-english Excel -- such as I (me?) -- translations of
functions in 9 languages: cherbe.free.fr/traduc_fonctions_xl97.html...
|
2 |
29.09.2006 04:49:27 |
|
|
SUMIF Function
Dear all,
I set a SUMIF Function in a cell as :
=SUMIF(B2:B222, "Jack", C2:N222).
However, the return to the cell is 0. I think this SUMIF Function is not
working because the figures in cells C2:N222 are created by another worksheet
function and not by actual numbers. Please advise how to remedy this problem
Thanks....
|
3 |
29.09.2006 04:15:19 |
|
|
array functions
how I can edit array functions
thank
...
|
6 |
29.09.2006 02:53:22 |
|
|
Dynamically Changing HLOOKUP table
I have a set of 5 tables with values, by month (12 columns, but single row),
one each for 5 fiscal years, or 60 columns (cells), total (on worksheet A).
I also have a dropdown validation box (seperate cell) from which the
worksheet user can select one of the 5 fiscal years (one worksheet B).
I have an area on the Worksheet B that I would like to populated with the
entire table content ...
|
5 |
29.09.2006 02:51:01 |
|
|
Conditional Underline
ok so in column B I have "Market" (Chicago, new york, etc.)
In column C I have Total Sales
The goals for total sales are different for each market. How do I Underline
the values in all cells that exceed a certain value depending on the market.
Example: Goal for Chicago is 4; Goal for New York is 7
Name Market Sales
John Chicago 4
Jed New ...
|
6 |
29.09.2006 01:31:02 |
|
|
Error dialog box meaning and how to find error
I have a spreadsheet that has formulas and links to another page in the
spreadsheet. The other spreadsheet has a link to another workbook. On the
2nd worksheet of the work book I get an error message box "A formula in this
worksheet contains one or more invalid references. Verify that your formulas
contain a vaild path, workbook, range name, and cell reference. I have
reviewed every ...
|
2 |
29.09.2006 01:10:33 |
|
|
array manipulation
i am interested in performing a task that will describe in terms of
pseudo-code:
if i were doing this with a programming language, then i would write a
program that takes in a matrix as a parameter. this would be an n x 3
matrix. i would then get the second column vector (representing
products) and iterate through it. i would check whether the count of
the i-th element in the vector is gre...
|
2 |
29.09.2006 00:35:01 |
|
|
converting hours to minutes w/o VBA
I am currently trying to convert hours to minutes or numbers to
minutes... for example if I take 1127 -812, I get either 315 general
number or 3:15 in time format (if all numbers are in time format)... if
I go this way, I would like to convert the time to show minutes or 105
as a general number. The other way would be to keep the general
number, but then this problem occurs... 1002-926=76, when...
|
4 |
28.09.2006 23:21:08 |
|
|
name an active worksheet
I have a workbook with several worksheets. After entering data into selected
sheets it needs to feed into a letter built in one of the worksheets. A
userform on the letter sheet is used to pick which worksheet the data should
pull from. I have visual basic code written so it pulls from one of the
worksheets at a time, but I would like to write code so it goes to whatever
sheet was selected...
|
2 |
28.09.2006 23:17:55 |
|
|
Multiple lists with repeated values for dependet drop down lists
I have three columns with repeated values in each that I am using to create
dependent drop down lists using data validation in excel.
Because of the repeated values in each column (not just the first one), I'm
having trouble getting the drop down lists to display only pertinent
information. If there are three repeated values in the second/third column,
the drop down will display three ...
|
2 |
28.09.2006 23:13:23 |
|
|
Dropdown box
I have a spreadsheet with 6 drop down boxes. Is there away to make the
dropdown boxes in a specific default every time another user opens it?
...
|
2 |
28.09.2006 23:10:57 |
|
|
calculate count on 2006 total, 2005 total, etc...
I am working on a spreadsheet for workers comp injuries. I need to have a
total of injuries broken out per year. I can't seem to get the function to
work properly...probably because I am using the wrong one. Any ideas?...
|
7 |
28.09.2006 22:59:30 |
|
|
Link multiple worksheets while extracting data
I am trying to create a system that will decrease the amount of times I need
to type information. I have a worksheet that keeps track of all tasks done by
an employee and for how long.
Ie. Employee File:
John
Hours Job Description etc...
1.5 Customer1 painting
4 Customer2 painting
2.5 Customer1 sanding
I only want to...
|
1 |
28.09.2006 22:55:01 |
|
|
Rearranging cells into certain columns
Currently, I have an excel spreadsheet that looks like this:
A B
C
Pamela Potter Kris Sautter Anita Serda
Assistant 1 Assistant 1 Assistant 1
Continuing Educ Division of Academic Affairs Admissions Office
Where Row 1 is the Name, Row 2 contains the persons Title, and Row 3
...
|
2 |
28.09.2006 22:52:04 |
|
|
Hide Rows
Hi,
I have a dropdown validation list. When I select an item from this
list, the rows below will be populated using the HLOOKUP function. The
HLOOKUP function brings the values from the other sheet. The records
will be one to one thousand. And I have the formula upto 1000 rows.
When item has just one value in it the other rows will have the value
zero.
I need to hide those rows which ha...
|
3 |
28.09.2006 22:20:01 |
|
|
can I sort names in a column by the last name if it is typed last
...
|
2 |
28.09.2006 22:12:29 |
|
|
Worksheet Protection status
Is there a worksheet function that will return the status of the worksheet as
being "protected" or "unprotected" that I can display?
Thanks for any and all assistance.
JimB...
|
2 |
28.09.2006 22:02:00 |
|
|
macro needed for non-blank cells
I am trying to write a formula that is contingent on an adjacent column.
Specifically, I am writing a formula using multiple IF worksheet functions.
In an adjacent column I have a series of 1's and 0's with non-blank cells in
between. Does anyone know how to write a formula that will read a previous
column for the last non-blank cell?
Here is an illustration that might help:
Col...
|
6 |
28.09.2006 22:01:02 |