|
|
|
|
6 |
93 |
|
|
|
|
3 |
92 |
|
|
|
|
3 |
69 |
|
|
How do I unprotect a spreadsheet? by
Sofiya
I received a spreadsheet from my client and while I can view all the pages, I
can only print some, even if I select print entire worksheet.
How can I...
|
|
1 |
57 |
|
|
VLOOKUP with a Named Range argument by
modernminstrel
I am using a VLOOKUP to refer to a table that is a Defined Name/Named Range.
When I use the Defined Name directly in the function the Function works
fine....
|
|
1 |
93 |
|
|
|
October 13th, 2008 03:53 PM
by Derro
|
0 |
70 |
|
|
Adding suffix to column entries by
NCdesigner
I have a column of 11,000 entries. These are stock numbers for a website
store. The image that goes with each item has the same number. I need to add
".jpg"...
|
|
5 |
59 |
|
|
Automating search and replace by
Wellman[_2_]
I'm trying to do something simple, yet I can't figure it out.
I have two spreadsheet. One includes company names and "codes":
QWE843 | Apple
FER244 |...
|
|
2 |
54 |
|
|
Countif based on two criteria by
MJKelly
Hi,
I have a number of duties which I have broken down by tasks. I want
to summarise the amount of different tasks for each time window for
each day. I have...
|
October 13th, 2008 03:39 PM
by MJKelly
|
4 |
70 |
|
|
|
|
1 |
59 |
|
|
SumIf conditional to date range by
IlliniDan
I have the following data set:
A B
1 10/7/2008
2
3 10/1/2008 92
4 10/8/2008 59
5 10/17/2008 31
6 10/22/2008 42
7 10/29/2008 28
|
|
5 |
86 |
|
|
|
October 13th, 2008 02:57 PM
by Nicky
|
3 |
101 |
|
|
Problem w/vlookup by
Sandy
I have created a employee absentee form. In comment area, want to type in
number from range that automatically types in description from same...
|
|
5 |
60 |
|
|
Totaling functions in Excel by
SueL
Hi
I need to add totals with logical functions in an excel spreadsheet
I have a list of books, teachers, classes etc and I need a function that
will lookup...
|
October 13th, 2008 11:50 AM
by SueL
|
2 |
80 |
|
|
|
October 13th, 2008 11:09 AM
by Paul
|
2 |
59 |
|
|
Validation Formula only worked once. by
Rick Arends
I have a drop down list in cell B40. In the validation I wrote
=If(A40="","",FORTYB) where "FORTYB" is the name of a list. It worked
perfectly, only filling...
|
October 13th, 2008 10:54 AM
by Max
|
2 |
84 |
|
|
|
|
1 |
61 |
|
|
SUMPRODUCT arguments by
Chris T-M
Working with SUMPRODUCT for the first time. Can someone explain the use of
the dashes following the command? I've seen from none to (I think) 4...
I started...
|
|
3 |
70 |
|
|
|
October 13th, 2008 10:26 AM
by Tippo22
|
4 |
55 |
|
|
lookup database by
ellebelle
Hi,
I have a database
S = 5
UM = 4
MM = 3
LM = 2
J = 1
|
October 13th, 2008 09:17 AM
by Pete_UK
|
3 |
63 |