|
|
Questions on Define Names by
AccessHelp
Good morning,
I use define names in my Excel file, and I have about 1800 define names in
that file.
From time to time, I would like to make changes to the...
|
|
3 |
69 |
|
|
|
November 10th, 2008 03:35 PM
by Tdp
|
6 |
77 |
|
|
Conditional formatting by
Caroline
Hello,
Using Excel 2007, I want cells in a column to be formatted according to
cells in a different column and I want it to work so that if A1="text", B1...
|
|
1 |
83 |
|
|
data validation using formula result by
jpzachar
Hello....hope you can help....thanks in advance!
I have a formula which is =COUNTIF(C100:M100,0). I want to show an error
message box when the result of...
|
November 10th, 2008 03:33 PM
by jpzachar
|
2 |
73 |
|
|
|
|
0 |
78 |
|
|
|
November 10th, 2008 02:40 PM
by Bob I
|
3 |
111 |
|
|
Exact Match in Vlookup by
Mark Allen
I am using this formula in a vlookup:
=VLOOKUP(B4,'Sheet1'!$A$2:$E$10000,2)
Hoever I need an exact match, sometimes it returns the close match.
Any...
|
November 10th, 2008 02:40 PM
by Mike H
|
5 |
111 |
|
|
|
November 10th, 2008 02:37 PM
by Bob I
|
6 |
134 |
|
|
|
|
2 |
117 |
|
|
Saving spreadsheet by
LilOlLady
I have a very large password protected spreadsheet. When I save instead of
saving the updated spreadsheet a back up copy is created. This is creating...
|
|
1 |
65 |
|
|
view different parts of sheet - split view by
mami
I want to do the following:
I have one sheet that mainly has tables with data and tables with totals
from these data etc.
I would like to have something like...
|
November 10th, 2008 01:04 PM
by mami
|
2 |
71 |
|
|
Bold in Sub total by
Unknown User[_2_]
Is there any short cut to high light in bold the sub total after the subtotal
exercise.
Your advise is important, thank you very much.
( 1 2)
|
|
10 |
95 |
|
|
IF/OR Statement needed by
Ross
/Hi to all
I have a MAX statement that I think I need to add an If/Or statement in
front of to return a blank if the cell shows either a blank, a minus amt,...
|
November 10th, 2008 12:51 PM
by Ross
|
2 |
69 |
|
|
|
November 10th, 2008 12:46 PM
by Buzz
|
0 |
59 |
|
|
data validation rule by
Amin
Hi How do i slove this question? In the order form worsheet, all customer
orders should be based on product in the product_List table. in the range
B2:B20,...
|
November 10th, 2008 12:26 PM
by Amin
|
4 |
61 |
|
|
printer problems by
JimBUFF
Shane Devenshire, the info you gave was very helpful in converting text to
numbers. Thanks again. How do I address the problem with the printer? As
mentioned...
|
November 10th, 2008 11:59 AM
by JimBUFF
|
0 |
55 |
|
|
|
|
1 |
64 |
|
|
Use of INDIRECT and quotation marks by
Babymech
I'm trying to put together a very simple line formula to give me a SUMPRODUCT
from another worktab. I am entering the formula in the main tab, and I want
it...
|
|
1 |
61 |
|
|
|
November 10th, 2008 10:24 AM
by Mike H
|
2 |
93 |
|
|
Hlookup extension by
Anto111
Hi Guys,
I am currently using the formula: =Hlookup($B$36,$D$2:BB:42,2,False). What I
need to add however is something that will return the corresponding...
|
November 10th, 2008 10:12 AM
by Pete_UK
|
1 |
77 |