|
|
|
|
1 |
158 |
|
|
Countifs by
CD27
I am having problems with a formula. I have a worksheet with 9
columns (A thur I) that contain various numbers. I need to create a
formula that if any cell...
|
April 21st, 2009 06:36 PM
by CD27
|
2 |
73 |
|
|
Random Sample with multiple data points by
Jeremy
I have a list of people with a large number of lines per person. I need to
randomly select two lines for each person. The report is preformatted and...
|
|
1 |
71 |
|
|
Math Functions Not Working Properly by
Harby
I've just noticed that none of my functions are working properly. For
instance, if i insert the numbers 1(cell A1) and 10(cell B1) in adjacent
cells and...
|
|
3 |
77 |
|
|
|
April 21st, 2009 05:39 PM
by CD27
|
1 |
90 |
|
|
|
|
1 |
63 |
|
|
Count if unique by
Gareth.Evans
Hi all, thank you in advance for your help ,and help in past.
I am trying to count the number of "yes" in column C if Column A has a
unique value, see...
( 1 2)
|
|
13 |
162 |
|
|
|
April 21st, 2009 04:20 PM
by Pete_UK
|
1 |
108 |
|
|
Excel Formula by
markillas44
I want to create/use a formula where if a value in column (K) is DEAD (term
used in a drop-down menu in the column) the value in the corresponding (I)
column...
|
April 21st, 2009 04:17 PM
by Pete_UK
|
1 |
75 |
|
|
Protect cell but allow copy command? by
Cindy
Do you know of a way to protect the cell of a worksheet but allow user to
input data? We need to find a way to allow user to input their own data but
not...
|
|
7 |
163 |
|
|
Running Total by
open a adobe file from a command button
I have a spreadsheet that has 2 columns, column A grows, column B shrinks,
when column B gets to 0 or a negative number I want column A to be blank.
Thank...
|
|
7 |
103 |
|
|
Need a function to match up jobs by
Lynda
I have a master sheet with about 50 different job descriptions, then I have
about 20 more worksheets that could have between 20 and maybe 40 job
descriptions...
|
April 21st, 2009 01:59 PM
by Lynda
|
2 |
111 |
|
|
|
April 21st, 2009 01:06 PM
by Eduardo
|
1 |
72 |
|
|
Validation I Hope by
MarsBars
Data entry project - keeps changing & I am not as up to speed in Excel 2007
Select Data for Major Category - i.e. Appliances, Furniture
Sub Category -...
|
April 21st, 2009 09:22 AM
by JLatham
|
1 |
75 |
|
|
|
April 21st, 2009 07:24 AM
by Anil123
|
5 |
114 |
|
|
|
|
3 |
98 |
|
|
A UNIQUE FORMULA by
FLATRATE
EXAMPLE: I want to multiply one cell with a dollar amount in it, by a cell
that has a quantity of employees in it. I want the dollar amount to remain
the...
|
|
5 |
63 |
|
|
Copying Conditional Formatting rule by
Hartmut \(Harry\) Kloppert
Hi,
I'm using XL2007.
I'm applying the rule that if
=A$1"" the cells A1;A3 should get colored.
Works fine.
Now I have to copy this rule to 40 other places...
|
April 21st, 2009 02:28 AM
by Sheeloo
|
1 |
72 |
|
|
|
|
2 |
71 |
|
|
|
April 21st, 2009 12:36 AM
by 947tefi
|
0 |
105 |