|
|
make a minus a zero by
James
How can I turn a minus result into a zero.
For example....
Column A = Stock Levels Needed /50
Column B = Actual Stock Levels /60
Column C =...
|
|
2 |
139 |
|
|
Formula for finding an element by
bim-bom
Hi,
I have a spreadsheet:
1 2 100
5 6 200
5 11 300
I want to find a row which where first column has a specific value and
the second column has a specific...
|
November 21st, 2009 10:22 PM
by T. Valko
|
4 |
134 |
|
|
|
November 21st, 2009 09:30 PM
by gwaxiom
|
0 |
149 |
|
|
Calculating Work Hours by
Brent[_8_]
I've seen some posts using Workdays function to find elapsed time from
date/time A1 to date/time B1; I'm trying to utilize this, but I have some
data that...
|
|
1 |
168 |
|
|
X-Y gridded data into columns by
CM[_4_]
Hello. I have datasets exported from map data as large grids
(1024x768). I want to transform them into 3 long (768000 rows)
columns, with X, Y, and the value...
|
November 21st, 2009 09:16 PM
by CM[_4_]
|
2 |
137 |
|
|
Forms by
MarkOffice2007
I have a worksheet and would like to create a form and link the worksheet to
it.
Then, if I enter information into the worksheet it would also appear in the...
|
November 21st, 2009 08:25 PM
by FSt1
|
1 |
114 |
|
|
|
November 21st, 2009 08:16 PM
by patk
|
0 |
117 |
|
|
Excel 2007 Won't Start by
Audrey Clement
When I try to access Excel 2007, I get the following error message from
Windows Installer:
"Preparing to Install"
But nothing installs and Excel 2007, which...
|
|
0 |
126 |
|
|
|
November 21st, 2009 06:14 PM
by kirsty
|
2 |
128 |
|
|
Formatting / Formula by
Telford Tom
Hi,
Not sure if I need conditional formatting or a formula for the following:
If I put a date into a spreadsheet I'd like it to change colour after a set...
|
|
6 |
166 |
|
|
Vlookup found two similar values by
Rechie
When vlooup found two similar values, it always get the first one.
I have the same two values in File 1 but two have two different equivalent
values in File...
|
November 21st, 2009 02:28 PM
by Rechie
|
6 |
135 |
|
|
Confusion with INDEX & MATCH by
thomsonpa
I have a list of numbers on sheet 1 and need to add a code in the next column.
On sheet 2 the first column has the codes, and the next 30 columns have...
|
|
4 |
161 |
|
|
How to round up to the nearest five by
James
How can I make a 34 to a 35 etc etc.
How can i round up any number to the nearest five or ten?
E.G a 39 to a 40, a 6 to a 10 and a 1132 to a 1135.
thanks.
|
November 21st, 2009 12:37 PM
by JLatham
|
3 |
130 |
|
|
Conditional Formats XL2007 by
Telford Tom[_2_]
Sorry, it must be me. This didn't work, things just went straight to Red even
though they're not out of date. In the formula =TODAY()-A1=90 should I be...
|
|
1 |
104 |
|
|
Formulas by
Shobhit jain
I put any formula i.e. =1+1, but result is =1+1 instead of 2. Pl. help
|
|
4 |
130 |
|
|
AutoFilter by
peyman
Hi,
I don't know how come when I filter a column , the column's header ARROW
color is not turning to blue!!!
Any comment?
Thanx
|
|
1 |
118 |
|
|
creating labels from excel spreadsheet by
SHARON
i have a spreadsheet with 5 columns of data that contain address information.
Ex. column A = name, column B = Company, column c = Street etc.
How do i get...
|
|
2 |
134 |
|
|
XIRR by
Marc
10-Oct-07 10000 Goog
20-Nov-08 2000 intc
29-Nov-08 4000 intc
21-Nov-09 goog -20000
21-Nov-09 intc -10000
I have the above data. I want to do a xirr for...
|
|
1 |
114 |
|
|
|
|
2 |
122 |
|
|
Userform list box population by
Alberto Ast[_2_]
I need to have a field in a user form to select from a list of options...
I guess I use listbox but I do not know how does it works... ho do I
populate the...
|
|
3 |
120 |