|
|
Conditional placement of an item by
DA_Potts
I want to use/create a function whereby if a value is equal to one number the
data i enter will go into one of a series of cells
example - if the value is 123...
|
|
6 |
54 |
|
|
|
|
3 |
83 |
|
|
This ones got me stuck by
DB
I'm trying to put together a set of worksheets for work that show up who's
on a tea break at a given time..
The project has 3 tabs at the bottom to choose...
|
April 4th, 2007 09:25 PM
by DB
|
4 |
52 |
|
|
I need a function guys! by
DB
I need a function guys!
I need to sum the numbers in column H (H2:H300) but only those numbers in
the rows where a specific value exists in column B . I need...
|
May 6th, 2007 03:42 AM
by DB
|
6 |
108 |
|
|
Negative Column ???? by
DB
I'm trying to work something out and I am trying to find out if something is
possible...
Basically I do the losses and gains at work for various stocks - I...
|
July 8th, 2007 12:30 PM
by DB
|
5 |
62 |
|
|
Calculating Times by
DB
In excel 2000 I'm trying calculate a total time in
minutes. I have two cells: one cell is the begin time and
the other is the end time. Time is input as a 24...
|
September 27th, 2003 09:56 PM
by M. lane
|
4 |
142 |
|
|
duplicate dates by
db
In a worksheet with multiple columns of dates, how can I identify any
duplicate dates , if any, among columns. many thanks
--
db
|
|
2 |
60 |
|
|
Forms-Scroll Bar function in Excel 2007 by
DB
I recently switched from 2003 to 2007 and cannot seem to find the function to
create scroll bars, check boxes, etc. in Excel 2007.
I'm sure the feature must...
|
September 19th, 2008 04:36 AM
by T. Valko
|
1 |
138 |
|
|
|
|
2 |
59 |
|
|
count nonblank cells with conditions by
DB
I used check marks in a spreadsheet. Some of the cells have a pattern
(yellow) to as an identifier. I need to be able to count the number of cells
that have...
|
March 6th, 2009 09:03 PM
by DB
|
2 |
55 |
|
|
Referencing Sheet Tabs by
DB
Is there a way to use the "value" of a name in a drop-down list to reference
a sheet tab name in a formula?
A1 has a drop down list. When a name (Bob's...
|
October 7th, 2005 06:14 PM
by DB
|
7 |
191 |
|
|
Multiple worksheets by
DB
Hello,
I am working with order forms for different types of
equipment, each having its own worksheet. After selecting
the appropriate sheet, I then want the...
|
October 8th, 2003 02:54 PM
by DB
|
0 |
133 |
|
|
XLSTART doesn't open PMW by
DB
.. What I want to do is attach a formatting option to a toolbar button. I can
generate the formatting and record the macro to do it. I then want to attach
the...
|
|
1 |
90 |
|
|
Formating a cell conditionaly by
DB
Is there a way to have the result of a if function format the text in a cell?
As an example, fi the test is true, the function will turn the text red.
|
|
1 |
74 |
|
|
3D Arrays by
DB
I know there is a way to select arrays on different sheets one array at a
time. Is there is a way to select arrays (located in the exact same cell
range) on...
|
October 10th, 2005 03:50 PM
by DB
|
2 |
83 |
|
|
Today() function by
DB
I have worksheet that uses the =today() fuction as
contents. The spredsheet is saved as a template opened
data entered then saved as a file. Several of these...
|
|
2 |
195 |
|
|
z test in data analysis tools by
db
I used the z test in data analysis to test whether the
mean of two sets of scores were statistically
significant. What I do not understand is how to
interpret...
|
|
1 |
505 |
|
|
|
March 17th, 2006 11:47 AM
by
|
6 |
101 |
|
|
Help with Formula please? by
DB Explorer
Hi
I need help with this please.
I have an excel sheet which gets data pasted onto it, on the basis of
top 5 ranks for that day.
Like This:
A B ...
|
|
3 |
67 |
|
|
Dislpay count of workdays in a month? by
DB Explorer
I have an excel sheet with the month and year in the A row..Like
Jan-06 Feb-06 Mar-06 Apr-06
How do i insert a formula in B row, to display the number of...
|
|
2 |
89 |