|
|
Replace #N/A with 0 by
Emece
When I use the vLookup formula and the result is #N/A, I need to replace this
with a 0, is this possible in only one formula?
Thanks in...
|
|
1 |
203 |
|
|
Scroll bar disappears when panes frozen by
AIS Jay
Hi
When I freeze the panes on a spreadsheet the right scroll button on the
bottom scroll bar disappears. Also a bunch of vertical lines appear within
the...
|
March 30th, 2010 04:55 PM
by AIS Jay
|
0 |
145 |
|
|
Dragging a formula across the row in 2007 by
Carolyn
When I drag from one cell to the next it puts in the correct forumla (i.e.,
O16+O31 is P16+P31 in the next cell); however, it puts the value from the O...
|
March 30th, 2010 04:53 PM
by Carolyn
|
2 |
184 |
|
|
Need a quanity of items printed by
DevilDog1978
I am working with Excel 2003. I am new to excel and having some difficulties.
I Have a form that requires 5 pages be printed out. WhAT I am trying to do is...
|
|
4 |
261 |
|
|
|
March 30th, 2010 04:35 PM
by John
|
0 |
170 |
|
|
|
|
1 |
173 |
|
|
VBA code and protected cells by
manni
Hello -
I created a form template in excel and I unlocked various cells and then
protected the sheet so that users who completed the form would only be able...
|
|
9 |
302 |
|
|
UNREADABLE CONTENT by
Tree
We receive an unreadable content error in our Excel (happens on both
computers) spreadsheet. This was a 2003 file that we have converted to 2007
and has an...
|
March 30th, 2010 04:16 PM
by Tree
|
0 |
152 |
|
|
Measure on the date different by
Sky[_3_]
Hi,
I had a huge file of aroiund 10 000 line.
This 10 000 line only consist of 500 items.
I wish to have an analyise a information.
Example
in the file it...
|
|
0 |
128 |
|
|
Date Difference by
Maanu
Hi,
My DOB is 2-Feb-1970.. I want to know my age on 1-Jan-2010 in Years,Months
and days for Eg: 10 Years,9 months and 10 days.
How can I do this in...
|
March 30th, 2010 03:52 PM
by FSt1
|
4 |
157 |
|
|
=TODAY() and HLOOKUP - help needed by
GD
Hi, I am building a model that I am trying to 'automate' as well as possible
to reduce running time of scenario work. The data I utilise is in monthly...
|
|
2 |
145 |
|
|
|
|
0 |
174 |
|
|
Data collection Sum/Total by
Michael_R
Here's how I understand your setup:
Column A has 365 dates (01.Jan - 31.Dec) (starting in A2)
Column B has the weekday of the date in col.A. (starting in B2....
|
|
1 |
124 |
|
|
Excel 2007 - A Conditional Formatting ?'s by
roadkill
Frankly I'm very annoyed with conditional formatting in Excel 2007 but am
hoping that there are settings or something that will at least take care of
the...
|
|
1 |
123 |
|
|
Drop down list by
Asoka Walpitagama - Brandix College IT
When right clicked on a cell there appears an option called 'pick from drop
down list',. How to use this feature & does it have any relationship to Data...
|
|
2 |
185 |
|
|
Ho do i create drop down list? by
Peter
I need choices to be saved within drop-down list!
"Eduardo" wrote:
Hi,
look into Debra web she has excellent explanation and examples
...
|
March 30th, 2010 03:34 PM
by Eduardo
|
1 |
171 |
|
|
cumulative counting by
Roy Gudgeon[_2_]
I have a sales database with 300 records (sales orders) allocated to 6
salespersons. The database is added to constantly.
I want to be able to run a report...
|
|
0 |
145 |
|
|
DropDown aand Auto Fill by
מיכאל (מיקי) אבידן
'Tools' 'Options...' 'Edit' tab check 'Allow Auto-fill of cell values'
'OK'
Micky
"Maanu" wrote:
Hi,
I have column with DropDown List.. The...
|
|
0 |
192 |
|
|
DropDown aand Auto Fill by
Pritesh[_2_]
If you have your three (or any other) values, above or below, in same column
"continued without line-gap", then this works the way you are asking.
If its...
|
|
0 |
144 |
|
|
|
|
3 |
182 |