|
|
Auto fill by
StevenH
I want to auto fill a colum as shown
1
1
2
2
3
3
4
4 ect ect but everytime i do it i end up getting decimals. or sometimes
ill get 3 of a number instead, is...
|
|
3 |
112 |
|
|
Sig Figs by
Alterac
I am working with a series of complex equations. I need them to carry a
constant 4 significant figures throughout the entire spread sheet until it is
rounded...
|
|
3 |
179 |
|
|
CAN YOU SOLVE THIS!!!!!!! by
jimthompson5802
Look @ Hack #25 "Create Validation Lists That Change Based on a Selection
from Another List" in the book "Excel Hacks, 2nd Ed." by D. & R. Hawley
|
|
0 |
139 |
|
|
What's wrong in this Eqn? by
Raz
=IF(OR(TABLE!U6="",ISERROR(TABLE!U6)),"",TABLE!U6)
this is placed in a different sheet.
I want this Eqn to check if the value in Cell U6 of sheet "TABLE" is...
|
January 12th, 2010 07:27 PM
by Mike H
|
1 |
108 |
|
|
|
January 12th, 2010 07:20 PM
by Mike H
|
1 |
113 |
|
|
Mapped vs Network drives by
Greg
hi,
is there a way to show a network drive via formula when a drive is being
mapped?
Different users mapping of the same drive to a various letters is...
|
January 12th, 2010 07:16 PM
by Greg
|
2 |
209 |
|
|
Summing over multiple worksheets by
Alberta Rose
Hi. I have weekly data by Contract number over multiple worksheets. I want
to sum the hours associated with the contract. The contract information will
not...
|
|
1 |
131 |
|
|
|
|
8 |
135 |
|
|
count if equals first non error cell by
John
Hi, I want to count the number of times the number 3 or -3 comes up in A8:A15
depending on whether 3 or -3 comes up first. If 3 is A8 then count how many...
|
|
6 |
176 |
|
|
Use extract into a condition by
Mosqui
I have a sumproduct formula with different conditions. One of them is picking
up only the first 17 caracters of a cell. So...
|
|
5 |
120 |
|
|
If statement by
NEHicks
Is there a way to copy a page to a roll-up worksheet that, when you link it,
any blank cell will stay blank instead of showing 0? I have tried the IF...
|
|
3 |
126 |
|
|
Caps Lock vs Lower Case by
JB
Hi, I need to convert cells that was typed in caps lock only, to lower case.
How do I do this without having to retype the whole cell??
|
|
5 |
141 |
|
|
|
|
1 |
100 |
|
|
Total weekly worksheets to quarterly by
Alberta Rose
Good day. I have multiple worksheets in my workbook. I want to sum the
worksheets by the column called Contract, by quarter. I have made a
quarterly...
|
|
0 |
115 |
|
|
Printing Dates on One Sheet by
SSADA
I have one template that i print for our production floor. Each sheet has
seven dates printed; Monday thru Sunday. I need to print this one template
52...
|
January 12th, 2010 04:01 PM
by SSADA
|
5 |
129 |
|
|
|
|
1 |
100 |
|
|
Cell Reference by
Ankur Bhateja
What I am looking for is that when I enter a formula (In cell B1) to pick up
value in A1. Now I need value from cell A5 in cell B2. Next value I need in
B3...
|
|
1 |
102 |
|
|
|
|
1 |
84 |
|
|
|
|
1 |
102 |
|
|
Functions by
Annie
Hi
I am using Excel 2003 and I am training some people in my company on
functions - I am stuck though and need help on the following functions -
examples of...
|
January 12th, 2010 02:18 PM
by John
|
2 |
104 |